APPS.OE_INC_ITEMS_FREEZE_CONC SQL Statements

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

Line: 21

 |                 First select all the lines depending|
 |                 upon the parameters and eligibility |
 |                 and complete the activity.          |
 +-----------------------------------------------------*/


PROCEDURE Request
( ERRBUF                 OUT  NOCOPY VARCHAR2
 ,RETCODE                OUT  NOCOPY VARCHAR2
 ,p_org_id		 IN          NUMBER
 ,p_order_num_low        IN          NUMBER
 ,p_order_num_high       IN          NUMBER
 ,p_inventory_item_id    IN          NUMBER
 ,p_schedule_date_low    IN          VARCHAR2
 ,p_schedule_date_high   IN          VARCHAR2
 ,p_num_of_days          IN          NUMBER
 ,p_ship_set_id          IN          NUMBER
) IS

l_line_id                  NUMBER;

Line: 67

   l_sql_stmt := 'SELECT   L.line_id, L.org_id  FROM     oe_order_lines L'     ||
                 ',oe_order_headers_all H '                                    ||
                 ',wf_item_activity_statuses WIAS'                             ||
	         ',wf_process_activities WPA'                                  ||
                 ' WHERE  l.open_flag           =   ''Y'' '                      ||
                 ' AND  WIAS.Process_Activity =   WPA.instance_id'             ||
                 ' AND  WPA.activity_name     =  ''FREEZE_INCLUDED_ITEMS_ELIGIBLE'''  ||
                 ' AND  WIAS.item_type        =   ''OEOL'''                    ||
                 ' AND  WPA.activity_item_type =  ''OEOL'''                    ||
                 ' AND  WIAS.item_key         =   l.line_id'          ||
                 ' AND  WIAS.activity_status  =   ''NOTIFIED''' ;

Line: 131

    SELECT
          FND_DATE.Canonical_To_Date(p_schedule_date_low),
          FND_DATE.Canonical_To_Date(p_schedule_date_high)
    INTO
          l_schedule_date_low,
          l_schedule_date_high
    FROM   DUAL;