APPS.WIP_MTI_PUB dependencies on MTL_ITEM_REVISIONS

Line 1326: from mtl_item_revisions mir

1322: where msi.organization_id = mti.organization_id
1323: and msi.inventory_item_id = mti.inventory_item_id
1324: and msi.revision_qty_control_code = 2 )
1325: and not exists (select 'X'
1326: from mtl_item_revisions mir
1327: where mir.organization_id = mti.organization_id
1328: and mir.inventory_item_id = mti.inventory_item_id
1329: and mir.revision = mti.revision);
1330:

Line 1346: from mtl_item_revisions mir

1342: program_id = fnd_global.conc_program_id,
1343: program_update_date = sysdate,
1344: request_id = fnd_global.conc_request_id,
1345: revision = (select nvl(mti.revision, max(mir.revision))
1346: from mtl_item_revisions mir
1347: where mir.organization_id = mti.organization_id
1348: and mir.inventory_item_id = mti.inventory_item_id
1349: and mir.effectivity_date <= sysdate
1350: and mir.effectivity_date =

Line 1352: from mtl_item_revisions mir2

1348: and mir.inventory_item_id = mti.inventory_item_id
1349: and mir.effectivity_date <= sysdate
1350: and mir.effectivity_date =
1351: (select max(mir2.effectivity_date)
1352: from mtl_item_revisions mir2
1353: where mir2.organization_id = mti.organization_id
1354: and mir2.inventory_item_id = mti.inventory_item_id
1355: and mir2.effectivity_date <= sysdate))
1356: where transaction_header_id = p_txnHeaderID

Line 1406: MTL_ITEM_REVISIONS_B MIR ,

1402: and msi.inventory_item_id = mti.inventory_item_id
1403: and msi.revision_qty_control_code = 2)
1404: and not exists(select 'rev effective and not an open/hold eco'
1405: FROM ENG_REVISED_ITEMS ERI2,
1406: MTL_ITEM_REVISIONS_B MIR ,
1407: ENG_REVISED_ITEMS ERI,
1408: MTL_ITEM_REVISIONS_B MIR2
1409: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1410: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)

Line 1408: MTL_ITEM_REVISIONS_B MIR2

1404: and not exists(select 'rev effective and not an open/hold eco'
1405: FROM ENG_REVISED_ITEMS ERI2,
1406: MTL_ITEM_REVISIONS_B MIR ,
1407: ENG_REVISED_ITEMS ERI,
1408: MTL_ITEM_REVISIONS_B MIR2
1409: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1410: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)
1411: AND MIR2.ORGANIZATION_ID(+) = MIR.ORGANIZATION_ID
1412: AND MIR2.INVENTORY_ITEM_ID(+) = MIR.INVENTORY_ITEM_ID

Line 1432: MTL_ITEM_REVISIONS_B MIR,

1428: and msi.inventory_item_id = mti.inventory_item_id
1429: and msi.revision_qty_control_code = 2)
1430: and not exists (select 'any effective rev'
1431: FROM ENG_REVISED_ITEMS ERI2,
1432: MTL_ITEM_REVISIONS_B MIR,
1433: ENG_REVISED_ITEMS ERI,
1434: MTL_ITEM_REVISIONS_B MIR2
1435: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1436: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)

Line 1434: MTL_ITEM_REVISIONS_B MIR2

1430: and not exists (select 'any effective rev'
1431: FROM ENG_REVISED_ITEMS ERI2,
1432: MTL_ITEM_REVISIONS_B MIR,
1433: ENG_REVISED_ITEMS ERI,
1434: MTL_ITEM_REVISIONS_B MIR2
1435: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1436: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)
1437: AND MIR2.ORGANIZATION_ID(+) = MIR.ORGANIZATION_ID
1438: AND MIR2.INVENTORY_ITEM_ID(+) = MIR.INVENTORY_ITEM_ID