DBA Data[Home] [Help]

APPS.INV_DCP_PVT dependencies on MTL_ITEM_REVISIONS

Line 1142: FROM MTL_ITEM_REVISIONS MIR,

1138: AND TRANSACTION_ACTION_ID NOT IN (24,33,34,30)
1139: AND inventory_item_id <> -1
1140: AND NOT EXISTS (
1141: SELECT NULL
1142: FROM MTL_ITEM_REVISIONS MIR,
1143: MTL_SYSTEM_ITEMS MSI
1144: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
1145: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1146: AND MIR.ORGANIZATION_ID = MMTT.ORGANIZATION_ID

Line 1172: FROM MTL_ITEM_REVISIONS MIR,

1168: AND TRANSACTION_ACTION_ID = 3
1169: AND inventory_item_id <> -1
1170: AND NOT EXISTS (
1171: SELECT NULL
1172: FROM MTL_ITEM_REVISIONS MIR,
1173: MTL_SYSTEM_ITEMS MSI
1174: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
1175: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1176: AND MIR.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION