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

Line 851: mtl_system_items_vl WHERE inventory_item_id = l_line_item_id;

847: loop
848: fetch c_line_item_cursor INTO l_line_item_id;
849: --get style item id for the line item
850: SELECT nvl(STYLE_ITEM_ID, -999) INTO l_style_item_id FROM
851: mtl_system_items_vl WHERE inventory_item_id = l_line_item_id;
852: -- if there is no style item id, then line item shall be an non-style item
853: IF (l_style_item_id = -999) THEN
854: l_sku_item_ind := false;
855: END IF;

Line 896: from mtl_system_items_vl

892: where entity_name = 'EGO_ITEM'
893: and change_id = p_change_id;
894: cursor c_sku_items(item_id varchar2) is
895: select distinct inventory_item_id
896: from mtl_system_items_vl
897: where style_item_id = item_id;
898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;
899: l_change_id eng_engineering_changes.change_id%type;
900: nums number;

Line 898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;

894: cursor c_sku_items(item_id varchar2) is
895: select distinct inventory_item_id
896: from mtl_system_items_vl
897: where style_item_id = item_id;
898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;
899: l_change_id eng_engineering_changes.change_id%type;
900: nums number;
901: BEGIN
902:

Line 908: FROM mtl_system_items_vl

904: for change_line in c_line_item_cursor loop
905: if change_line.item_id is not null then
906: SELECT STYLE_ITEM_FLAG
907: into style_flag
908: FROM mtl_system_items_vl
909: WHERE inventory_item_id = change_line.item_id
910: and rownum <= 1;
911: if style_flag = 'Y' then
912: for sku_items in c_sku_items(change_line.item_id) loop