APPS.WIP_MTI_PUB dependencies on MTL_RESERVATIONS

Line 1581: from mtl_reservations

1577: and transaction_source_type_id = 5
1578: and wip_entity_type in (1, 2, 5)
1579: and demand_source_header_id is not null
1580: and not exists (select 'X'
1581: from mtl_reservations
1582: where organization_id = mti.organization_id
1583: and inventory_item_id = mti.inventory_item_id
1584: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1585: and demand_source_type_id = inv_reservation_global.g_source_type_oe

Line 1618: from mtl_reservations

1614: and transaction_source_type_id = 5
1615: and wip_entity_type in (1, 2, 5)
1616: and demand_source_header_id is not null
1617: and not exists (select 'X'
1618: from mtl_reservations
1619: where organization_id = mti.organization_id
1620: and inventory_item_id = mti.inventory_item_id
1621: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1622: and demand_source_type_id =

Line 1660: from mtl_reservations

1656: and wip_entity_type in (1, 2, 5)
1657: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1658: and demand_source_header_id is not null
1659: and not exists (select 'X'
1660: from mtl_reservations
1661: where organization_id = mti.organization_id
1662: and inventory_item_id = mti.inventory_item_id
1663: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1664: and demand_source_type_id =

Line 1697: from mtl_reservations

1693: and wip_entity_type in (1, 2, 5)
1694: and transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1695: and demand_source_header_id is not null
1696: and not exists (select 'X'
1697: from mtl_reservations
1698: where organization_id = mti.organization_id
1699: and inventory_item_id = mti.inventory_item_id
1700: and nvl(revision, '--1') = nvl(mti.revision, '--1')
1701: and demand_source_type_id =