APPS.ECE_CDMO_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 36: hz_cust_acct_sites cas

32: INTO l_EDI_flag,
33: l_Print_flag
34: FROM ece_cdmo_header_v eih,
35: ece_tp_details etd,
36: hz_cust_acct_sites cas
37: WHERE eih.bill_to_address_id = cas.cust_acct_site_id
38: AND cas.tp_header_id = etd.tp_header_id
39: AND etd.document_type = Update_AR.Document_Type
40: AND eih.transaction_id = Update_AR.Transaction_ID;

Line 49: hz_cust_acct_sites_all cas,

45: l_Print_flag
46: FROM
47: ra_customer_trx rct,
48: hz_cust_site_uses_all csu,
49: hz_cust_acct_sites_all cas,
50: ece_tp_headers eth,
51: ece_tp_details etd
52: WHERE
53: rct.bill_to_site_use_id = csu.site_use_id and

Line 70: 'ECE_CDMO_HEADER_V, ECE_TP_DETAILS, HZ_CUST_ACCT_SITES' );

66: xProgress,
67: 'INFO',
68: 'EDI FLAG, PRINT FLAG',
69: 'TABLE_NAME',
70: 'ECE_CDMO_HEADER_V, ECE_TP_DETAILS, HZ_CUST_ACCT_SITES' );
71: -- bug 4718847
72: END;
73:
74: IF l_EDI_Flag = 'Y' AND

Line 208: FROM RA_CUSTOMER_TRX RCT,HZ_CUST_ACCT_SITES A,RA_REMIT_TOS RT,

204: DECLARE
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

Line 273: FROM HZ_CUST_ACCT_SITES HCAS,

269: INTO remit_to_address1, remit_to_address2, remit_to_address3,
270: remit_to_address4, remit_to_city, remit_to_county, remit_to_state,
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