DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on MTL_ITEM_REVISIONS

Line 410: FROM MTL_ITEM_REVISIONS MIR,

406: AND PROCESS_FLAG = 1
407: AND TRANSACTION_ACTION_ID NOT IN (24,33,34)
408: AND NOT EXISTS (
409: SELECT NULL
410: FROM MTL_ITEM_REVISIONS MIR,
411: MTL_SYSTEM_ITEMS MSI
412: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
413: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
414: AND MIR.ORGANIZATION_ID = MMTT.ORGANIZATION_ID

Line 504: FROM MTL_ITEM_REVISIONS MIR,

500: AND PROCESS_FLAG = 1
501: AND TRANSACTION_ACTION_ID = 3
502: AND NOT EXISTS (
503: SELECT NULL
504: FROM MTL_ITEM_REVISIONS MIR,
505: MTL_SYSTEM_ITEMS MSI
506: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
507: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
508: AND MIR.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION

Line 536: FROM MTL_ITEM_REVISIONS MIR,

532: AND PROCESS_FLAG = 'Y'
533: AND TRANSACTION_ACTION_ID = 3
534: AND NOT EXISTS (
535: SELECT NULL
536: FROM MTL_ITEM_REVISIONS MIR,
537: MTL_SYSTEM_ITEMS MSI
538: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
539: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
540: AND MIR.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION