3541: AND okh.id=p_chr_id
3542: AND okh.id=k_party.dnz_chr_id
3543: AND EXISTS
3544: (SELECT 1
3545: FROM HZ_CUST_ACCOUNTS CA1
3546: WHERE CA1.party_id = k_party.object1_id1
3547: AND CA1.status = 'A'
3548: AND CA1.CUST_ACCOUNT_ID = CII.Owner_party_account_id
3549: UNION ALL
3547: AND CA1.status = 'A'
3548: AND CA1.CUST_ACCOUNT_ID = CII.Owner_party_account_id
3549: UNION ALL
3550: SELECT 1
3551: FROM HZ_CUST_ACCOUNTS CA2,
3552: HZ_CUST_ACCT_RELATE_ALL REL
3553: WHERE CA2.party_id = k_party.object1_id1
3554: AND REL.cust_account_id = CA2.CUST_ACCOUNT_ID
3555: AND REL.org_id = okh.AUTHORING_ORG_ID