CMP_TCS_STMT_ROW_DEF_VL

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

STMT_TBL_ROW_DEF_ID STMT_PERD_ID PERD_RUN_ID STMT_PAGE_DEF_ID SUBCAT_ID ROW_IN_CAT_ID ORDR_NUM DISPLAY_NAME URL DESCRIPTION SUBCAT_HAS_ER_ITEMS_FLAG SUBCAT_HAS_EE_ITEMS_FLAG SUBCAT_CNTRBS_TYPE_CD SUBCAT_NNMNTRY_UOM COLUMN1_ROUNDING_CD COLUMN1_ITEM_ID COLUMN1_NNMNTRY_UOM COLUMN1_ESTIMATED_FLAG COLUMN2_ROUNDING_CD COLUMN2_ITEM_ID COLUMN2_NNMNTRY_UOM COLUMN2_ESTIMATED_FLAG COLUMN3_ROUNDING_CD COLUMN3_ITEM_ID COLUMN3_NNMNTRY_UOM COLUMN3_ESTIMATED_FLAG COLUMN4_ROUNDING_CD COLUMN4_ITEM_ID COLUMN4_NNMNTRY_UOM COLUMN4_ESTIMATED_FLAG COLUMN5_ROUNDING_CD COLUMN5_ITEM_ID COLUMN5_NNMNTRY_UOM COLUMN5_ESTIMATED_FLAG COLUMN1_DATA_TYPE_CD COLUMN2_DATA_TYPE_CD COLUMN3_DATA_TYPE_CD COLUMN4_DATA_TYPE_CD COLUMN5_DATA_TYPE_CD ZERO_VALUE_OPTIONS HIDE_ZERO_ALERT_FLAG ZERO_ALERT_MSG EXCLUDE_FROM_SMRY_FLAG HISTORY_DATA_FLAG BUSINESS_GROUP_ID BUSINESS_GROUP_ID2 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ROWDEF.STMT_TBL_ROW_DEF_ID ,ROWDEF.STMT_PERD_ID ,ROWDEF.PERD_RUN_ID ,ROWDEF.STMT_PAGE_DEF_ID ,ROWDEF.SUBCAT_ID ,ROWDEF.ROW_IN_CAT_ID ,ROWDEF.ORDR_NUM ,ROWDEF_TL.DISPLAY_NAME ,ROWDEF.URL ,ROWDEF_TL.DESCRIPTION ,ROWDEF.SUBCAT_HAS_ER_ITEMS_FLAG ,ROWDEF.SUBCAT_HAS_EE_ITEMS_FLAG ,ROWDEF.SUBCAT_CNTRBS_TYPE_CD ,ROWDEF.SUBCAT_NNMNTRY_UOM ,ROWDEF.COLUMN1_ROUNDING_CD ,ROWDEF.COLUMN1_ITEM_ID ,ROWDEF.COLUMN1_NNMNTRY_UOM ,ROWDEF.COLUMN1_ESTIMATED_FLAG ,ROWDEF.COLUMN2_ROUNDING_CD ,ROWDEF.COLUMN2_ITEM_ID ,ROWDEF.COLUMN2_NNMNTRY_UOM ,ROWDEF.COLUMN2_ESTIMATED_FLAG ,ROWDEF.COLUMN3_ROUNDING_CD ,ROWDEF.COLUMN3_ITEM_ID ,ROWDEF.COLUMN3_NNMNTRY_UOM ,ROWDEF.COLUMN3_ESTIMATED_FLAG ,ROWDEF.COLUMN4_ROUNDING_CD ,ROWDEF.COLUMN4_ITEM_ID ,ROWDEF.COLUMN4_NNMNTRY_UOM ,ROWDEF.COLUMN4_ESTIMATED_FLAG ,ROWDEF.COLUMN5_ROUNDING_CD ,ROWDEF.COLUMN5_ITEM_ID ,ROWDEF.COLUMN5_NNMNTRY_UOM ,ROWDEF.COLUMN5_ESTIMATED_FLAG ,ROWDEF.COLUMN1_DATA_TYPE_CD ,ROWDEF.COLUMN2_DATA_TYPE_CD ,ROWDEF.COLUMN3_DATA_TYPE_CD ,ROWDEF.COLUMN4_DATA_TYPE_CD ,ROWDEF.COLUMN5_DATA_TYPE_CD ,ROWDEF.ZERO_VALUE_OPTIONS ,ROWDEF.HIDE_ZERO_ALERT_FLAG ,ROWDEF_TL.ZERO_ALERT_MSG ,ROWDEF.EXCLUDE_FROM_SMRY_FLAG ,ROWDEF.HISTORY_DATA_FLAG ,ROWDEF.BUSINESS_GROUP_ID ,ROWDEF_TL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID2 ,ROWDEF.REQUEST_ID ,ROWDEF.JOB_DEFINITION_NAME ,ROWDEF.JOB_DEFINITION_PACKAGE ,ROWDEF.CREATED_BY ,ROWDEF.CREATION_DATE ,ROWDEF.LAST_UPDATED_BY ,ROWDEF.LAST_UPDATE_DATE ,ROWDEF.LAST_UPDATE_LOGIN FROM CMP_TCS_STMT_TBL_ROW_DEF ROWDEF , CMP_TCS_STMT_ROW_DEF_TL ROWDEF_TL WHERE ROWDEF.STMT_TBL_ROW_DEF_ID = ROWDEF_TL.STMT_TBL_ROW_DEF_ID AND ROWDEF_TL.LANGUAGE = USERENV('LANG') AND ROWDEF.BUSINESS_GROUP_ID = ROWDEF_TL.BUSINESS_GROUP_ID