eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MTI_PUB dependencies on INV_RESERVATION_GLOBAL

Line 1631: and demand_source_type_id = inv_reservation_global.g_source_type_oe

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
1632: and demand_source_header_id = mti.demand_source_header_id
1633: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1634: and supply_source_header_id = mti.transaction_source_id
1635: and supply_source_type_id =

Line 1636: inv_reservation_global.g_source_type_wip)

1632: and demand_source_header_id = mti.demand_source_header_id
1633: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1634: and supply_source_header_id = mti.transaction_source_id
1635: and supply_source_type_id =
1636: inv_reservation_global.g_source_type_wip)
1637: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1638: and supply_source_type_id =
1639: inv_reservation_global.g_source_type_inv
1640: and subinventory_code = mti.subinventory_code

Line 1639: inv_reservation_global.g_source_type_inv

1635: and supply_source_type_id =
1636: inv_reservation_global.g_source_type_wip)
1637: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1638: and supply_source_type_id =
1639: inv_reservation_global.g_source_type_inv
1640: and subinventory_code = mti.subinventory_code
1641: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1642:
1643: -- validate demand so line

Line 1669: inv_reservation_global.g_source_type_oe

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 =
1669: inv_reservation_global.g_source_type_oe
1670: and demand_source_header_id = mti.demand_source_header_id
1671: and nvl(demand_source_line_id, -1) =
1672: nvl(to_number(mti.demand_source_line), -1)
1673: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION

Line 1676: inv_reservation_global.g_source_type_wip)

1672: nvl(to_number(mti.demand_source_line), -1)
1673: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1674: and supply_source_header_id = mti.transaction_source_id
1675: and supply_source_type_id =
1676: inv_reservation_global.g_source_type_wip)
1677: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1678: and supply_source_type_id =
1679: inv_reservation_global.g_source_type_inv
1680: and subinventory_code = mti.subinventory_code

Line 1679: inv_reservation_global.g_source_type_inv

1675: and supply_source_type_id =
1676: inv_reservation_global.g_source_type_wip)
1677: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1678: and supply_source_type_id =
1679: inv_reservation_global.g_source_type_inv
1680: and subinventory_code = mti.subinventory_code
1681: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1682:
1683:

Line 1711: inv_reservation_global.g_source_type_oe

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 =
1711: inv_reservation_global.g_source_type_oe
1712: and demand_source_header_id = mti.demand_source_header_id
1713: and nvl(demand_source_line_id, -1) =
1714: nvl(to_number(mti.demand_source_line), -1)
1715: and supply_source_type_id =

Line 1716: inv_reservation_global.g_source_type_wip

1712: and demand_source_header_id = mti.demand_source_header_id
1713: and nvl(demand_source_line_id, -1) =
1714: nvl(to_number(mti.demand_source_line), -1)
1715: and supply_source_type_id =
1716: inv_reservation_global.g_source_type_wip
1717: and supply_source_header_id = mti.transaction_source_id
1718: and primary_reservation_quantity >= mti.primary_quantity);
1719:
1720:

Line 1748: inv_reservation_global.g_source_type_oe

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 =
1748: inv_reservation_global.g_source_type_oe
1749: and demand_source_header_id = mti.demand_source_header_id
1750: and nvl(demand_source_line_id, -1) =
1751: nvl(to_number(mti.demand_source_line), -1)
1752: and supply_source_type_id =

Line 1753: inv_reservation_global.g_source_type_inv

1749: and demand_source_header_id = mti.demand_source_header_id
1750: and nvl(demand_source_line_id, -1) =
1751: nvl(to_number(mti.demand_source_line), -1)
1752: and supply_source_type_id =
1753: inv_reservation_global.g_source_type_inv
1754: and subinventory_code = mti.subinventory_code
1755: and nvl(locator_id, -1) = nvl(mti.locator_id, -1)
1756: and primary_reservation_quantity >= -1*mti.primary_quantity);
1757: