eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECE_TRADING_PARTNERS_PUB dependencies on ECE_TP_DETAILS

Line 318: ece_tp_details etd,

314: TO_CHAR(NULL) region_1,
315: TO_CHAR(NULL) region_2,
316: TO_CHAR(NULL) region_3
317: FROM ce_bank_branches_v cbb,
318: ece_tp_details etd,
319: hz_contact_points hcp,
320: hz_locations hzl,
321: hz_party_sites hps
322: WHERE NVL(UPPER(hcp.edi_ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND

Line 510: ece_tp_details etd

506: TO_CHAR(NULL) region_1,
507: TO_CHAR(NULL) region_2,
508: TO_CHAR(NULL) region_3
509: FROM po_vendor_sites_all pvs,
510: ece_tp_details etd
511: WHERE nvl(pvs.org_id,-99) = NVL(cp_org_id_in,nvl(pvs.org_id,-99)) AND
512: NVL(UPPER(pvs.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
513: pvs.tp_header_id = etd.tp_header_id AND
514: NVL(UPPER(etd.translator_code),' ') LIKE NVL(UPPER(cp_tp_translator_code),'%') AND

Line 631: ece_tp_details etd

627: cas.cust_acct_site_id address_id,
628: cas.ece_tp_location_code tp_location_code,
629: cas.party_site_id party_site_id
630: FROM hz_cust_acct_sites_all cas,
631: ece_tp_details etd
632: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND
633: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
634: cas.tp_header_id = etd.tp_header_id AND
635: NVL(UPPER(etd.translator_code),' ') LIKE NVL(UPPER(cp_tp_translator_code),'%') AND

Line 2911: ece_tp_details etd

2907: cas.cust_acct_site_id
2908: from hz_cust_acct_sites cas,
2909: hz_cust_accounts ca,
2910: hz_parties pt,
2911: ece_tp_details etd
2912: where
2913: etd.translator_code = p_translator_code
2914: and cas.ece_tp_location_code = p_location_code_ext
2915: and etd.tp_header_id = cas.tp_header_id

Line 2923: ece_tp_details etd

2919: cursor po_site is
2920: select pv.vendor_id, pvs.vendor_site_id
2921: from po_vendors pv, po_vendor_sites pvs,
2922: -- ece_tp_headers ec,
2923: ece_tp_details etd
2924: where
2925: etd.translator_code = p_translator_code
2926: -- and etd.tp_header_id = ec.tp_header_id
2927: and pvs.ece_tp_location_code = p_location_code_ext

Line 2934: ece_tp_details etd,

2930:
2931: cursor ap_bank is
2932: select cbb.branch_party_id
2933: from ce_bank_branches_v cbb,
2934: ece_tp_details etd,
2935: hz_contact_points hcp
2936: where
2937: etd.translator_code = p_translator_code
2938: and hcp.edi_ece_tp_location_code = p_location_code_ext