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

Line 683: FROM mtl_secondary_inventories SUB

679: INTO cst_sub_list_temp(
680: subinventory_code
681: )
682: SELECT SUB.secondary_inventory_name
683: FROM mtl_secondary_inventories SUB
684: WHERE SUB.organization_id = p_organization_id
685: AND SUB.asset_inventory = DECODE(p_expense_sub,1,SUB.asset_inventory,1)
686: -- Non-quantity tracked subinventories do not appear in MOQ.
687: AND SUB.quantity_tracked = 1

Line 4527: FROM MTL_SECONDARY_INVENTORIES MSI

4523: AND MCACD.transaction_id = MMT.transaction_id
4524: AND ( ( MMT.subinventory_code IS NULL
4525: OR ( MMT.subinventory_code IS NOT NULL
4526: AND EXISTS ( SELECT NULL
4527: FROM MTL_SECONDARY_INVENTORIES MSI
4528: WHERE MSI.organization_id = MMT.organization_id
4529: AND MSI.secondary_inventory_name = MMT.subinventory_code
4530: AND MSI.asset_inventory = 1
4531: )

Line 4538: FROM MTL_SECONDARY_INVENTORIES MSI

4534: OR
4535: ( MMT.organization_id = nvl(MMT.transfer_organization_id,MMT.organization_id)
4536: AND MMT.transfer_subinventory IS NOT NULL
4537: AND EXISTS ( SELECT NULL
4538: FROM MTL_SECONDARY_INVENTORIES MSI
4539: WHERE MSI.organization_id = MMT.organization_id
4540: AND MSI.secondary_inventory_name = MMT.transfer_subinventory
4541: AND MSI.asset_inventory = 1
4542: )