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 --
487: AND pli.item_id = msi.inventory_item_id( + )
488: AND NVL(msi.organization_id, fsp.inventory_organization_id) = fsp.inventory_organization_id
489: --AND pli.line_type_id = plt.line_type_id
529: --bug 1942696 hr_location changes to reflect the new view
530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --
533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
535: PO_HEADERS_INTERFACE PHI
536: WHERE PLI.LINE_NUM = x_po_line_num
537: AND PLI.shipment_num IS NOT NULL
618: PO_REQUISITION_LINES_ALL PRL, --
619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
624: PO_HEADERS_INTERFACE PHI
625: WHERE PLI.LINE_NUM = x_po_line_num
626: AND PLI.shipment_num IS NOT NULL