DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_ITEM_SUB_INVENTORIES

Line 3937: FROM MTL_ITEM_SUB_INVENTORIES MIS,

3933:
3934: where SUBINVENTORY_CODE IS NOT NULL
3935: AND NOT EXISTS (
3936: SELECT NULL
3937: FROM MTL_ITEM_SUB_INVENTORIES MIS,
3938: MTL_SYSTEM_ITEMS MSI
3939: WHERE MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
3940: AND MSI.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
3941: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1