APPS.OE_PUR_CONC_REQUESTS SQL Statements

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

Line: 21

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

Line: 99

   SELECT fnd_date.canonical_to_date(p_request_date_low),
          fnd_date.canonical_to_date(p_request_date_high)
   INTO   l_request_date_low,
          l_request_date_high
   FROM   DUAL;

Line: 106

  /* l_sql_stmt := ' SELECT SL.LINE_ID, SL.ORG_ID '||
                 ' FROM MTL_SYSTEM_ITEMS MSI,  OE_ORDER_LINES SL, OE_ORDER_HEADERS_ALL SH  '||
                 ' WHERE SL.HEADER_ID = SH.HEADER_ID '||
                 ' AND SL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID '||
                 ' AND SL.SHIP_FROM_ORG_ID = MSI.ORGANIZATION_ID '||
                 ' AND SL.SOURCE_TYPE_CODE = ''EXTERNAL'''; */

Line: 113

    l_sql_stmt := ' SELECT SL.LINE_ID, SL.ORG_ID '||
                 ' FROM OE_ORDER_LINES SL, OE_ORDER_HEADERS_ALL SH  '||
                 ' WHERE SL.HEADER_ID = SH.HEADER_ID '||
                 ' AND SL.SOURCE_TYPE_CODE = ''EXTERNAL''';

Line: 268

                 SELECT wias.ACTIVITY_STATUS, wias.activity_result_code
                 INTO   l_activity_status, l_activity_result
                 FROM   wf_item_activity_statuses wias, wf_process_activities wpa
                 WHERE  wias.process_activity = wpa.instance_id
                 AND    wpa.activity_name = 'PUR_REL_THE_LINE'
                 AND    wias.item_type = 'OEOL'
                 AND    wias.item_key  = to_char(v_line_id);