APPS.EC_TRADING_PARTNER_PVT dependencies on ECE_TP_DETAILS

Line 38: ece_tp_details etd

34: cas.cust_acct_site_id
35: from hz_cust_acct_sites cas,
36: hz_cust_accounts ca,
37: hz_parties pt,
38: ece_tp_details etd
39: where
40: etd.translator_code = p_translator_code
41: and cas.ece_tp_location_code = p_location_code_ext
42: and etd.tp_header_id = cas.tp_header_id

Line 50: ece_tp_details etd

46: cursor po_site is
47: select pv.vendor_id, pvs.vendor_site_id
48: from po_vendors pv, po_vendor_sites pvs,
49: -- ece_tp_headers ec,
50: ece_tp_details etd
51: where
52: etd.translator_code = p_translator_code
53: -- and etd.tp_header_id = ec.tp_header_id
54: and pvs.ece_tp_location_code = p_location_code_ext

Line 61: ece_tp_details etd,

57:
58: cursor ap_bank is
59: select cbb.branch_party_id
60: from ce_bank_branches_v cbb,
61: ece_tp_details etd,
62: hz_contact_points hcp
63: where
64: etd.translator_code = p_translator_code
65: and hcp.edi_ece_tp_location_code = p_location_code_ext

Line 742: from ece_tp_details tpd,hz_cust_acct_sites cas

738: x_tp_detail_id NUMBER;
739:
740: cursor type_customer is
741: select tpd.tp_detail_id
742: from ece_tp_details tpd,hz_cust_acct_sites cas
743: where tpd.tp_header_id = cas.tp_header_id
744: and tpd.document_id = p_transaction_type
745: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
746: and cas.cust_acct_site_id = p_entity_id;

Line 750: from ece_tp_details tpd,po_vendor_sites povs

746: and cas.cust_acct_site_id = p_entity_id;
747:
748: cursor type_supplier is
749: select tpd.tp_detail_id
750: from ece_tp_details tpd,po_vendor_sites povs
751: where tpd.tp_header_id = povs.tp_header_id
752: and tpd.document_id = p_transaction_type
753: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
754: and povs.vendor_site_id = p_entity_id;

Line 758: from ece_tp_details tpd,

754: and povs.vendor_site_id = p_entity_id;
755:
756: cursor type_bank is
757: select tpd.tp_detail_id
758: from ece_tp_details tpd,
759: ce_bank_branches_v cbb,
760: hz_contact_points hcp
761: where tpd.tp_header_id = hcp.edi_tp_header_id
762: and tpd.document_id = p_transaction_type

Line 771: from ece_tp_details tpd,hr_locations hrl

767: and hcp.contact_point_type = 'EDI';
768:
769: cursor type_location is
770: select tpd.tp_detail_id
771: from ece_tp_details tpd,hr_locations hrl
772: where tpd.tp_header_id = hrl.tp_header_id
773: and tpd.document_id = p_transaction_type
774: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
775: and hrl.location_id = p_entity_id;