4 Replies Latest reply on Sep 18, 2020 4:32 AM by Tushar Chaugule

    MDM Validation rule on child table using attribute from parent table

    Priyanka Sharma Active Member

      Is it possible to downgrade trust on child table when  column from one of the peer table is Inactive.Parent for both child table and Peer table is party table.

       

      We are doing regular load passing pkey_src_object.

      This is what we have used so far

       

      WHERE S.PRTY_FK IN(SELECT A.PKEY_SRC_OBJECT FROM

      C_BO_PRTY_XREF A,

      C_BO_PRTY_EMPLYMNT_XREF B,

      C_BO_PRTY_RLE_PHN_COMM_XREF C

      WHERE A.ROWID_XREF=B.PRTY_FK

      AND A.ROWID_XREF=C.PRTY_FK

      AND B.EMPLYMNT_STS IN('INA','TER'))