DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on MTL_ITEM_LOCATIONS

Line 654: FROM MTL_ITEM_LOCATIONS MIL

650: AND TRANSACTION_STATUS = 3
651: AND LOCATOR_ID IS NOT NULL
652: AND NOT EXISTS (
653: SELECT NULL
654: FROM MTL_ITEM_LOCATIONS MIL
655: WHERE MIL.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
656: AND MIL.SUBINVENTORY_CODE = MMTT.SUBINVENTORY_CODE
657: AND MIL.INVENTORY_LOCATION_ID = MMTT.LOCATOR_ID
658: AND NVL(DISABLE_DATE,SYSDATE+1) >= SYSDATE);

Line 806: FROM MTL_ITEM_LOCATIONS MIL

802: AND TRANSACTION_ACTION_ID IN (2,3)
803: AND TRANSFER_TO_LOCATION IS NOT NULL
804: AND NOT EXISTS (
805: SELECT NULL
806: FROM MTL_ITEM_LOCATIONS MIL
807: WHERE MIL.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID,3,
808: MMTT.TRANSFER_ORGANIZATION,MMTT.ORGANIZATION_ID)
809: AND MIL.SUBINVENTORY_CODE = MMTT.TRANSFER_SUBINVENTORY
810: AND MIL.INVENTORY_LOCATION_ID = MMTT.TRANSFER_TO_LOCATION);