CN_PERIODS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CN
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PERIOD_ID PERIOD_NAME CALENDAR_ID PERIOD_YEAR PERIOD_NUMBER QUARTER_NUMBER START_DATE END_DATE PERIOD_SEQUENCE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER |
問合せ
| SQL_Statement |
|---|
|
SELECT B.period_id, t.period_name, b.calendar_id,b.period_year, b.period_number,b.quarter_number, b.start_date,b.end_date, b.Period_sequence, B.LAST_UPDATE_DATE,B.LAST_UPDATED_BY , B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATE_LOGIN, b.object_Version_number FROM CN_periods_B B, CN_periods_TL T WHERE B.period_id= T.period_id AND T.LANGUAGE = USERENV('LANG') AND B.calendar_id = T.calendar_id |