APPS.WIP_MTI_PUB dependencies on MTL_RESERVATIONS

Line 1627: from mtl_reservations

1623: and transaction_source_type_id = 5
1624: and wip_entity_type in (1, 2, 5)
1625: and demand_source_header_id is not null
1626: and not exists (select 'X'
1627: from mtl_reservations
1628: where organization_id = mti.organization_id
1629: and inventory_item_id = mti.inventory_item_id
1630: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1631: and demand_source_type_id = inv_reservation_global.g_source_type_oe

Line 1664: from mtl_reservations

1660: and transaction_source_type_id = 5
1661: and wip_entity_type in (1, 2, 5)
1662: and demand_source_header_id is not null
1663: and not exists (select 'X'
1664: from mtl_reservations
1665: where organization_id = mti.organization_id
1666: and inventory_item_id = mti.inventory_item_id
1667: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1668: and demand_source_type_id =

Line 1706: from mtl_reservations

1702: and wip_entity_type in (1, 2, 5)
1703: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1704: and demand_source_header_id is not null
1705: and not exists (select 'X'
1706: from mtl_reservations
1707: where organization_id = mti.organization_id
1708: and inventory_item_id = mti.inventory_item_id
1709: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1710: and demand_source_type_id =

Line 1743: from mtl_reservations

1739: and wip_entity_type in (1, 2, 5)
1740: and transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1741: and demand_source_header_id is not null
1742: and not exists (select 'X'
1743: from mtl_reservations
1744: where organization_id = mti.organization_id
1745: and inventory_item_id = mti.inventory_item_id
1746: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1747: and demand_source_type_id =