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_DEFAULT_REVISED_ITEM dependencies on MTL_SYSTEM_ITEMS

Line 126: FROM mtl_system_items

122: BEGIN
123:
124: SELECT build_in_wip_flag
125: INTO l_build_in_wip
126: FROM mtl_system_items
127: WHERE inventory_item_id = g_rev_item_unexp_rec.revised_item_id
128: AND organization_id = g_rev_item_unexp_rec.organization_id;
129:
130: IF (l_build_in_wip = 'Y')

Line 281: FROM MTL_System_items_vl

277: -- Bug 3311072: Change the query to select item phase
278: -- Added By LKASTURI
279: SELECT CURRENT_PHASE_ID
280: INTO l_id
281: FROM MTL_System_items_vl
282: WHERE INVENTORY_ITEM_ID = p_rev_item_id
283: AND ORGANIZATION_ID = p_org_id;
284: -- End Changes 3311072
285:

Line 1436: FROM mtl_system_items msi

1432: -- R12: OPM Convergence Project
1433: CURSOR c_Get_Item_Details
1434: IS
1435: SELECT msi.bom_item_type , msi.tracking_quantity_ind
1436: FROM mtl_system_items msi
1437: WHERE msi.inventory_item_id = p_rev_item_unexp_rec.revised_item_id
1438: AND msi.organization_id = p_rev_item_unexp_rec.organization_id;
1439:
1440: CURSOR c_Get_Org_Details