APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_RESERVATIONS

Line 3264: FROM mtl_reservations

3260: CURSOR get_inv_res_qty(v_demand_header_id IN NUMBER,
3261: v_demand_line_id IN NUMBER) IS
3262: --SELECT sum(nvl(reservation_quantity,0))
3263: SELECT sum(nvl(primary_reservation_quantity,0)) sum_pri_res_qty, primary_uom_code
3264: FROM mtl_reservations
3265: WHERE demand_source_header_id = v_demand_header_id
3266: AND demand_source_line_id = v_demand_line_id
3267: AND demand_source_type_id in (inv_reservation_global.g_source_type_oe,
3268: inv_reservation_global.g_source_type_internal_ord)

Line 3281: FROM mtl_reservations

3277:
3278: CURSOR get_res_exists(v_requisition_header_id IN NUMBER,
3279: v_requisition_line_id IN NUMBER) IS
3280: SELECT 'Exists'
3281: FROM mtl_reservations
3282: WHERE supply_source_header_id = v_requisition_header_id
3283: AND supply_source_line_id = v_requisition_line_id
3284: AND Supply_source_type_id=inv_reservation_global.g_source_type_req;
3285:

Line 3331: FROM mtl_reservations

3327: ,v_task_id IN NUMBER) IS
3328: SELECT reservation_uom_code
3329: , primary_uom_code
3330: , sum(nvl(primary_reservation_quantity,0)) primary_reservation_quantity
3331: FROM mtl_reservations
3332: WHERE supply_source_header_id = v_po_header_id
3333: AND supply_source_line_id = v_po_line_location_id
3334: AND supply_source_type_id = inv_reservation_global.g_source_type_po
3335: AND Nvl(project_id,-99) = nvl(v_project_id, -99)

Line 6005: l_primary_res_qty FROM mtl_reservations

6001: -- line.
6002:
6003: BEGIN
6004: SELECT Nvl(SUM(primary_reservation_quantity),0) INTO
6005: l_primary_res_qty FROM mtl_reservations
6006: WHERE supply_source_type_id =
6007: inv_reservation_global.g_source_type_internal_req AND
6008: supply_source_header_id = p_header_id AND
6009: supply_source_line_id = p_line_id;