DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on MTL_UNITS_OF_MEASURE_VL

Line 270: mtl_units_of_measure_vl umvl,

266: --
267: FROM po_lines_all pol, -- --po_lines 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 -- --financials_system_parameters fsp
272: where PLL.PO_HEADER_ID = v_document_id
273: and PLL.po_line_id = POL.po_line_id
274: and PLL.po_release_id is NULL /* Bug 4513703 */

Line 317: mtl_units_of_measure_vl umvl,

313: --
314: FROM po_lines_all pol, -- --po_lines 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 -- --financials_system_parameters fsp
319: where POL.PO_HEADER_ID = v_document_id
320: and POL.po_line_id = PLL.po_line_id(+)
321: and pol.item_id = msi.inventory_item_id(+)

Line 363: mtl_units_of_measure_vl umvl,

359: --
360: FROM po_lines pol,
361: po_headers_all poh, -- --po_headers poh,
362: mtl_system_items_kfv msi,
363: mtl_units_of_measure_vl umvl,
364: financials_system_params_all fsp -- --financials_system_parameters fsp
365: where POL.PO_HEADER_ID = v_document_id
366: and POL.po_header_id = POH.po_header_id
367: and pol.item_id = msi.inventory_item_id(+)

Line 408: mtl_units_of_measure_vl umvl,

404: --
405: FROM po_lines_all pol, -- --po_lines 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 -- --financials_system_parameters fsp
410: where PLL.PO_RELEASE_ID = v_document_id
411: and PLL.po_line_id = POL.po_line_id
412: and pol.item_id = msi.inventory_item_id(+)