eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_EMAIL_GENERATE dependencies on MTL_SYSTEM_ITEMS

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 182: l_allow_item_desc_update mtl_system_items.allow_item_desc_update_flag%TYPE;

178: l_min_unit fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision fnd_currencies.precision%TYPE;
180: l_ext_precision fnd_currencies.extended_precision%TYPE; -- Bug fix 3314246
181:
182: l_allow_item_desc_update mtl_system_items.allow_item_desc_update_flag%TYPE;
183: l_mtl_system_items_desc mtl_system_items_tl.description%TYPE;
184:
185:
186: /* bug 4567441 : added the orderby clause, so that the document attachments

Line 183: l_mtl_system_items_desc mtl_system_items_tl.description%TYPE;

179: l_precision fnd_currencies.precision%TYPE;
180: l_ext_precision fnd_currencies.extended_precision%TYPE; -- Bug fix 3314246
181:
182: l_allow_item_desc_update mtl_system_items.allow_item_desc_update_flag%TYPE;
183: l_mtl_system_items_desc mtl_system_items_tl.description%TYPE;
184:
185:
186: /* bug 4567441 : added the orderby clause, so that the document attachments
187: are ordered by sequence */

Line 228: WHERE entity_name = 'MTL_SYSTEM_ITEMS' AND

224: cursor item_notes_cursor(v_org_id number, v_item_id number) is
225: SELECT datatype_id,
226: media_id
227: FROM fnd_attached_docs_form_vl
228: WHERE entity_name = 'MTL_SYSTEM_ITEMS' AND
229: pk1_value = to_char(v_org_id) AND
230: pk2_value = to_char(v_item_id) AND
231: function_name = 'PO_PRINTPO' and
232: datatype_id in (1,2) and

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

Line 964: l_mtl_system_items_desc := NULL;

960: end if;
961: /* End fix for 2473707 */
962:
963: begin
964: l_mtl_system_items_desc := NULL;
965: select allow_item_desc_update_flag into l_allow_item_desc_update
966: from mtl_system_items_vl
967: where inventory_item_id = l_line_loc.item_id
968: and organization_id = l_org_id;

Line 966: from mtl_system_items_vl

962:
963: begin
964: l_mtl_system_items_desc := NULL;
965: select allow_item_desc_update_flag into l_allow_item_desc_update
966: from mtl_system_items_vl
967: where inventory_item_id = l_line_loc.item_id
968: and organization_id = l_org_id;
969:
970: if (l_allow_item_desc_update = 'N') then

Line 971: select description into l_mtl_system_items_desc

967: where inventory_item_id = l_line_loc.item_id
968: and organization_id = l_org_id;
969:
970: if (l_allow_item_desc_update = 'N') then
971: select description into l_mtl_system_items_desc
972: from mtl_system_items_vl
973: where inventory_item_id = l_line_loc.item_id
974: and organization_id = l_org_id;
975: end if;

Line 972: from mtl_system_items_vl

968: and organization_id = l_org_id;
969:
970: if (l_allow_item_desc_update = 'N') then
971: select description into l_mtl_system_items_desc
972: from mtl_system_items_vl
973: where inventory_item_id = l_line_loc.item_id
974: and organization_id = l_org_id;
975: end if;
976: exception

Line 981: l_document := l_document || '
' || nvl(l_mtl_system_items_desc, l_line_loc.item_desc) || NL;

977: when others then
978: null;
979: end;
980:
981: l_document := l_document || '
' || nvl(l_mtl_system_items_desc, l_line_loc.item_desc) || NL;
982: open item_notes_cursor(l_line_loc.org_id, l_line_loc.item_id);
983: loop
984:
985: fetch item_notes_cursor into l_datatype_id, l_media_id;