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.EAM_MTL_TXN_PROCESS dependencies on MTL_SECONDARY_INVENTORIES

Line 177: from mtl_secondary_inventories

173: Begin
174:
175: if(p_subinv_ctrl <> 1) then
176: select secondary_inventory_name into p_subinv_code
177: from mtl_secondary_inventories
178: where
179: secondary_inventory_name = p_subinv_code
180: and organization_id = p_org_id
181: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)

Line 187: from mtl_secondary_inventories

183: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y' ;
184:
185: elsif(p_subinv_ctrl = 1) then
186: select secondary_inventory_name into p_subinv_code
187: from mtl_secondary_inventories
188: where
189: secondary_inventory_name = p_subinv_code
190: and organization_id = p_org_id
191: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)

Line 489: FROM MTL_SECONDARY_INVENTORIES

485: -- retrive subinventory level control information
486: Begin
487: SELECT
488: locator_type into x_sub_ctrl
489: FROM MTL_SECONDARY_INVENTORIES
490: WHERE
491: organization_id = p_org and
492: secondary_inventory_name = p_subinv ;
493: Exception