DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on MTL_UNITS_OF_MEASURE_VL

Line 275: mtl_units_of_measure_vl umvl,

271: pll.drop_ship_flag --Bug 9356725
272: FROM po_lines_all pol, -- --po_lines 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 -- --financials_system_parameters 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 */

Line 323: mtl_units_of_measure_vl umvl,

319: pll.drop_ship_flag --Bug 9356725
320: FROM po_lines_all pol, -- --po_lines 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 -- --financials_system_parameters 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(+)

Line 370: mtl_units_of_measure_vl umvl,

366: NULL --Bug 9356725
367: FROM po_lines pol,
368: po_headers_all poh, -- --po_headers poh,
369: mtl_system_items_kfv msi,
370: mtl_units_of_measure_vl umvl,
371: financials_system_params_all fsp -- --financials_system_parameters 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(+)

Line 416: mtl_units_of_measure_vl umvl,

412: pll.drop_ship_flag --Bug 9356725
413: FROM po_lines_all pol, -- --po_lines 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 -- --financials_system_parameters 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(+)