CMP_TCS_STMT_PAGE_DEF_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

STMT_PAGE_DEF_ID STMT_PERD_ID PERD_RUN_ID CAT_ID CATEGORY_TITLE CAT_TYPE_CD CONTRIBUTIONS_TYPE_CD NNMNTRY_UOM DESC_TXT HIDE_DESC_TXT_FLAG DESC_TXT_ORDR_NUM SMRY_TITLE ADDL_INFO_TITLE ADDL_INFO HIDE_ADDL_INFO_FLAG CHART_RN_TITLE CHART1_TYPE_CD CHART1_TITLE CHART2_TYPE_CD CHART2_TITLE HIDE_CHART_RN_FLAG CHART_RN_ORDR_NUM HIDE_TABLE_FLAG TABLE_ORDR_NUM DISPLAY_NAME_COLUMN_LABEL DISPLAY_NAME_ORDR_NUM DESC_COLUMN_LABEL DESC_COLUMN_HIDE_FLAG DESC_COLUMN_ORDR_NUM DATE_COLUMN_LABEL DATE_COLUMN_ORDR_NUM JOB_COLUMN_LABEL JOB_COLUMN_ORDR_NUM COLUMN1_DISPLAY_NAME COLUMN1_COLUMN_TYPE_CD COLUMN1_DATA_TYPE_CD COLUMN1_CONTRBR_TYPE_CD COLUMN1_HIDE_FLAG COLUMN1_ORDR_NUM COLUMN2_DISPLAY_NAME COLUMN2_COLUMN_TYPE_CD COLUMN2_DATA_TYPE_CD COLUMN2_CONTRBR_TYPE_CD COLUMN2_HIDE_FLAG COLUMN2_ORDR_NUM COLUMN3_DISPLAY_NAME COLUMN3_COLUMN_TYPE_CD COLUMN3_DATA_TYPE_CD COLUMN3_CONTRBR_TYPE_CD COLUMN3_HIDE_FLAG COLUMN3_ORDR_NUM COLUMN4_DISPLAY_NAME COLUMN4_COLUMN_TYPE_CD COLUMN4_DATA_TYPE_CD COLUMN4_CONTRBR_TYPE_CD COLUMN4_HIDE_FLAG COLUMN4_ORDR_NUM COLUMN5_DISPLAY_NAME COLUMN5_COLUMN_TYPE_CD COLUMN5_DATA_TYPE_CD COLUMN5_CONTRBR_TYPE_CD COLUMN5_HIDE_FLAG COLUMN5_ORDR_NUM COLUMN1_IN_CHART1_FLAG COLUMN1_IN_CHART2_FLAG COLUMN2_IN_CHART1_FLAG COLUMN2_IN_CHART2_FLAG COLUMN3_IN_CHART1_FLAG COLUMN3_IN_CHART2_FLAG COLUMN4_IN_CHART1_FLAG COLUMN4_IN_CHART2_FLAG COLUMN5_IN_CHART1_FLAG COLUMN5_IN_CHART2_FLAG LEVEL_OF_DETAIL SUBCAT_IN_ROW_FLAG HIDE_SMRY_FLAG MNTRY_SECT_ORDR_NUM NNMNTRY_SECT_ORDR_NUM BUSINESS_GROUP_ID BUSINESS_GROUP_ID2 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PDF_LOCAL_CURR_FLAG PDF_LOCAL_CURR_AVLBL PDF_OTHER_CURR_FLAG PDF_OTHER_CURR_CODE PDF_OTHER_CURR_AVLBL LANGUAGE HIDE_PDF_ITEM_DETAILS_FLAG VALID_CHART1_FLAG VALID_CHART2_FLAG DESC_STATIC_ITEM_FLAG

Query

SQL_Statement

SELECT PAGE.STMT_PAGE_DEF_ID, PAGE.STMT_PERD_ID, PAGE.PERD_RUN_ID, PAGE.CAT_ID, PAGE_TL.CATEGORY_TITLE, PAGE.CAT_TYPE_CD, PAGE.CONTRIBUTIONS_TYPE_CD, PAGE.NNMNTRY_UOM, PAGE_TL.DESC_TXT, PAGE.HIDE_DESC_TXT_FLAG, PAGE.DESC_TXT_ORDR_NUM, PAGE_TL.SMRY_TITLE, PAGE_TL.ADDL_INFO_TITLE, PAGE_TL.ADDL_INFO, PAGE.HIDE_ADDL_INFO_FLAG, PAGE_TL.CHART_RN_TITLE, PAGE.CHART1_TYPE_CD, PAGE_TL.CHART1_TITLE, PAGE.CHART2_TYPE_CD, PAGE_TL.CHART2_TITLE, PAGE.HIDE_CHART_RN_FLAG, PAGE.CHART_RN_ORDR_NUM, PAGE.HIDE_TABLE_FLAG, PAGE.TABLE_ORDR_NUM, PAGE_TL.DISPLAY_NAME_COLUMN_LABEL, PAGE.DISPLAY_NAME_ORDR_NUM, PAGE_TL.DESC_COLUMN_LABEL, PAGE.DESC_COLUMN_HIDE_FLAG, PAGE.DESC_COLUMN_ORDR_NUM, PAGE_TL.DATE_COLUMN_LABEL, PAGE.DATE_COLUMN_ORDR_NUM, PAGE_TL.JOB_COLUMN_LABEL, PAGE.JOB_COLUMN_ORDR_NUM, PAGE_TL.COLUMN1_DISPLAY_NAME, PAGE.COLUMN1_COLUMN_TYPE_CD, PAGE.COLUMN1_DATA_TYPE_CD, PAGE.COLUMN1_CONTRBR_TYPE_CD, PAGE.COLUMN1_HIDE_FLAG, PAGE.COLUMN1_ORDR_NUM, PAGE_TL.COLUMN2_DISPLAY_NAME, PAGE.COLUMN2_COLUMN_TYPE_CD, PAGE.COLUMN2_DATA_TYPE_CD, PAGE.COLUMN2_CONTRBR_TYPE_CD, PAGE.COLUMN2_HIDE_FLAG, PAGE.COLUMN2_ORDR_NUM, PAGE_TL.COLUMN3_DISPLAY_NAME, PAGE.COLUMN3_COLUMN_TYPE_CD, PAGE.COLUMN3_DATA_TYPE_CD, PAGE.COLUMN3_CONTRBR_TYPE_CD, PAGE.COLUMN3_HIDE_FLAG, PAGE.COLUMN3_ORDR_NUM, PAGE_TL.COLUMN4_DISPLAY_NAME, PAGE.COLUMN4_COLUMN_TYPE_CD, PAGE.COLUMN4_DATA_TYPE_CD, PAGE.COLUMN4_CONTRBR_TYPE_CD, PAGE.COLUMN4_HIDE_FLAG, PAGE.COLUMN4_ORDR_NUM, PAGE_TL.COLUMN5_DISPLAY_NAME, PAGE.COLUMN5_COLUMN_TYPE_CD, PAGE.COLUMN5_DATA_TYPE_CD, PAGE.COLUMN5_CONTRBR_TYPE_CD, PAGE.COLUMN5_HIDE_FLAG, PAGE.COLUMN5_ORDR_NUM, PAGE.COLUMN1_IN_CHART1_FLAG, PAGE.COLUMN1_IN_CHART2_FLAG, PAGE.COLUMN2_IN_CHART1_FLAG, PAGE.COLUMN2_IN_CHART2_FLAG, PAGE.COLUMN3_IN_CHART1_FLAG, PAGE.COLUMN3_IN_CHART2_FLAG, PAGE.COLUMN4_IN_CHART1_FLAG, PAGE.COLUMN4_IN_CHART2_FLAG, PAGE.COLUMN5_IN_CHART1_FLAG, PAGE.COLUMN5_IN_CHART2_FLAG, PAGE.LEVEL_OF_DETAIL, PAGE.SUBCAT_IN_ROW_FLAG, PAGE.HIDE_SMRY_FLAG, PAGE.MNTRY_SECT_ORDR_NUM, PAGE.NNMNTRY_SECT_ORDR_NUM, PAGE.BUSINESS_GROUP_ID, PAGE_TL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID2, PAGE.REQUEST_ID, PAGE.JOB_DEFINITION_NAME, PAGE.JOB_DEFINITION_PACKAGE, PAGE.CREATED_BY, PAGE.CREATION_DATE, PAGE.LAST_UPDATE_DATE, PAGE.LAST_UPDATED_BY, PAGE.LAST_UPDATE_LOGIN, PDF_LOCAL_CURR_FLAG, PDF_LOCAL_CURR_AVLBL, PDF_OTHER_CURR_FLAG, PDF_OTHER_CURR_CODE, PDF_OTHER_CURR_AVLBL, PAGE_TL.LANGUAGE , PAGE.HIDE_PDF_ITEM_DETAILS_FLAG, PAGE.VALID_CHART1_FLAG, PAGE.VALID_CHART2_FLAG , PAGE.DESC_STATIC_ITEM_FLAG FROM CMP_TCS_STMT_PAGE_DEF PAGE, CMP_TCS_STMT_PAGE_DEF_TL PAGE_TL WHERE PAGE.STMT_PAGE_DEF_ID = PAGE_TL.STMT_PAGE_DEF_ID AND PAGE.BUSINESS_GROUP_ID = PAGE_TL.BUSINESS_GROUP_ID