APPS.INV_PROCESS_TEMP dependencies on MTL_SECONDARY_INVENTORIES

Line 580: FROM MTL_SECONDARY_INVENTORIES MSI

576: AND TRANSACTION_ACTION_ID NOT IN (24, 30) /* CFM Scrap Transactions */
577: AND (NVL(SHIPPABLE_FLAG,'Y') = 'Y'
578: AND NOT EXISTS (
579: SELECT NULL
580: FROM MTL_SECONDARY_INVENTORIES MSI
581: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
582: AND MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
583: AND NVL(DISABLE_DATE,SYSDATE+1) >= SYSDATE)
584: OR (SHIPPABLE_FLAG = 'N'

Line 588: FROM MTL_SECONDARY_INVENTORIES MSI

584: OR (SHIPPABLE_FLAG = 'N'
585: AND SUBINVENTORY_CODE IS NOT NULL
586: AND NOT EXISTS (
587: SELECT NULL
588: FROM MTL_SECONDARY_INVENTORIES MSI
589: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
590: AND MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE)));
591: -- should we use disable state here?
592:

Line 723: FROM MTL_SECONDARY_INVENTORIES MSI

719: AND TRANSFER_SUBINVENTORY IS NOT NULL)
720: AND ((NVL(SHIPPABLE_FLAG,'Y') = 'Y'
721: AND NOT EXISTS (
722: SELECT NULL
723: FROM MTL_SECONDARY_INVENTORIES MSI
724: WHERE MSI.ORGANIZATION_ID =
725: DECODE(MMTT.TRANSACTION_ACTION_ID,2,
726: MMTT.ORGANIZATION_ID,MMTT.TRANSFER_ORGANIZATION)
727: AND MSI.SECONDARY_INVENTORY_NAME = MMTT.TRANSFER_SUBINVENTORY

Line 733: FROM MTL_SECONDARY_INVENTORIES MSI

729: OR (SHIPPABLE_FLAG = 'N'
730: AND TRANSFER_SUBINVENTORY IS NOT NULL
731: AND NOT EXISTS (
732: SELECT NULL
733: FROM MTL_SECONDARY_INVENTORIES MSI
734: WHERE MSI.ORGANIZATION_ID =
735: DECODE(MMTT.TRANSACTION_ACTION_ID,3,
736: MMTT.TRANSFER_ORGANIZATION,21,
737: MMTT.TRANSFER_ORGANIZATION,MMTT.ORGANIZATION_ID)