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 41: item_num mtl_system_items_kfv.concatenated_segments%TYPE,

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

Line 186: l_allow_item_desc_update mtl_system_items.allow_item_desc_update_flag%TYPE;

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

Line 187: l_mtl_system_items_desc mtl_system_items_tl.description%TYPE;

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

Line 232: WHERE entity_name = 'MTL_SYSTEM_ITEMS' AND

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

Line 274: mtl_system_items_kfv msi,

270: --
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

Line 322: mtl_system_items_kfv msi,

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

Line 369: mtl_system_items_kfv msi,

365: --
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

Line 415: mtl_system_items_kfv msi,

411: --
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

Line 1113: l_mtl_system_items_desc := NULL;

1109: end if;
1110: /* End fix for 2473707 */
1111:
1112: begin
1113: l_mtl_system_items_desc := NULL;
1114: select allow_item_desc_update_flag into l_allow_item_desc_update
1115: from mtl_system_items_vl
1116: where inventory_item_id = l_line_loc.item_id
1117: and organization_id = l_org_id;

Line 1115: from mtl_system_items_vl

1111:
1112: begin
1113: l_mtl_system_items_desc := NULL;
1114: select allow_item_desc_update_flag into l_allow_item_desc_update
1115: from mtl_system_items_vl
1116: where inventory_item_id = l_line_loc.item_id
1117: and organization_id = l_org_id;
1118:
1119: if (l_allow_item_desc_update = 'N') then

Line 1120: select description into l_mtl_system_items_desc

1116: where inventory_item_id = l_line_loc.item_id
1117: and organization_id = l_org_id;
1118:
1119: if (l_allow_item_desc_update = 'N') then
1120: select description into l_mtl_system_items_desc
1121: from mtl_system_items_vl
1122: where inventory_item_id = l_line_loc.item_id
1123: and organization_id = l_org_id;
1124: end if;

Line 1121: from mtl_system_items_vl

1117: and organization_id = l_org_id;
1118:
1119: if (l_allow_item_desc_update = 'N') then
1120: select description into l_mtl_system_items_desc
1121: from mtl_system_items_vl
1122: where inventory_item_id = l_line_loc.item_id
1123: and organization_id = l_org_id;
1124: end if;
1125: exception

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

1126: when others then
1127: null;
1128: end;
1129:
1130: l_document := l_document || '
' || nvl(l_mtl_system_items_desc, l_line_loc.item_desc) || NL;
1131: open item_notes_cursor(l_line_loc.org_id, l_line_loc.item_id);
1132: loop
1133:
1134: fetch item_notes_cursor into l_datatype_id, l_media_id;