271: pll.drop_ship_flag --Bug 9356725
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 --
277: where PLL.PO_HEADER_ID = v_document_id
278: and PLL.po_line_id = POL.po_line_id
279: and PLL.po_release_id is NULL /* Bug 4513703 */
319: pll.drop_ship_flag --Bug 9356725
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 --
325: where POL.PO_HEADER_ID = v_document_id
326: and POL.po_line_id = PLL.po_line_id(+)
327: and pol.item_id = msi.inventory_item_id(+)
366: NULL --Bug 9356725
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 --
372: where POL.PO_HEADER_ID = v_document_id
373: and POL.po_header_id = POH.po_header_id
374: and pol.item_id = msi.inventory_item_id(+)
412: pll.drop_ship_flag --Bug 9356725
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 --
418: where PLL.PO_RELEASE_ID = v_document_id
419: and PLL.po_line_id = POL.po_line_id
420: and pol.item_id = msi.inventory_item_id(+)