DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_ITEM_REVISIONS

Line 1789: * 13. Validate Revision ( should exists in mtl_item_revisions,

1785: * count
1786: * and some internal orders through MTI)
1787: * 11. Validate Organization(disable date)
1788: * 12. Validate Locators(disable date)
1789: * 13. Validate Revision ( should exists in mtl_item_revisions,
1790: * we do not validate against disbaled_date for revision).
1791: * 14. Validate Transaction reasons(disable date)
1792: * 15. Validate Transaction Qty Sign
1793: * 16. Validate OverCompletion Trx qtyshould not be -ve or greater

Line 2861: FROM MTL_ITEM_REVISIONS MIR,

2857: AND PROCESS_FLAG = 1
2858: AND TRANSACTION_ACTION_ID NOT IN (24,33,34)
2859: AND NOT EXISTS (
2860: SELECT NULL
2861: FROM MTL_ITEM_REVISIONS MIR,
2862: MTL_SYSTEM_ITEMS MSI
2863: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
2864: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2865: AND MIR.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 2901: FROM MTL_ITEM_REVISIONS MIR,

2897: AND PROCESS_FLAG = 1
2898: AND TRANSACTION_ACTION_ID = 3
2899: AND NOT EXISTS (
2900: SELECT NULL
2901: FROM MTL_ITEM_REVISIONS MIR,
2902: MTL_SYSTEM_ITEMS MSI
2903: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
2904: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2905: AND MIR.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION