DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 623: FROM mtl_secondary_inventories SUB

619: INTO cst_sub_list_temp(
620: subinventory_code
621: )
622: SELECT SUB.secondary_inventory_name
623: FROM mtl_secondary_inventories SUB
624: WHERE SUB.organization_id = p_organization_id
625: AND SUB.asset_inventory = DECODE(p_expense_sub,1,SUB.asset_inventory,1)
626: -- Non-quantity tracked subinventories do not appear in MOQ.
627: AND SUB.quantity_tracked = 1