DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_ITEM_SUB_INVENTORIES

Line 4024: FROM MTL_ITEM_SUB_INVENTORIES MIS,

4020:
4021: where SUBINVENTORY_CODE IS NOT NULL
4022: AND NOT EXISTS (
4023: SELECT NULL
4024: FROM MTL_ITEM_SUB_INVENTORIES MIS,
4025: MTL_SYSTEM_ITEMS MSI
4026: WHERE MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
4027: AND MSI.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
4028: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1