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 1585: and demand_source_type_id = inv_reservation_global.g_source_type_oe

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
1586: and demand_source_header_id = mti.demand_source_header_id
1587: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1588: and supply_source_header_id = mti.transaction_source_id
1589: and supply_source_type_id =

Line 1590: inv_reservation_global.g_source_type_wip)

1586: and demand_source_header_id = mti.demand_source_header_id
1587: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1588: and supply_source_header_id = mti.transaction_source_id
1589: and supply_source_type_id =
1590: inv_reservation_global.g_source_type_wip)
1591: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1592: and supply_source_type_id =
1593: inv_reservation_global.g_source_type_inv
1594: and subinventory_code = mti.subinventory_code

Line 1593: inv_reservation_global.g_source_type_inv

1589: and supply_source_type_id =
1590: inv_reservation_global.g_source_type_wip)
1591: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1592: and supply_source_type_id =
1593: inv_reservation_global.g_source_type_inv
1594: and subinventory_code = mti.subinventory_code
1595: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1596:
1597: -- validate demand so line

Line 1623: inv_reservation_global.g_source_type_oe

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 =
1623: inv_reservation_global.g_source_type_oe
1624: and demand_source_header_id = mti.demand_source_header_id
1625: and nvl(demand_source_line_id, -1) =
1626: nvl(to_number(mti.demand_source_line), -1)
1627: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION

Line 1630: inv_reservation_global.g_source_type_wip)

1626: nvl(to_number(mti.demand_source_line), -1)
1627: and ( ( mti.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1628: and supply_source_header_id = mti.transaction_source_id
1629: and supply_source_type_id =
1630: inv_reservation_global.g_source_type_wip)
1631: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1632: and supply_source_type_id =
1633: inv_reservation_global.g_source_type_inv
1634: and subinventory_code = mti.subinventory_code

Line 1633: inv_reservation_global.g_source_type_inv

1629: and supply_source_type_id =
1630: inv_reservation_global.g_source_type_wip)
1631: or ( mti.transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1632: and supply_source_type_id =
1633: inv_reservation_global.g_source_type_inv
1634: and subinventory_code = mti.subinventory_code
1635: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1636:
1637:

Line 1665: inv_reservation_global.g_source_type_oe

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 =
1665: inv_reservation_global.g_source_type_oe
1666: and demand_source_header_id = mti.demand_source_header_id
1667: and nvl(demand_source_line_id, -1) =
1668: nvl(to_number(mti.demand_source_line), -1)
1669: and supply_source_type_id =

Line 1670: inv_reservation_global.g_source_type_wip

1666: and demand_source_header_id = mti.demand_source_header_id
1667: and nvl(demand_source_line_id, -1) =
1668: nvl(to_number(mti.demand_source_line), -1)
1669: and supply_source_type_id =
1670: inv_reservation_global.g_source_type_wip
1671: and supply_source_header_id = mti.transaction_source_id
1672: and primary_reservation_quantity >= mti.primary_quantity);
1673:
1674:

Line 1702: inv_reservation_global.g_source_type_oe

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 =
1702: inv_reservation_global.g_source_type_oe
1703: and demand_source_header_id = mti.demand_source_header_id
1704: and nvl(demand_source_line_id, -1) =
1705: nvl(to_number(mti.demand_source_line), -1)
1706: and supply_source_type_id =

Line 1707: inv_reservation_global.g_source_type_inv

1703: and demand_source_header_id = mti.demand_source_header_id
1704: and nvl(demand_source_line_id, -1) =
1705: nvl(to_number(mti.demand_source_line), -1)
1706: and supply_source_type_id =
1707: inv_reservation_global.g_source_type_inv
1708: and subinventory_code = mti.subinventory_code
1709: and nvl(locator_id, -1) = nvl(mti.locator_id, -1)
1710: and primary_reservation_quantity >= -1*mti.primary_quantity);
1711: