[Home] [Help]
45:
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
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
287: and eth.tp_header_id = cas.tp_header_id
290:
291: cursor po_site is
292: select pv.vendor_id, pvs.vendor_site_id
293: from po_vendors pv, po_vendor_sites pvs,
294: ece_tp_headers eth
295: where
296: eth.tp_reference_ext1 = p_reference_ext1
297: and eth.tp_reference_ext2 = p_reference_ext2
298: and eth.tp_header_id = pvs.tp_header_id
300:
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
513: cas.ece_tp_location_code,
514: ec.tp_reference_ext1,
515: ec.tp_reference_ext2
516: from hz_cust_acct_sites cas,
517: ece_tp_headers ec
518: where
519:
520: ec.tp_header_id = cas.tp_header_id
521: and cas.cust_acct_site_id = p_entity_address_id;
523: cursor po_site is
524: select pvs.ece_tp_location_code,
525: ec.tp_reference_ext1,
526: ec.tp_reference_ext2
527: from ece_tp_headers ec, po_vendor_sites pvs
528: where
529: pvs.vendor_site_id = p_entity_address_id
530: and pvs.tp_header_id = ec.tp_header_id;
531:
532: cursor ap_bank is
533: select hcp.edi_ece_tp_location_code,
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