272: FROM po_lines_all pol, --
273: po_line_locations pll,
274: mtl_system_items_kfv msi,
275: mtl_units_of_measure_vl umvl,
276: financials_system_params_all fsp --
278: and PLL.po_line_id = POL.po_line_id
279: and PLL.po_release_id is NULL /* Bug 4513703 */
280: and pol.item_id = msi.inventory_item_id(+)
320: FROM po_lines_all pol, --
321: po_line_locations pll,
322: mtl_system_items_kfv msi,
323: mtl_units_of_measure_vl umvl,
324: financials_system_params_all fsp --
326: and POL.po_line_id = PLL.po_line_id(+)
327: and pol.item_id = msi.inventory_item_id(+)
328: and pll.shipment_type(+) = 'PRICE BREAK'
367: FROM po_lines pol,
368: po_headers_all poh, --
369: mtl_system_items_kfv msi,
370: mtl_units_of_measure_vl umvl,
371: financials_system_params_all fsp --
373: and POL.po_header_id = POH.po_header_id
374: and pol.item_id = msi.inventory_item_id(+)
375: and NVL(msi.organization_id, fsp.inventory_organization_id) = fsp.inventory_organization_id
413: FROM po_lines_all pol, --
414: po_line_locations pll,
415: mtl_system_items_kfv msi,
416: mtl_units_of_measure_vl umvl,
417: financials_system_params_all fsp --
419: and PLL.po_line_id = POL.po_line_id
420: and pol.item_id = msi.inventory_item_id(+)
421: and NVL(msi.organization_id, fsp.inventory_organization_id) =