DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDORS

Line 5321: po_vendors pv,

5317: l_edi_flag,
5318: x_preparer_id
5319: from ece_tp_details etd,
5320: po_vendor_sites pvs,
5321: po_vendors pv,
5322: po_headers ph
5323: where pv.vendor_id = pvs.vendor_id
5324: and pvs.tp_header_id = etd.tp_header_id
5325: and etd.document_id = l_transaction_subtype

Line 5349: po_vendors pv,

5345: l_edi_flag,
5346: x_preparer_id
5347: from ece_tp_details etd,
5348: po_vendor_sites pvs,
5349: po_vendors pv,
5350: po_headers ph ,
5351: po_releases pr
5352: where pv.vendor_id = pvs.vendor_id
5353: and pvs.tp_header_id = etd.tp_header_id

Line 7183: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;

7179: l_source_doc_id NUMBER;
7180: l_item_id NUMBER;
7181: l_cons_from_supp_flag VARCHAR2(1);
7182: x_progress VARCHAR2 (300);
7183: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;
7184: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
7185:
7186: l_return_status VARCHAR2(1);
7187: l_msg_count NUMBER;