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.WMS_XDOCK_PEGGING_PUB dependencies on MTL_RESERVATIONS

Line 409: FROM mtl_reservations

405: SELECT 1
406: INTO l_wip_exists
407: FROM dual
408: WHERE EXISTS (SELECT reservation_id
409: FROM mtl_reservations
410: WHERE organization_id = p_organization_id
411: AND inventory_item_id = p_inventory_item_id
412: AND demand_source_type_id = p_demand_type_id
413: AND demand_source_header_id = p_demand_header_id

Line 463: FROM mtl_reservations

459: SELECT 1
460: INTO l_non_wip_exists
461: FROM dual
462: WHERE EXISTS (SELECT reservation_id
463: FROM mtl_reservations
464: WHERE organization_id = p_organization_id
465: AND inventory_item_id = p_inventory_item_id
466: AND demand_source_type_id = p_demand_type_id
467: AND demand_source_header_id = p_demand_header_id

Line 2139: FROM mtl_reservations

2135: supply_source_line_id, supply_source_line_detail,
2136: reservation_quantity, reservation_uom_code,
2137: secondary_reservation_quantity, secondary_uom_code,
2138: primary_reservation_quantity, primary_uom_code
2139: FROM mtl_reservations
2140: WHERE organization_id = l_organization_id
2141: AND inventory_item_id = l_inventory_item_id
2142: AND demand_source_type_id = l_demand_type_id
2143: AND demand_source_line_id = l_demand_line_id

Line 6721: FROM mtl_reservations

6717: SELECT reservation_id, demand_source_type_id, demand_source_header_id,
6718: demand_source_line_id, reservation_quantity, reservation_uom_code,
6719: secondary_reservation_quantity, secondary_uom_code,
6720: primary_reservation_quantity, primary_uom_code
6721: FROM mtl_reservations
6722: WHERE organization_id = l_organization_id
6723: AND inventory_item_id = l_inventory_item_id
6724: AND ((p_lpn_context = 3 AND -- RCV supply
6725: supply_source_type_id = inv_reservation_global.g_source_type_rcv)

Line 7065: FROM mtl_reservations

7061: -- demand. This could be possible if the reservations have a different requirement date
7062: -- so the reservations were not merged.
7063: CURSOR existing_wip_rsvs IS
7064: SELECT DISTINCT demand_source_type_id, demand_source_header_id, demand_source_line_id
7065: FROM mtl_reservations
7066: WHERE organization_id = l_organization_id
7067: AND inventory_item_id = l_inventory_item_id
7068: AND supply_source_type_id = inv_reservation_global.g_source_type_wip
7069: AND supply_source_header_id = l_supply_header_id;