CMP_TCS_STMT_RATING_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name
STMT_RATING_ID STMT_ID STMT_PERD_ID PERD_RUN_ID RATING_CODE RATING ORDER_NUM DESCRIPTION LANGUAGE SOURCE_LANG REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT RATING.STMT_RATING_ID , RATING.STMT_ID , RATING.STMT_PERD_ID , RATING.PERD_RUN_ID , RATING.RATING_CODE , RATING_TL.RATING , RATING.ORDER_NUM , RATING_TL.DESCRIPTION , RATING_TL.LANGUAGE , RATING_TL.SOURCE_LANG , RATING.REQUEST_ID , RATING.JOB_DEFINITION_NAME , RATING.JOB_DEFINITION_PACKAGE , RATING.CREATED_BY , RATING.CREATION_DATE , RATING.LAST_UPDATE_DATE , RATING.LAST_UPDATED_BY , RATING.LAST_UPDATE_LOGIN FROM CMP_TCS_STMT_RATING_B RATING, CMP_TCS_STMT_RATING_TL RATING_TL WHERE RATING.STMT_RATING_ID = RATING_TL.STMT_RATING_ID