CMP_TCS_STMT_VL

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

STMT_ID EE_PROFILE_ID STAT_CD NAME DESCRIPTION INDICATE_ESTIMATE_FLAG STMT_GENERATED_FLAG SMRY_DESC_TXT HIDE_SMRY_DESC_TXT_FLAG SMRY_DESC_TXT_ORDR_NUM HIDE_SMRY_FLAG SMRY_TITLE SMRY_ADDL_INFO_TITLE SMRY_ADDL_INFO HIDE_SMRY_ADDL_INFO_FLAG BUSINESS_GROUP_ID BUSINESS_GROUP_ID2 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PDF_LOCAL_CURR_FLAG PDF_LOCAL_CURR_AVLBL PDF_OTHER_CURR_FLAG PDF_OTHER_CURR_CODE PDF_OTHER_CURR_AVLBL CURR_SWITCHER_DEFAULT HIDE_PDF_ITEM_DETAILS_FLAG HIDE_OL_DRILL_SECTIONS_FLAG DISPLAY_JOB_FLAG DISPLAY_POSITION_FLAG

Query

SQL_Statement

SELECT STMT.STMT_ID, STMT.EE_PROFILE_ID, STMT.STAT_CD, STMT_TL.NAME, STMT_TL.DESCRIPTION, STMT.INDICATE_ESTIMATE_FLAG, STMT.STMT_GENERATED_FLAG, STMT_TL.SMRY_DESC_TXT, STMT.HIDE_SMRY_DESC_TXT_FLAG, STMT.SMRY_DESC_TXT_ORDR_NUM, STMT.HIDE_SMRY_FLAG, STMT_TL.SMRY_TITLE, STMT_TL.SMRY_ADDL_INFO_TITLE, STMT_TL.SMRY_ADDL_INFO, STMT.HIDE_SMRY_ADDL_INFO_FLAG, STMT.BUSINESS_GROUP_ID, STMT_TL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID2, STMT.CREATED_BY, STMT.CREATION_DATE, STMT.LAST_UPDATED_BY, STMT.LAST_UPDATE_DATE, STMT.LAST_UPDATE_LOGIN, STMT.OBJECT_VERSION_NUMBER, STMT.PDF_LOCAL_CURR_FLAG, STMT.PDF_LOCAL_CURR_AVLBL, STMT.PDF_OTHER_CURR_FLAG, STMT.PDF_OTHER_CURR_CODE, STMT.PDF_OTHER_CURR_AVLBL, STMT.CURR_SWITCHER_DEFAULT, STMT.HIDE_PDF_ITEM_DETAILS_FLAG, STMT.HIDE_OL_DRILL_SECTIONS_FLAG, STMT.DISPLAY_JOB_FLAG, STMT.DISPLAY_POSITION_FLAG FROM CMP_TCS_STMT STMT, CMP_TCS_STMT_TL STMT_TL WHERE STMT.STMT_ID = STMT_TL.STMT_ID AND STMT_TL.LANGUAGE = USERENV('LANG') AND STMT.BUSINESS_GROUP_ID = STMT_TL.BUSINESS_GROUP_ID