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.WMA_SPECIAL_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 19: from mtl_system_items

15: restrictSubinv NUMBER;
16: BEGIN
17: select restrict_subinventories_code
18: into restrictSubinv
19: from mtl_system_items
20: where organization_id = orgID
21: and inventory_item_id = itemID;
22:
23: if ( restrictSubinv <> 1 ) then

Line 117: from mtl_system_items

113:
114: -- not 1 ,2, 3, so it must be item level
115: select location_control_code
116: into itemLevelCtl
117: from mtl_system_items
118: where inventory_item_id = itemID
119: and organization_id = orgID;
120:
121: return itemLevelCtl;

Line 144: from mtl_system_items

140: restrictLocatorCode NUMBER;
141: BEGIN
142: select restrict_locators_code
143: into restrictLocatorCode
144: from mtl_system_items
145: where inventory_item_id = itemID
146: and organization_id = orgID;
147:
148: if ( restrictLocatorCode = 2 ) then