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.INV_ITEM_STATUS_CP dependencies on DUAL

Line 146: FROM DUAL

142: FOR UPDATE NOWAIT;
143:
144: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
145: SELECT count(*) INTO is_transactable_upd
146: FROM DUAL
147: WHERE EXISTS
148: (SELECT 'X' FROM mtl_system_items
149: WHERE inventory_item_id = p_item_id
150: AND organization_id = p_org_id

Line 171: from dual

167: /*commented for bug 5479302
168: if(l_bom_cntrl_level in ( G_UNDER_STATUS_CONTROL,G_DEFAULT_CONTROL) AND is_bom_enabled_upd = 1) then
169: select count(*)
170: into G_BOM_status
171: from dual
172: where exists
173: ( select 'x'
174: from bom_bill_of_materials bom
175: where bom.assembly_item_id = p_Item_Id