VIEW: APPS.CSC_PROF_TABLE_COLUMNS_VL

Source

View Text - Preformatted

SELECT B.rowid ROW_ID , B.table_column_id , B.block_id , B.table_name , B.alias_name , B.column_name , B.column_sequence , B.drilldown_column_flag , TL.label , B.last_update_date , B.last_updated_by , B.creation_date , B.created_by , B.last_update_login , B.object_version_number FROM csc_prof_table_columns_b B , csc_prof_table_columns_tl TL WHERE B.table_column_id = TL.table_column_id AND TL.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.TABLE_COLUMN_ID
, B.BLOCK_ID
, B.TABLE_NAME
, B.ALIAS_NAME
, B.COLUMN_NAME
, B.COLUMN_SEQUENCE
, B.DRILLDOWN_COLUMN_FLAG
, TL.LABEL
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
FROM CSC_PROF_TABLE_COLUMNS_B B
, CSC_PROF_TABLE_COLUMNS_TL TL
WHERE B.TABLE_COLUMN_ID = TL.TABLE_COLUMN_ID
AND TL.LANGUAGE = USERENV('LANG')