eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_TABLE_PUBLISH_PKG SQL Statements

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

Line: 61


SELECT LOWER(ISO_LANGUAGE) lang, ISO_TERRITORY terr FROM FND_LANGUAGES WHERE LANGUAGE_CODE = USERENV('LANG');

Line: 153


selectclause CLOB;

Line: 193


SELECT DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID,
       DataInspectorColumnsEO.TABLE_NAME,
       DataInspectorColumnsEO.COLUMN_NAME,
       DataInspectorColumnsEO.DISPLAY_SEQUENCE,
       EnabledTableColumnEO.DISPLAY_NAME,
       EnabledTableColumnEO.FEM_DATA_TYPE_CODE,
       EnabledTableColumnEO.DIMENSION_ID,
       DataInspectorColumnsEO.SORT_SEQUENCE,
       DataInspectorColumnsEO.SORT_DIRECTION_FLAG,
       (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
member_name_col,
       (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
member_code_col,
(select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
member_table_name,
(select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
dimension_varchar_label,
(select dimension_name from fem_dimensions_vl where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS dimension_name,
(select member_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS member_col
FROM   FEM_DATA_INSPECTOR_COLS DataInspectorColumnsEO,
       FEM_TAB_COLUMNS_V EnabledTableColumnEO
WHERE  EnabledTableColumnEO.TABLE_NAME = DataInspectorColumnsEO.TABLE_NAME
AND    EnabledTableColumnEO.COLUMN_NAME = DataInspectorColumnsEO.COLUMN_NAME
AND    DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
ORDER BY DataInspectorColumnsEO.DISPLAY_SEQUENCE ASC;

Line: 220


SELECT COLUMN_NAME,
       SORT_SEQUENCE,
       SORT_DIRECTION_FLAG
FROM   FEM_DATA_INSPECTOR_COLS
WHERE  DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
AND    SORT_SEQUENCE IS NOT NULL
ORDER BY SORT_SEQUENCE ASC;

Line: 229


SELECT TABLE_NAME FROM FEM_DATA_INSPECTORS WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId;

Line: 232


SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME  FROM    FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL
   WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND
        FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;

Line: 237


SELECT DISPLAY_NAME FROM FEM_TABLES_VL WHERE TABLE_NAME = l_tablename;

Line: 240


SELECT display_name from fem_object_definition_vl where object_definition_id = p_diObjDefId;

Line: 324


dbms_lob.createtemporary(selectClause,TRUE);

Line: 341


 l_bal_sum_query := ' SELECT SUM(' || row_record.COLUMN_NAME || ') FROM ' || row_record.TABLE_NAME;

Line: 362


   l_queryString := ' CURSOR ( SELECT '''||  col_count ||  ''' as colNum,
'||row_record.member_table_name || '.' || row_record.member_name_col || ' as colValue ' ||' from ' ||
row_record.member_table_name || ', ' || l_tablename ||' b ' ||' where ' || row_record.member_table_name || '.' || row_record.member_col || '(+)=' ||
'b' || '.'||row_record.COLUMN_NAME || ' and  a.rowid = b.rowid ' || ') as col , ';

Line: 368


   l_queryString := ' CURSOR ( SELECT ''' || col_count || ''' as colNum,
'||row_record.member_table_name || '.' || row_record.member_code_col || ' as colValue ' ||' from ' ||
row_record.member_table_name || ', ' || l_tablename ||' b ' ||' where ' || row_record.member_table_name || '.' || row_record.member_col || '(+)=' ||
'b' || '.'||row_record.COLUMN_NAME || ' and  a.rowid = b.rowid ' || ') as col , ' ;

Line: 376


    l_queryString := ' CURSOR ( SELECT '''  || col_count ||  ''' as colNum, '||
    row_record.TABLE_NAME || '.' || ROW_RECORD.COLUMN_NAME || ' as colValue' || ' from ' || row_record.TABLE_NAME ||
    ' where ' ||  row_record.TABLE_NAME || '.' || 'ROWID' || ' = ' || 'a' || '.' || 'ROWID'
    || ' ) as col , ' ;

Line: 383


 dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);

Line: 394


dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);

Line: 407


l_queryString := 'SELECT ';

Line: 410


dbms_lob.append(l_query,selectClause);

Line: 519


dbms_lob.freetemporary(selectClause);

Line: 582


selectclause CLOB;

Line: 622


SELECT DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID,
       DataInspectorColumnsEO.TABLE_NAME,
       DataInspectorColumnsEO.COLUMN_NAME,
       DataInspectorColumnsEO.DISPLAY_SEQUENCE,
       EnabledTableColumnEO.DISPLAY_NAME,
       EnabledTableColumnEO.FEM_DATA_TYPE_CODE,
       EnabledTableColumnEO.DIMENSION_ID,
       DataInspectorColumnsEO.SORT_SEQUENCE,
       DataInspectorColumnsEO.SORT_DIRECTION_FLAG,
       (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
member_name_col,
(select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
member_code_col,
(select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
member_table_name,
(select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
dimension_varchar_label,
(select dimension_name from fem_dimensions_vl where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS dimension_name,
(select member_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS member_col
FROM   FEM_DATA_INSPECTOR_COLS DataInspectorColumnsEO,
       FEM_TAB_COLUMNS_V EnabledTableColumnEO
WHERE  EnabledTableColumnEO.TABLE_NAME = DataInspectorColumnsEO.TABLE_NAME
AND    EnabledTableColumnEO.COLUMN_NAME = DataInspectorColumnsEO.COLUMN_NAME
AND    DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
ORDER BY DataInspectorColumnsEO.DISPLAY_SEQUENCE ASC;

Line: 649


SELECT TABLE_NAME FROM FEM_DATA_INSPECTORS WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId;

Line: 652


SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME  FROM    FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL
   WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND
        FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;

Line: 658


SELECT COLUMN_NAME,
       SORT_SEQUENCE,
       SORT_DIRECTION_FLAG
FROM   FEM_DATA_INSPECTOR_COLS
WHERE  DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
AND    SORT_SEQUENCE IS NOT NULL
ORDER BY SORT_SEQUENCE ASC;

Line: 706


  dbms_lob.createtemporary(selectClause,TRUE);

Line: 708


  l_queryString :=  'SELECT ';

Line: 709


  dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);

Line: 715


       l_queryString :=  ' ( SELECT ' ||
       row_record.member_table_name || '.' || row_record.member_name_col ||' from ' ||
       row_record.member_table_name || ', ' || l_tablename ||' b ' ||' where ' || row_record.member_table_name || '.' || row_record.member_col || '(+)=' ||
       'b' || '.'||row_record.COLUMN_NAME || ' and  a.rowid = b.rowid ' || ') as ' || row_record.member_name_col || ' , ';

Line: 721


       l_queryString :=  ' ( SELECT ' ||
       row_record.member_table_name || '.' || row_record.member_code_col ||' from ' ||
       row_record.member_table_name || ', ' || l_tablename ||' b ' ||' where ' || row_record.member_table_name || '.' || row_record.member_col || '(+)=' ||
       'b' || '.'||row_record.COLUMN_NAME || ' and  a.rowid = b.rowid ' || ') as ' || row_record.member_code_col || ' , ';

Line: 731


      dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);

Line: 735


  dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);

Line: 739


    dbms_lob.append(l_query,selectClause);

Line: 826


dbms_lob.freetemporary(selectClause);