33: select cas.cust_account_id ,
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
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
67: and hcp.owner_table_id = cbb.branch_party_id
68: and hcp.owner_table_name = 'HZ_PARTIES'
69: and hcp.contact_point_type = 'EDI';
70:
71: BEGIN
72:
278: select cas.cust_account_id ,
279: cas.cust_acct_site_id
280: from hz_cust_acct_sites cas,
281: hz_cust_accounts ca,
282: hz_parties pt,
283: ece_tp_headers eth
284: where
285: eth.tp_reference_ext1 = p_reference_ext1
286: and eth.tp_reference_ext2 = p_reference_ext2
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
310: and hcp.owner_table_id = cbb.branch_party_id
311: and hcp.owner_table_name = 'HZ_PARTIES'
312: and hcp.contact_point_type = 'EDI';
313:
314: BEGIN
315:
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
543: and hcp.owner_table_name = 'HZ_PARTIES'
544: and hcp.contact_point_type = 'EDI';
545:
546: BEGIN
547:
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
765: and cbb.branch_party_id = hcp.owner_table_id
766: and hcp.owner_table_name = 'HZ_PARTIES'
767: and hcp.contact_point_type = 'EDI';
768:
769: cursor type_location is
770: select tpd.tp_detail_id