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.EC_TRADING_PARTNER_PVT dependencies on HZ_CONTACT_POINTS

Line 62: hz_contact_points hcp

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
66: and hcp.edi_tp_header_id = etd.tp_header_id

Line 305: hz_contact_points hcp

301: cursor ap_bank is
302: select cbb.branch_party_id
303: from ce_bank_branches_v cbb,
304: ece_tp_headers eth,
305: hz_contact_points hcp
306: where
307: eth.tp_reference_ext1 = p_reference_ext1
308: and eth.tp_reference_ext2 = p_reference_ext2
309: and eth.tp_header_id = hcp.edi_tp_header_id

Line 538: hz_contact_points hcp

534: ec.tp_reference_ext1,
535: ec.tp_reference_ext2
536: from ece_tp_headers ec,
537: ce_bank_branches_v cbb,
538: hz_contact_points hcp
539: where
540: cbb.branch_party_id = p_entity_address_id
541: and hcp.edi_tp_header_id = ec.tp_header_id
542: and hcp.owner_table_id = cbb.branch_party_id

Line 760: hz_contact_points hcp

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
763: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
764: and cbb.branch_party_id = p_entity_id