DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2508: FROM MTL_ITEM_SUB_INVENTORIES MIS,

2504: AND SUBINVENTORY_CODE IS NOT NULL
2505: AND PROCESS_FLAG = 1
2506: AND NOT EXISTS (
2507: SELECT NULL
2508: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2509: MTL_SYSTEM_ITEMS MSI
2510: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2511: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2512: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1

Line 2556: FROM MTL_ITEM_SUB_INVENTORIES MIS,

2552: AND TRANSFER_SUBINVENTORY IS NOT NULL
2553: AND TRANSACTION_ACTION_ID in (2,21,3,5)
2554: AND NOT EXISTS (
2555: SELECT NULL
2556: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2557: MTL_SYSTEM_ITEMS MSI
2558: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID, 2,
2559: MTI.ORGANIZATION_ID,
2560: MTI.TRANSFER_ORGANIZATION)