CN_CONTRACT_TEXTS_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
CONTRACT_TEXT_ID OBJECT_VERSION_NUMBER ORG_ID CONTRACT_TEXT_NAME START_DATE END_DATE CONTRACT_TEXT PAY_COMPONENT_DESC OPTIONAL_TEXT ADDITIONAL_TEXT1 ADDITIONAL_TEXT2 INDIVIDUALIZE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT CCTB.CONTRACT_TEXT_ID CONTRACT_TEXT_ID, CCTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CCTB.ORG_ID ORG_ID, CCTT.CONTRACT_TEXT_NAME CONTRACT_TEXT_NAME, CCTB.START_DATE START_DATE, CCTB.END_DATE END_DATE, CCTB.CONTRACT_TEXT CONTRACT_TEXT, CCTB.PAY_COMPONENT_DESC PAY_COMPONENT_DESC, CCTB.OPTIONAL_TEXT OPTIONAL_TEXT, CCTB.ADDITIONAL_TEXT1 ADDITIONAL_TEXT1, CCTB.ADDITIONAL_TEXT2 ADDITIONAL_TEXT2, CCTB.INDIVIDUALIZE_FLAG, CCTB.CREATED_BY CREATED_BY, CCTB.CREATION_DATE CREATION_DATE, CCTB.LAST_UPDATED_BY LAST_UPDATED_BY, CCTB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CCTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM CN_CONTRACT_TEXTS_ALL_B CCTB, CN_CONTRACT_TEXTS_ALL_TL CCTT WHERE CCTB.CONTRACT_TEXT_ID = CCTT.CONTRACT_TEXT_ID AND CCTT.LANGUAGE = USERENV('LANG')