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.ONT_OEXOECCL_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 317: from mtl_system_items_vl sitems

313: v_item := fnd_flex_xml_publisher_apis.process_kff_combination_1('Item_dsp', 'INV', p_item_flex_code, p_item_structure_num, Item_DspFormula.ORGANIZATION_ID, Item_DspFormula.INVENTORY_ITEM_ID1, 'ALL', 'Y', 'VALUE');
314:
315: select sitems.description description
316: into v_description
317: from mtl_system_items_vl sitems
318: where sitems.customer_order_enabled_flag = 'Y'
319: and sitems.bom_item_type in (1,4)
320: and nvl(sitems.organization_id,0) = RP_DUMMY_ITEM
321: and sitems.inventory_item_id = Item_DspFormula.inventory_item_id1; --Bug2764262

Line 342: mtl_system_items_vl sitems

338: nvl(citems.customer_item_desc,sitems.description) description
339: into v_item,v_description
340: from mtl_customer_items citems,
341: mtl_customer_item_xrefs cxref,
342: mtl_system_items_vl sitems
343: where citems.customer_item_id = cxref.customer_item_id
344: and cxref.inventory_item_id = sitems.inventory_item_id
345: and citems.customer_item_id = Item_DspFormula.ordered_item_id
346: and nvl(sitems.organization_id,0) = RP_DUMMY_ITEM

Line 356: mtl_system_items_vl sitems

352: nvl(items.description,sitems.description) description
353: into v_item,v_description
354: from mtl_cross_reference_types xtypes,
355: mtl_cross_references items,
356: mtl_system_items_vl sitems
357: where xtypes.cross_reference_type = items.cross_reference_type
358: and items.inventory_item_id = sitems.inventory_item_id
359: and items.cross_reference = Item_DspFormula.ordered_item
360: and items.cross_reference_type = Item_DspFormula.item_identifier_type