APPS.PO_EMAIL_GENERATE dependencies on MTL_SYSTEM_ITEMS_KFV

Line 39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,

35:
36: TYPE shipment_record IS RECORD (
37: line_num po_lines_all.line_num%TYPE,
38: po_line_id po_lines_all.po_line_id%TYPE,
39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
40: item_revision po_lines_all.item_revision%TYPE,
41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
42: item_desc po_lines.item_description%TYPE,
43: uom mtl_units_of_measure_tl.unit_of_measure_tl%TYPE, /* Bug 2701946 */

Line 269: mtl_system_items_kfv msi,

265: pol.from_line_id
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

Line 316: mtl_system_items_kfv msi,

312: null
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(+)

Line 362: mtl_system_items_kfv msi,

358: null
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

Line 407: mtl_system_items_kfv msi,

403: null
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