CN_PERIODS_VL
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
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 |
Query
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 |