DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDORS

Line 5702: po_vendors pv,

5698: l_edi_flag,
5699: x_preparer_id
5700: from ece_tp_details etd,
5701: po_vendor_sites pvs,
5702: po_vendors pv,
5703: po_headers ph
5704: where pv.vendor_id = pvs.vendor_id
5705: and pvs.tp_header_id = etd.tp_header_id
5706: and etd.document_id = l_transaction_subtype

Line 5730: po_vendors pv,

5726: l_edi_flag,
5727: x_preparer_id
5728: from ece_tp_details etd,
5729: po_vendor_sites pvs,
5730: po_vendors pv,
5731: po_headers ph ,
5732: po_releases pr
5733: where pv.vendor_id = pvs.vendor_id
5734: and pvs.tp_header_id = etd.tp_header_id

Line 7636: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;

7632: l_source_doc_id NUMBER;
7633: l_item_id NUMBER;
7634: l_cons_from_supp_flag VARCHAR2(1);
7635: x_progress VARCHAR2 (300);
7636: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;
7637: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
7638:
7639: l_return_status VARCHAR2(1);
7640: l_msg_count NUMBER;