[Home] [Help]
1877: * count
1878: * and some internal orders through MTI)
1879: * 11. Validate Organization(disable date)
1880: * 12. Validate Locators(disable date)
1881: * 13. Validate Revision ( should exists in mtl_item_revisions,
1882: * we do not validate against disbaled_date for revision).
1883: * 14. Validate Transaction reasons(disable date)
1884: * 15. Validate Transaction Qty Sign
1885: * 16. Validate OverCompletion Trx qtyshould not be -ve or greater
3004: AND PROCESS_FLAG = 1
3005: AND TRANSACTION_ACTION_ID NOT IN (24,33,34)
3006: AND NOT EXISTS (
3007: SELECT NULL
3008: FROM MTL_ITEM_REVISIONS MIR,
3009: MTL_SYSTEM_ITEMS MSI
3010: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
3011: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3012: AND MIR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3044: AND PROCESS_FLAG = 1
3045: AND TRANSACTION_ACTION_ID = 3
3046: AND NOT EXISTS (
3047: SELECT NULL
3048: FROM MTL_ITEM_REVISIONS MIR,
3049: MTL_SYSTEM_ITEMS MSI
3050: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
3051: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3052: AND MIR.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
3089: AND TRANSACTION_SOURCE_TYPE_ID IN (13, 6, 3)
3090: AND TRANSACTION_ACTION_ID IN (1, 27, 2)
3091: AND EXISTS (
3092: SELECT NULL
3093: FROM MTL_ITEM_REVISIONS MIR,
3094: MTL_SYSTEM_ITEMS MSI
3095: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
3096: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3097: AND MIR.ORGANIZATION_ID = MTI.ORGANIZATION_ID