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 399: FROM mtl_reservations

395: SELECT 1
396: INTO l_wip_exists
397: FROM dual
398: WHERE EXISTS (SELECT reservation_id
399: FROM mtl_reservations
400: WHERE organization_id = p_organization_id
401: AND inventory_item_id = p_inventory_item_id
402: AND demand_source_type_id = p_demand_type_id
403: AND demand_source_header_id = p_demand_header_id

Line 453: FROM mtl_reservations

449: SELECT 1
450: INTO l_non_wip_exists
451: FROM dual
452: WHERE EXISTS (SELECT reservation_id
453: FROM mtl_reservations
454: WHERE organization_id = p_organization_id
455: AND inventory_item_id = p_inventory_item_id
456: AND demand_source_type_id = p_demand_type_id
457: AND demand_source_header_id = p_demand_header_id

Line 2114: FROM mtl_reservations

2110: supply_source_line_id, supply_source_line_detail,
2111: reservation_quantity, reservation_uom_code,
2112: secondary_reservation_quantity, secondary_uom_code,
2113: primary_reservation_quantity, primary_uom_code
2114: FROM mtl_reservations
2115: WHERE organization_id = l_organization_id
2116: AND inventory_item_id = l_inventory_item_id
2117: AND demand_source_type_id = l_demand_type_id
2118: AND demand_source_line_id = l_demand_line_id

Line 6546: FROM mtl_reservations

6542: SELECT reservation_id, demand_source_type_id, demand_source_header_id,
6543: demand_source_line_id, reservation_quantity, reservation_uom_code,
6544: secondary_reservation_quantity, secondary_uom_code,
6545: primary_reservation_quantity, primary_uom_code
6546: FROM mtl_reservations
6547: WHERE organization_id = l_organization_id
6548: AND inventory_item_id = l_inventory_item_id
6549: AND ((p_lpn_context = 3 AND -- RCV supply
6550: supply_source_type_id = inv_reservation_global.g_source_type_rcv)

Line 6890: FROM mtl_reservations

6886: -- demand. This could be possible if the reservations have a different requirement date
6887: -- so the reservations were not merged.
6888: CURSOR existing_wip_rsvs IS
6889: SELECT DISTINCT demand_source_type_id, demand_source_header_id, demand_source_line_id
6890: FROM mtl_reservations
6891: WHERE organization_id = l_organization_id
6892: AND inventory_item_id = l_inventory_item_id
6893: AND supply_source_type_id = inv_reservation_global.g_source_type_wip
6894: AND supply_source_header_id = l_supply_header_id;