APPS.INV_RESERVATION_AVAIL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 301

             SELECT nvl(sum(primary_reservation_quantity), 0)
             INTO   l_primary_reserved_quantity
             FROM   mtl_reservations
             WHERE  supply_source_type_id = p_supply_source_type_id
             AND    supply_source_header_id = p_supply_source_header_id
             AND    supply_source_line_id = p_supply_source_line_id;

Line: 308

             SELECT nvl(sum(primary_reservation_quantity), 0)
             INTO   l_primary_reserved_quantity
             FROM   mtl_reservations
             WHERE  supply_source_type_id = p_supply_source_type_id
             AND    supply_source_header_id = p_supply_source_header_id;

Line: 435

               SELECT nvl(sum(primary_reservation_quantity), 0)
               INTO   l_primary_reserved_quantity
               FROM   mtl_reservations
               WHERE  supply_source_type_id = p_supply_source_type_id
               AND    supply_source_header_id = p_supply_source_header_id
               AND    supply_source_line_id = p_supply_source_line_id
               AND    nvl(project_id, -99) = nvl(p_project_id, -99)
               AND    nvl(task_id, -99) = nvl(p_task_id, -99);

Line: 457

               SELECT nvl(sum(primary_reservation_quantity), 0)
               INTO   l_primary_reserved_quantity
               FROM   mtl_reservations
               WHERE  supply_source_type_id = p_supply_source_type_id
               AND    supply_source_header_id = p_supply_source_header_id
               AND    supply_source_line_id = p_supply_source_line_id
               AND    supply_source_line_detail = p_supply_source_line_detail
               AND    nvl(project_id, -99) = nvl(p_project_id, -99)
               AND    nvl(task_id, -99) = nvl(p_task_id, -99);

Line: 562

           SELECT nvl(sum(primary_reservation_quantity), 0)
           INTO   l_primary_reserved_quantity
           FROM   mtl_reservations
           WHERE  supply_source_type_id = p_supply_source_type_id
           AND    organization_id = p_organization_id
           AND    inventory_item_id = p_item_id;

Line: 769

              SELECT nvl(sum(primary_reservation_quantity), 0)
              INTO   l_primary_reserved_quantity
              FROM   mtl_reservations
              WHERE  demand_source_type_id = p_demand_source_type_id
              AND    demand_source_header_id = p_demand_source_header_id
              AND    demand_source_line_id = p_demand_source_line_id
              AND    demand_source_line_detail = p_demand_source_line_detail;

Line: 832

              SELECT nvl(sum(primary_reservation_quantity), 0)
              INTO   l_primary_reserved_quantity
              FROM   mtl_reservations
              WHERE  demand_source_type_id = p_demand_source_type_id
              AND    demand_source_header_id = p_demand_source_header_id
              AND    demand_source_line_id = p_demand_source_line_id;

Line: 889

               SELECT nvl(sum(requested_quantity), 0)
               INTO   l_wdd_primary_quantity
               FROM   wsh_delivery_details
               WHERE  source_line_id = p_demand_source_line_id
               AND    delivery_detail_id = p_demand_source_line_detail
               AND    nvl(project_id, -99) = nvl(p_project_id, -99)
               AND    nvl(task_id, -99) = nvl(p_task_id, -99);

Line: 915

               SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
               INTO   l_wdd_primary_reserved_qty, l_rsv_primary_uom_code
               FROM   mtl_reservations
               WHERE  demand_source_type_id = p_demand_source_type_id
               AND    demand_source_header_id = p_demand_source_header_id
               AND    demand_source_line_id = p_demand_source_line_id
               AND    demand_source_line_detail = p_demand_source_line_detail
               GROUP BY primary_uom_code;

Line: 942

               SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
               INTO   l_primary_reserved_quantity, l_rsv_primary_uom_code
               FROM   mtl_reservations
               WHERE  demand_source_type_id = p_demand_source_type_id
               AND    demand_source_header_id = p_demand_source_header_id
               AND    demand_source_line_id = p_demand_source_line_id
               GROUP BY primary_uom_code;

Line: 973

               SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
               INTO   l_primary_reserved_quantity, l_rsv_primary_uom_code
               FROM   mtl_reservations
               WHERE  demand_source_type_id = p_demand_source_type_id
               AND    demand_source_header_id = p_demand_source_header_id
               AND    demand_source_line_id = p_demand_source_line_id
               GROUP BY primary_uom_code;

Line: 1003

               SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
               INTO   l_primary_reserved_quantity, l_rsv_primary_uom_code
               FROM   mtl_reservations
               WHERE  demand_source_type_id = p_demand_source_type_id
               AND    demand_source_header_id = p_demand_source_header_id
               AND    demand_source_line_id = p_demand_source_line_id
               AND    demand_source_line_detail is null
               GROUP BY primary_uom_code;

Line: 1031

           SELECT ordered_quantity + (ordered_quantity * ship_tolerance_above/100), order_quantity_uom
           INTO   l_available_quantity, l_order_quantity_uom_code
           FROM   oe_order_lines_all
           WHERE  line_id = p_demand_source_line_id
           AND    nvl(project_id, -99) = nvl(p_project_id, -99)
           AND    nvl(task_id, -99) = nvl(p_task_id, -99);

Line: 1050

		 SELECT primary_uom_code INTO l_rsv_primary_uom_code FROM
		   mtl_system_items WHERE organization_id = p_organization_id
		   AND inventory_item_id = p_item_id;