APPS.WIP_MTI_PUB dependencies on ENG_REVISED_ITEMS

Line 1405: FROM ENG_REVISED_ITEMS ERI2,

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

Line 1407: ENG_REVISED_ITEMS ERI,

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

Line 1431: FROM ENG_REVISED_ITEMS ERI2,

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

Line 1433: ENG_REVISED_ITEMS ERI,

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