CN_CONTRACT_TEXTS_ALL_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CN
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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') |