APPS.WIP_MTI_PUB dependencies on ENG_REVISED_ITEMS

Line 1359: FROM ENG_REVISED_ITEMS ERI2,

1355: where msi.organization_id = mti.organization_id
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(+)

Line 1361: ENG_REVISED_ITEMS ERI,

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)
1365: AND MIR2.ORGANIZATION_ID(+) = MIR.ORGANIZATION_ID

Line 1385: FROM ENG_REVISED_ITEMS ERI2,

1381: where msi.organization_id = mti.organization_id
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(+)

Line 1387: ENG_REVISED_ITEMS ERI,

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)
1391: AND MIR2.ORGANIZATION_ID(+) = MIR.ORGANIZATION_ID