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

Line 1745: FROM MTL_RESERVATIONS

1741: END IF;
1742:
1743: SELECT 'Reservation Exists'
1744: INTO l_dummy
1745: FROM MTL_RESERVATIONS
1746: WHERE DEMAND_SOURCE_LINE_ID = p_line_rec.line_id;
1747:
1748: IF l_debug_level > 0 THEN
1749: OE_DEBUG_PUB.Add('Reservations exists on the line',3);

Line 2469: l_stmt := l_stmt ||' AND NOT Exists (SELECT 1 FROM mtl_reservations mrs '

2465: l_stmt := l_stmt ||' AND l.line_id IN(SELECT line_id FROM
2466: oe_rsv_set_details WHERE reservation_set_id=:set_id)';
2467: END IF;
2468: IF p_reservation_mode = 'PARTIAL_ONLY_UNRESERVED' THEN -- Pack J
2469: l_stmt := l_stmt ||' AND NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2470: ||' WHERE l.line_id = mrs.demand_source_line_id)';
2471: ELSIF p_reservation_mode ='PARTIAL' THEN
2472: l_stmt := l_stmt ||' AND (NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2473: ||' WHERE l.line_id = mrs.demand_source_line_id)'

Line 2472: l_stmt := l_stmt ||' AND (NOT Exists (SELECT 1 FROM mtl_reservations mrs '

2468: IF p_reservation_mode = 'PARTIAL_ONLY_UNRESERVED' THEN -- Pack J
2469: l_stmt := l_stmt ||' AND NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2470: ||' WHERE l.line_id = mrs.demand_source_line_id)';
2471: ELSIF p_reservation_mode ='PARTIAL' THEN
2472: l_stmt := l_stmt ||' AND (NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2473: ||' WHERE l.line_id = mrs.demand_source_line_id)'
2474: ||' OR l. ordered_quantity > (select sum(INV_CONVERT.INV_UM_CONVERT( '
2475: ||' l.inventory_item_id, 5, reservation_quantity, reservation_uom_code,'
2476: ||' l.order_quantity_uom, NULL, NULL)) from mtl_reservations '

Line 2476: ||' l.order_quantity_uom, NULL, NULL)) from mtl_reservations '

2472: l_stmt := l_stmt ||' AND (NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2473: ||' WHERE l.line_id = mrs.demand_source_line_id)'
2474: ||' OR l. ordered_quantity > (select sum(INV_CONVERT.INV_UM_CONVERT( '
2475: ||' l.inventory_item_id, 5, reservation_quantity, reservation_uom_code,'
2476: ||' l.order_quantity_uom, NULL, NULL)) from mtl_reservations '
2477: ||' where demand_source_line_id = l.line_id))';
2478: END IF;
2479:
2480: l_stmt := l_stmt|| ' AND l.shipped_quantity IS NULL'||