APPS.WIP_MTI_PUB dependencies on MTL_ITEM_REVISIONS

Line 1280: from mtl_item_revisions mir

1276: where msi.organization_id = mti.organization_id
1277: and msi.inventory_item_id = mti.inventory_item_id
1278: and msi.revision_qty_control_code = 2 )
1279: and not exists (select 'X'
1280: from mtl_item_revisions mir
1281: where mir.organization_id = mti.organization_id
1282: and mir.inventory_item_id = mti.inventory_item_id
1283: and mir.revision = mti.revision);
1284:

Line 1300: from mtl_item_revisions mir

1296: program_id = fnd_global.conc_program_id,
1297: program_update_date = sysdate,
1298: request_id = fnd_global.conc_request_id,
1299: revision = (select nvl(mti.revision, max(mir.revision))
1300: from mtl_item_revisions mir
1301: where mir.organization_id = mti.organization_id
1302: and mir.inventory_item_id = mti.inventory_item_id
1303: and mir.effectivity_date <= sysdate
1304: and mir.effectivity_date =

Line 1306: from mtl_item_revisions mir2

1302: and mir.inventory_item_id = mti.inventory_item_id
1303: and mir.effectivity_date <= sysdate
1304: and mir.effectivity_date =
1305: (select max(mir2.effectivity_date)
1306: from mtl_item_revisions mir2
1307: where mir2.organization_id = mti.organization_id
1308: and mir2.inventory_item_id = mti.inventory_item_id
1309: and mir2.effectivity_date <= sysdate))
1310: where transaction_header_id = p_txnHeaderID

Line 1360: MTL_ITEM_REVISIONS_B MIR ,

1356: and msi.inventory_item_id = mti.inventory_item_id
1357: and msi.revision_qty_control_code = 2)
1358: and not exists(select 'rev effective and not an open/hold eco'
1359: FROM ENG_REVISED_ITEMS ERI2,
1360: MTL_ITEM_REVISIONS_B MIR ,
1361: ENG_REVISED_ITEMS ERI,
1362: MTL_ITEM_REVISIONS_B MIR2
1363: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1364: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)

Line 1362: MTL_ITEM_REVISIONS_B MIR2

1358: and not exists(select 'rev effective and not an open/hold eco'
1359: FROM ENG_REVISED_ITEMS ERI2,
1360: MTL_ITEM_REVISIONS_B MIR ,
1361: ENG_REVISED_ITEMS ERI,
1362: MTL_ITEM_REVISIONS_B MIR2
1363: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1364: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)
1365: AND MIR2.ORGANIZATION_ID(+) = MIR.ORGANIZATION_ID
1366: AND MIR2.INVENTORY_ITEM_ID(+) = MIR.INVENTORY_ITEM_ID

Line 1386: MTL_ITEM_REVISIONS_B MIR,

1382: and msi.inventory_item_id = mti.inventory_item_id
1383: and msi.revision_qty_control_code = 2)
1384: and not exists (select 'any effective rev'
1385: FROM ENG_REVISED_ITEMS ERI2,
1386: MTL_ITEM_REVISIONS_B MIR,
1387: ENG_REVISED_ITEMS ERI,
1388: MTL_ITEM_REVISIONS_B MIR2
1389: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1390: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)

Line 1388: MTL_ITEM_REVISIONS_B MIR2

1384: and not exists (select 'any effective rev'
1385: FROM ENG_REVISED_ITEMS ERI2,
1386: MTL_ITEM_REVISIONS_B MIR,
1387: ENG_REVISED_ITEMS ERI,
1388: MTL_ITEM_REVISIONS_B MIR2
1389: WHERE MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
1390: AND NVL(ERI.STATUS_TYPE,0) NOT IN (1,2)
1391: AND MIR2.ORGANIZATION_ID(+) = MIR.ORGANIZATION_ID
1392: AND MIR2.INVENTORY_ITEM_ID(+) = MIR.INVENTORY_ITEM_ID