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_OEXCRDIS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 356: from mtl_system_items_vl sitems

352: sitems.description description
353: into
354: -- v_item,
355: v_description
356: from mtl_system_items_vl sitems
357: where
358: sitems.customer_order_enabled_flag = 'Y' and
359: sitems.bom_item_type in (1,4)
360: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 384: mtl_system_items_vl sitems

380: nvl(citems.customer_item_desc,sitems.description) description
381: into v_item,v_description
382: from mtl_customer_items citems,
383: mtl_customer_item_xrefs cxref,
384: mtl_system_items_vl sitems
385: where citems.customer_item_id = cxref.customer_item_id
386: and cxref.inventory_item_id = sitems.inventory_item_id
387: and citems.customer_item_id = ordered_item_id
388: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 398: mtl_system_items_vl sitems

394: nvl(items.description,sitems.description) description
395: into v_item,v_description
396: from mtl_cross_reference_types xtypes,
397: mtl_cross_references items,
398: mtl_system_items_vl sitems
399: where xtypes.cross_reference_type = items.cross_reference_type
400: and items.inventory_item_id = sitems.inventory_item_id
401: and items.cross_reference = ordered_item
402: and items.cross_reference_type = item_identifier_type