DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCT_RELATE_ALL_M

Line 7855: ---------Insert into hz_cust_acct_relate_all_m--------------

7851: AND su.org_id = m.org_id; --SSUptake
7852:
7853: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
7854:
7855: ---------Insert into hz_cust_acct_relate_all_m--------------
7856: INSERT INTO hz_cust_acct_relate_all_m(
7857: customer_merge_header_id,
7858: cust_account_id ,
7859: related_cust_account_id ,

Line 7856: INSERT INTO hz_cust_acct_relate_all_m(

7852:
7853: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
7854:
7855: ---------Insert into hz_cust_acct_relate_all_m--------------
7856: INSERT INTO hz_cust_acct_relate_all_m(
7857: customer_merge_header_id,
7858: cust_account_id ,
7859: related_cust_account_id ,
7860: last_update_date ,

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

7943: WHERE ( yt.cust_account_id = duplicate_id OR
7944: yt.related_cust_account_id = duplicate_id )
7945: AND m.org_id = yt.org_id ; --SSUptake
7946:
7947: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_RELATE_ALL_M');
7948:
7949:
7950: ---After storing the merge data sucessfully initialize the status to 0
7951: status := 0;