APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_RESERVATIONS

Line 3262: FROM mtl_reservations

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

Line 3279: FROM mtl_reservations

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

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 6253: l_primary_res_qty FROM mtl_reservations

6249: -- line.
6250:
6251: BEGIN
6252: SELECT Nvl(SUM(primary_reservation_quantity),0) INTO
6253: l_primary_res_qty FROM mtl_reservations
6254: WHERE supply_source_type_id =
6255: inv_reservation_global.g_source_type_internal_req AND
6256: supply_source_header_id = p_header_id AND
6257: supply_source_line_id = p_line_id;