DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_VENDORS

Line 483: po_vendors pov,

479: po_headers_interface phi,
480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,
483: po_vendors pov,
484: po_system_parameters_all psp, --
485: financials_system_params_all fsp --
486: WHERE 1 =1
487: AND pli.item_id = msi.inventory_item_id( + )

Line 534: PO_VENDORS POV,

530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --
533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
534: PO_VENDORS POV,
535: PO_HEADERS_INTERFACE PHI
536: WHERE PLI.LINE_NUM = x_po_line_num
537: AND PLI.shipment_num IS NOT NULL
538: AND NVL(psp.org_id,-99) = NVL(po_autocreate_params.g_purchasing_ou_id, -99) --

Line 623: PO_VENDORS POV,

619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
623: PO_VENDORS POV,
624: PO_HEADERS_INTERFACE PHI
625: WHERE PLI.LINE_NUM = x_po_line_num
626: AND PLI.shipment_num IS NOT NULL
627: AND PLI.item_id = MSI.inventory_item_id