[Home] [Help]
2918:
2919: cursor po_site is
2920: select pv.vendor_id, pvs.vendor_site_id
2921: from po_vendors pv, po_vendor_sites pvs,
2922: -- ece_tp_headers ec,
2923: ece_tp_details etd
2924: where
2925: etd.translator_code = p_translator_code
2926: -- and etd.tp_header_id = ec.tp_header_id
3132: cas.cust_acct_site_id
3133: from hz_cust_acct_sites cas,
3134: hz_cust_accounts ca,
3135: hz_parties pt,
3136: ece_tp_headers eth
3137: where
3138: eth.tp_reference_ext1 = p_reference_ext1
3139: and eth.tp_reference_ext2 = p_reference_ext2
3140: and eth.tp_header_id = cas.tp_header_id
3143:
3144: cursor po_site is
3145: select pv.vendor_id, pvs.vendor_site_id
3146: from po_vendors pv, po_vendor_sites pvs,
3147: ece_tp_headers eth
3148: where
3149: eth.tp_reference_ext1 = p_reference_ext1
3150: and eth.tp_reference_ext2 = p_reference_ext2
3151: and eth.tp_header_id = pvs.tp_header_id
3153:
3154: cursor ap_bank is
3155: select cbb.bank_party_id address_id
3156: from ce_bank_branches_v cbb,
3157: ece_tp_headers eth,
3158: hz_contact_points hcp
3159: where
3160: eth.tp_reference_ext1 = p_reference_ext1
3161: and eth.tp_reference_ext2 = p_reference_ext2
3347: cas.ece_tp_location_code,
3348: ec.tp_reference_ext1,
3349: ec.tp_reference_ext2
3350: from hz_cust_acct_sites cas,
3351: ece_tp_headers ec
3352: where
3353:
3354: ec.tp_header_id = cas.tp_header_id
3355: and cas.cust_acct_site_id = p_entity_address_id;
3358: cursor po_site is
3359: select pvs.ece_tp_location_code,
3360: ec.tp_reference_ext1,
3361: ec.tp_reference_ext2
3362: from ece_tp_headers ec, po_vendor_sites pvs
3363: where
3364: pvs.vendor_site_id = p_entity_address_id
3365: and pvs.tp_header_id = ec.tp_header_id;
3366:
3367: cursor ap_bank is
3368: select hcp.edi_ece_tp_location_code,
3369: ec.tp_reference_ext1,
3370: ec.tp_reference_ext2
3371: from ece_tp_headers ec, ce_bank_branches_v cbb,
3372: hz_contact_points hcp
3373: where
3374: cbb.branch_party_id = p_entity_address_id
3375: and hcp.edi_tp_header_id = ec.tp_header_id