DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_SITE_USES_ALL_M

Line 7956: ---------Insert into hz_cust_site_uses_all_m--------------

7952: AND acs.org_id = m.org_id ;
7953:
7954: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');
7955:
7956: ---------Insert into hz_cust_site_uses_all_m--------------
7957: INSERT INTO hz_cust_site_uses_all_m(
7958: customer_merge_header_id,
7959: site_use_id ,
7960: cust_acct_site_id ,

Line 7957: INSERT INTO hz_cust_site_uses_all_m(

7953:
7954: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');
7955:
7956: ---------Insert into hz_cust_site_uses_all_m--------------
7957: INSERT INTO hz_cust_site_uses_all_m(
7958: customer_merge_header_id,
7959: site_use_id ,
7960: cust_acct_site_id ,
7961: last_update_date ,

Line 8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');

8202: and cm.set_number = set_num ) m,hz_cust_site_uses_all su --SSUptake
8203: WHERE su.site_use_id = duplicate_site_id
8204: AND su.org_id = m.org_id; --SSUptake
8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
8207:
8208: ---------Insert into hz_cust_acct_relate_all_m--------------
8209: INSERT INTO hz_cust_acct_relate_all_m(
8210: customer_merge_header_id,