DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2380: FROM MTL_ITEM_SUB_INVENTORIES MIS,

2376: AND SUBINVENTORY_CODE IS NOT NULL
2377: AND PROCESS_FLAG = 1
2378: AND NOT EXISTS (
2379: SELECT NULL
2380: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2381: MTL_SYSTEM_ITEMS MSI
2382: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2383: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2384: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1

Line 2428: FROM MTL_ITEM_SUB_INVENTORIES MIS,

2424: AND TRANSFER_SUBINVENTORY IS NOT NULL
2425: AND TRANSACTION_ACTION_ID in (2,21,3,5)
2426: AND NOT EXISTS (
2427: SELECT NULL
2428: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2429: MTL_SYSTEM_ITEMS MSI
2430: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID, 2,
2431: MTI.ORGANIZATION_ID,
2432: MTI.TRANSFER_ORGANIZATION)