APPS.ECE_CDMO_UTIL dependencies on ECE_TP_DETAILS

Line 35: ece_tp_details etd,

31: print_flag
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

Line 51: ece_tp_details etd

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
54: csu.cust_acct_site_id = cas.cust_acct_site_id and
55: cas.tp_header_id = eth.tp_header_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