DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_ACCT_RELATE_ALL_M

Line 996: FROM hz_cust_acct_relate_all_m crelf, hz_cust_acct_relate_all crelt

992: WHERE OWNER_TABLE_ID = customer_id
993: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
994: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
995: )
996: FROM hz_cust_acct_relate_all_m crelf, hz_cust_acct_relate_all crelt
997: WHERE ((crelf.cust_account_id = duplicate_id
998: AND crelt.cust_account_id = customer_id
999: AND crelt.related_cust_account_id = crelf.related_cust_account_id)
1000: OR