APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 149: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCT_SITES_ALL cas2

145: null, -- from common_obj_id
146: rm.customer_address_id, -- to cust_acct_site_id
147: cas2.party_site_id, -- to party_site_id
148: null ) -- to common_obj_id
149: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCT_SITES_ALL cas2
150: where rm.customer_merge_header_id = p_customer_merge_header_id
151: and rm.duplicate_address_id = cas.cust_acct_site_id(+)
152: and rm.customer_address_id = cas2.cust_acct_site_id(+)
153: group by rm.duplicate_address_id, rm.customer_address_id,

Line 185: FROM HZ_CUST_ACCT_SITES_ALL

181: and mh.customer_id = ca2.cust_account_id;
182:
183: CURSOR other_ou(l_ca_id NUMBER, l_cas_id NUMBER, l_ps_id NUMBER) IS
184: SELECT 'Y'
185: FROM HZ_CUST_ACCT_SITES_ALL
186: WHERE cust_account_id = l_ca_id
187: AND cust_acct_site_id <> l_cas_id
188: AND party_site_id = l_ps_id
189: AND rownum = 1;

Line 205: FROM HZ_CUST_ACCT_SITES_ALL_M

201: AND rownum = 1;
202:
203: CURSOR get_deleted_cs_psid(l_cmhdr_id NUMBER, l_cust_acct_site_id NUMBER) IS
204: SELECT party_site_id
205: FROM HZ_CUST_ACCT_SITES_ALL_M
206: WHERE cust_acct_site_id = l_cust_acct_site_id
207: AND customer_merge_header_id = l_cmhdr_id
208: AND rownum = 1;
209:

Line 423: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCT_SITES_ALL cs

419: cs.cust_account_id, -- to cust_acct_id
420: mph.to_parent_entity_id, -- to party_site_id
421: null ) -- to common_obj_id
422: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,
423: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCT_SITES_ALL cs
424: where mb.batch_id = l_batch_id
425: and mb.batch_id = mp.batch_id
426: and mp.batch_party_id = mph.batch_party_id
427: and mph.merge_dict_id = md.merge_dict_id

Line 430: and md.entity_name = 'HZ_CUST_ACCT_SITES_ALL'

426: and mp.batch_party_id = mph.batch_party_id
427: and mph.merge_dict_id = md.merge_dict_id
428: and cs.cust_acct_site_id = mph.from_entity_id
429: and cs.cust_account_id = l_fcaid
430: and md.entity_name = 'HZ_CUST_ACCT_SITES_ALL'
431: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ),
432: CAST(MULTISET(
433: SELECT CRMINTEG_HZ_MRGDTIL_OBJ(
434: 'CONTACT',

Line 599: FROM HZ_CUST_ACCT_SITES_ALL

595: AND rownum = 1;
596:
597: CURSOR get_cas_id(l_ps_id NUMBER, l_ca_id NUMBER, l_org_id NUMBER) IS
598: SELECT cust_acct_site_id
599: FROM HZ_CUST_ACCT_SITES_ALL
600: WHERE cust_account_id = l_ca_id
601: AND party_site_id = l_ps_id
602: AND org_id = l_org_id
603: AND rownum = 1;

Line 790: FROM HZ_CUST_ACCT_SITES_ALL

786: AND rownum = 1;
787:
788: CURSOR get_cas_id(l_ps_id NUMBER, l_ca_id NUMBER, l_org_id NUMBER) IS
789: SELECT cust_acct_site_id
790: FROM HZ_CUST_ACCT_SITES_ALL
791: WHERE cust_account_id = l_ca_id
792: AND party_site_id = l_ps_id
793: AND org_id = l_org_id
794: AND rownum = 1;