DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 3998: FROM MTL_SECONDARY_INVENTORIES MSI

3994: WHERE TRANSACTION_ACTION_ID NOT IN (24, 30)
3995: AND subinventory_code IS NOT null
3996: AND NOT EXISTS (
3997: SELECT NULL
3998: FROM MTL_SECONDARY_INVENTORIES MSI
3999: WHERE MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
4000: AND MSI.SECONDARY_INVENTORY_NAME = crtt.SUBINVENTORY_CODE
4001: AND NVL(MSI.DISABLE_DATE,SYSDATE+1) > Sysdate);
4002: