APPS.INV_DIAG_OH_STATUS_CONTROL SQL Statements

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

Line: 19

 sqltxt    VARCHAR2(9999);  -- SQL select statement

Line: 32

  JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 36

  sqltxt := ' SELECT mtsv.status_code' ||
            ' || '' (''' ||
            ' ||mtsv.status_id' ||
            ' ||'')'' "StatusCode(Id)" ,' ||
            ' DECODE(onhand_control,1,''Yes'',''No'') "OnhandStatusControl"' ||
            ' FROM   mtl_material_statuses_vl mtsv' ||
            ' WHERE  mtsv.onhand_control = 2' ||
            ' AND EXISTS' ||
            ' (SELECT 1' ||
            ' FROM    mtl_parameters' ||
            ' WHERE   default_status_id IS NOT NULL' ||
            ' AND rownum < 2' ||
            ' ) ';