DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARTRX dependencies on HZ_CUST_ACCT_SITES

Line 1082: from hz_cust_acct_sites ra

1078: and m.request_id = req_id
1079: and m.set_number = set_num
1080: and rai.orig_system_bill_address_ref IN ( select
1081: ra.orig_system_reference
1082: from hz_cust_acct_sites ra
1083: where m.duplicate_address_id = ra.cust_acct_site_id)
1084: union
1085: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1086: ,rai.ROWID

Line 1106: from hz_cust_acct_sites ra

1102: and m.request_id = req_id
1103: and m.set_number = set_num
1104: and rai.orig_system_ship_address_ref IN (select
1105: ra.orig_system_reference
1106: from hz_cust_acct_sites ra
1107: where m.duplicate_address_id = ra.cust_acct_site_id)
1108: ;
1109:
1110: l_last_fetch BOOLEAN := FALSE;