CMP_TCS_COL_IN_CAT_VL

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name
COL_IN_CAT_ID CAT_ID ORDR_NUM DISPLAY_NAME COLUMN_TYPE_CD DATA_TYPE_CD CONTRIBUTOR_TYPE_CD HIDE_COLUMN_FLAG AVAIL_FOR_DISP_FLAG HIDE_IN_PDF_FLAG INCLUDE_IN_CHART1_FLAG INCLUDE_IN_CHART2_FLAG BUSINESS_GROUP_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

Select CAT.COL_IN_CAT_ID ,CAT.CAT_ID ,CAT.ORDR_NUM ,CAT_TL.DISPLAY_NAME ,CAT.COLUMN_TYPE_CD ,CAT.DATA_TYPE_CD ,CAT.CONTRIBUTOR_TYPE_CD ,CAT.HIDE_COLUMN_FLAG ,CAT.AVAIL_FOR_DISP_FLAG ,CAT.HIDE_IN_PDF_FLAG ,CAT.INCLUDE_IN_CHART1_FLAG ,CAT.INCLUDE_IN_CHART2_FLAG ,CAT.BUSINESS_GROUP_ID ,CAT.CREATED_BY ,CAT.CREATION_DATE ,CAT.LAST_UPDATED_BY ,CAT.LAST_UPDATE_DATE ,CAT.LAST_UPDATE_LOGIN ,CAT.OBJECT_VERSION_NUMBER FRom CMP_TCS_COL_IN_CAT CAT , CMP_TCS_COL_IN_CAT_TL CAT_TL WHERE CAT.COL_IN_CAT_ID = CAT_TL.COL_IN_CAT_ID AND CAT_TL.LANGUAGE = USERENV('LANG') AND CAT.BUSINESS_GROUP_ID = CAT_TL.BUSINESS_GROUP_ID