DBA Data[Home] [Help]

APPS.IEX_MERGE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 668: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca

664: ,yt.STRATEGY_ID
665: ,yt.CUST_ACCOUNT_ID
666: ,hca.party_id
667: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
668: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca
669: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
670: hca.cust_account_id = m.customer_id AND
671: m.process_flag = 'N' AND
672: m.request_id = req_id AND

Line 1187: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c

1183: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1184: ,yt.DELINQUENCY_ID
1185: ,yt.CUST_ACCOUNT_ID
1186: ,c.party_id
1187: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c
1188: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1189: m.process_flag = 'N' AND
1190: m.request_id = req_id AND
1191: m.set_number = set_num and