267: FROM po_lines_all pol, --
268: po_line_locations pll,
269: mtl_system_items_kfv msi,
270: mtl_units_of_measure_vl umvl,
271: financials_system_params_all fsp --
273: and PLL.po_line_id = POL.po_line_id
274: and PLL.po_release_id is NULL /* Bug 4513703 */
275: and pol.item_id = msi.inventory_item_id(+)
314: FROM po_lines_all pol, --
315: po_line_locations pll,
316: mtl_system_items_kfv msi,
317: mtl_units_of_measure_vl umvl,
318: financials_system_params_all fsp --
320: and POL.po_line_id = PLL.po_line_id(+)
321: and pol.item_id = msi.inventory_item_id(+)
322: and pll.shipment_type(+) = 'PRICE BREAK'
360: FROM po_lines pol,
361: po_headers_all poh, --
362: mtl_system_items_kfv msi,
363: mtl_units_of_measure_vl umvl,
364: financials_system_params_all fsp --
366: and POL.po_header_id = POH.po_header_id
367: and pol.item_id = msi.inventory_item_id(+)
368: and NVL(msi.organization_id, fsp.inventory_organization_id) = fsp.inventory_organization_id
405: FROM po_lines_all pol, --
406: po_line_locations pll,
407: mtl_system_items_kfv msi,
408: mtl_units_of_measure_vl umvl,
409: financials_system_params_all fsp --
411: and PLL.po_line_id = POL.po_line_id
412: and pol.item_id = msi.inventory_item_id(+)
413: and NVL(msi.organization_id, fsp.inventory_organization_id) =