DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 3545: FROM HZ_CUST_ACCOUNTS CA1

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

Line 3551: FROM HZ_CUST_ACCOUNTS CA2,

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