DBA Data[Home] [Help]

APPS.ECE_CDMO_UTIL dependencies on HZ_PARTY_SITES

Line 209: HZ_PARTY_SITES HPS,HZ_LOCATIONS LOC

205: -- bug 4718847
206: CURSOR remit_cur IS
207: SELECT RT.ADDRESS_ID
208: FROM RA_CUSTOMER_TRX RCT,HZ_CUST_ACCT_SITES A,RA_REMIT_TOS RT,
209: HZ_PARTY_SITES HPS,HZ_LOCATIONS LOC
210: WHERE RCT.CUSTOMER_TRX_ID = get_remit_address.customer_trx_id
211: AND RCT.BILL_TO_ADDRESS_ID = A.CUST_ACCT_SITE_ID
212: AND A.PARTY_SITE_ID = HPS.PARTY_SITE_ID
213: AND HPS.LOCATION_ID = LOC.LOCATION_ID

Line 275: HZ_PARTY_SITES HPS

271: remit_to_province, remit_to_country, remit_to_postal_code,
272: remit_to_code_int
273: FROM HZ_CUST_ACCT_SITES HCAS,
274: HZ_LOCATIONS LOC,
275: HZ_PARTY_SITES HPS
276: WHERE HPS.PARTY_SITE_ID = HCAS.PARTY_SITE_ID
277: AND HPS.LOCATION_ID = LOC.LOCATION_ID
278: AND HCAS.CUST_ACCT_SITE_ID = l_remit_to_address_id;
279: