APPS.GME_RESERVE_CONC SQL Statements

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

Line: 74

         SELECT 'Reservation Exists'
         INTO l_dummy
         FROM MTL_RESERVATIONS
         WHERE DEMAND_SOURCE_LINE_ID = p_line_rec.line_id;

Line: 103

       SELECT 'Staging Exists'
       INTO   l_dummy
       FROM   WSH_DELIVERY_DETAILS
       WHERE  SOURCE_LINE_ID = p_line_rec.line_id
       AND    SOURCE_CODE = 'OE'
       AND    RELEASED_STATUS IN ('Y', 'C');

Line: 459

   SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
          FND_DATE.Canonical_To_Date(p_request_date_high),
          FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
          FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
          FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
          FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
          FND_DATE.Canonical_To_Date(p_ordered_date_low),
          FND_DATE.Canonical_To_Date(p_ordered_date_high)
   INTO   l_request_date_low,
          l_request_date_high,
          l_schedule_ship_date_low,
          l_schedule_ship_date_high,
          l_schedule_arrival_date_low,
          l_schedule_arrival_date_high,
          l_ordered_date_low,
          l_ordered_date_high
   FROM   DUAL;

Line: 492

   l_stmt := 'SELECT Line_id, l.org_id FROM  OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';

Line: 691

     l_line_rec.schedule_action_code := OESCH_ACT_RESERVE; -- do we need to update action code ??