DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 3911: FROM MTL_SECONDARY_INVENTORIES MSI

3907: WHERE TRANSACTION_ACTION_ID NOT IN (24, 30)
3908: AND subinventory_code IS NOT null
3909: AND NOT EXISTS (
3910: SELECT NULL
3911: FROM MTL_SECONDARY_INVENTORIES MSI
3912: WHERE MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
3913: AND MSI.SECONDARY_INVENTORY_NAME = crtt.SUBINVENTORY_CODE
3914: AND NVL(MSI.DISABLE_DATE,SYSDATE+1) > Sysdate);
3915: