APPS.OE_SCH_FIRM_CONC SQL Statements

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

Line: 18

  SELECT ACTIVITY_STATUS
  INTO l_activity_status_code
  FROM wf_item_activity_statuses wias, wf_process_activities wpa
  WHERE wias.item_type = 'OEOL' AND
        wias.item_key  = to_char(p_line_id) AND
        wias.process_activity = wpa.instance_id AND
        wpa.activity_name = 'FIRM_ELIGIBLE' AND
        wias.activity_status = 'NOTIFIED';

Line: 80

    Select item_key, l.org_id
    From   wf_item_activity_statuses wias, wf_process_activities wpa,
    oe_order_lines l
    Where  wias.item_type = 'OEOL'
    And    wias.process_activity = wpa.instance_id
    And    wpa.activity_item_type = 'OEOL'
    And    wpa.activity_name = 'FIRM_ELIGIBLE'
    And    wias.activity_status = 'NOTIFIED'
    And    wias.item_key = l.line_id
    order by l.org_id;

Line: 202

     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: 221

     l_sql_stmt := 'SELECT Line_id, l.org_id FROM  OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ';