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 167: FROM DUAL

163: FOR UPDATE NOWAIT;
164:
165: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
166: SELECT count(*) INTO is_transactable_upd
167: FROM DUAL
168: WHERE EXISTS
169: (SELECT 'X' FROM mtl_system_items
170: WHERE inventory_item_id = p_item_id
171: AND organization_id = p_org_id

Line 192: from dual

188: /*commented for bug 5479302
189: if(l_bom_cntrl_level in ( G_UNDER_STATUS_CONTROL,G_DEFAULT_CONTROL) AND is_bom_enabled_upd = 1) then
190: select count(*)
191: into G_BOM_status
192: from dual
193: where exists
194: ( select 'x'
195: from bom_bill_of_materials bom
196: where bom.assembly_item_id = p_Item_Id