[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select cas.cust_account_id ,
cas.cust_acct_site_id
from hz_cust_acct_sites cas,
hz_cust_accounts ca,
hz_parties pt,
ece_tp_details etd
where
etd.translator_code = p_translator_code
and cas.ece_tp_location_code = p_location_code_ext
and etd.tp_header_id = cas.tp_header_id
and cas.cust_account_id = ca.cust_account_id
and ca.party_id = pt.party_id;
select pv.vendor_id, pvs.vendor_site_id
from po_vendors pv, po_vendor_sites pvs,
-- ece_tp_headers ec,
ece_tp_details etd
where
etd.translator_code = p_translator_code
-- and etd.tp_header_id = ec.tp_header_id
and pvs.ece_tp_location_code = p_location_code_ext
and etd.tp_header_id = pvs.tp_header_id
and pvs.vendor_id = pv.vendor_id;
select cbb.branch_party_id
from ce_bank_branches_v cbb,
ece_tp_details etd,
hz_contact_points hcp
where
etd.translator_code = p_translator_code
and hcp.edi_ece_tp_location_code = p_location_code_ext
and hcp.edi_tp_header_id = etd.tp_header_id
and hcp.owner_table_id = cbb.branch_party_id
and hcp.owner_table_name = 'HZ_PARTIES'
and hcp.contact_point_type = 'EDI';
select cas.cust_account_id ,
cas.cust_acct_site_id
from hz_cust_acct_sites cas,
hz_cust_accounts ca,
hz_parties pt,
ece_tp_headers eth
where
eth.tp_reference_ext1 = p_reference_ext1
and eth.tp_reference_ext2 = p_reference_ext2
and eth.tp_header_id = cas.tp_header_id
and cas.cust_account_id = ca.cust_account_id
and ca.party_id = pt.party_id;
select pv.vendor_id, pvs.vendor_site_id
from po_vendors pv, po_vendor_sites pvs,
ece_tp_headers eth
where
eth.tp_reference_ext1 = p_reference_ext1
and eth.tp_reference_ext2 = p_reference_ext2
and eth.tp_header_id = pvs.tp_header_id
and pvs.vendor_id = pv.vendor_id;
select cbb.branch_party_id
from ce_bank_branches_v cbb,
ece_tp_headers eth,
hz_contact_points hcp
where
eth.tp_reference_ext1 = p_reference_ext1
and eth.tp_reference_ext2 = p_reference_ext2
and eth.tp_header_id = hcp.edi_tp_header_id
and hcp.owner_table_id = cbb.branch_party_id
and hcp.owner_table_name = 'HZ_PARTIES'
and hcp.contact_point_type = 'EDI';
select
cas.ece_tp_location_code,
ec.tp_reference_ext1,
ec.tp_reference_ext2
from hz_cust_acct_sites cas,
ece_tp_headers ec
where
ec.tp_header_id = cas.tp_header_id
and cas.cust_acct_site_id = p_entity_address_id;
select pvs.ece_tp_location_code,
ec.tp_reference_ext1,
ec.tp_reference_ext2
from ece_tp_headers ec, po_vendor_sites pvs
where
pvs.vendor_site_id = p_entity_address_id
and pvs.tp_header_id = ec.tp_header_id;
select hcp.edi_ece_tp_location_code,
ec.tp_reference_ext1,
ec.tp_reference_ext2
from ece_tp_headers ec,
ce_bank_branches_v cbb,
hz_contact_points hcp
where
cbb.branch_party_id = p_entity_address_id
and hcp.edi_tp_header_id = ec.tp_header_id
and hcp.owner_table_id = cbb.branch_party_id
and hcp.owner_table_name = 'HZ_PARTIES'
and hcp.contact_point_type = 'EDI';
select tpd.tp_detail_id
from ece_tp_details tpd,hz_cust_acct_sites cas
where tpd.tp_header_id = cas.tp_header_id
and tpd.document_id = p_transaction_type
and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
and cas.cust_acct_site_id = p_entity_id;
select tpd.tp_detail_id
from ece_tp_details tpd,po_vendor_sites povs
where tpd.tp_header_id = povs.tp_header_id
and tpd.document_id = p_transaction_type
and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
and povs.vendor_site_id = p_entity_id;
select tpd.tp_detail_id
from ece_tp_details tpd,
ce_bank_branches_v cbb,
hz_contact_points hcp
where tpd.tp_header_id = hcp.edi_tp_header_id
and tpd.document_id = p_transaction_type
and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
and cbb.branch_party_id = p_entity_id
and cbb.branch_party_id = hcp.owner_table_id
and hcp.owner_table_name = 'HZ_PARTIES'
and hcp.contact_point_type = 'EDI';
select tpd.tp_detail_id
from ece_tp_details tpd,hr_locations hrl
where tpd.tp_header_id = hrl.tp_header_id
and tpd.document_id = p_transaction_type
and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
and hrl.location_id = p_entity_id;