DBA Data[Home] [Help]

APPS.ZX_PARTY_MERGE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1078: HZ_CUST_ACCT_SITES_ALL cas,

1074: cas2.cust_acct_site_id
1075: order by rm.customer_site_id
1076: ) as party_site_num
1077: FROM RA_CUSTOMER_MERGES rm,
1078: HZ_CUST_ACCT_SITES_ALL cas,
1079: HZ_CUST_ACCT_SITES_ALL cas2,
1080: ZX_PARTY_TAX_PROFILE ptp
1081: WHERE rm.request_id = l_request_id
1082: AND rm.duplicate_address_id = cas.cust_acct_site_id

Line 1079: HZ_CUST_ACCT_SITES_ALL cas2,

1075: order by rm.customer_site_id
1076: ) as party_site_num
1077: FROM RA_CUSTOMER_MERGES rm,
1078: HZ_CUST_ACCT_SITES_ALL cas,
1079: HZ_CUST_ACCT_SITES_ALL cas2,
1080: ZX_PARTY_TAX_PROFILE ptp
1081: WHERE rm.request_id = l_request_id
1082: AND rm.duplicate_address_id = cas.cust_acct_site_id
1083: AND rm.customer_address_id = cas2.cust_acct_site_id