PER_CALENDAR_EVENTS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
CALENDAR_EVENT_ID BUSINESS_GROUP_ID SHORT_CODE CATEGORY START_DATE_TIME END_DATE_TIME COVERAGE_TYPE TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION HALF_DAY_FOR_ELAPSED

Query

SQL_Statement

SELECT PCE.CALENDAR_EVENT_ID CALENDAR_EVENT_ID, PCE.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PCE.SHORT_CODE SHORT_CODE, PCE.CATEGORY CATEGORY, PCE.START_DATE_TIME START_DATE_TIME, PCE.END_DATE_TIME END_DATE_TIME, PCE.COVERAGE_TYPE COVERAGE_TYPE, PCE.TREE_STRUCTURE_CODE TREE_STRUCTURE_CODE, PCE.TREE_CODE TREE_CODE, PCE.TREE_VERSION_ID TREE_VERSION_ID, PCE.CREATED_BY CREATED_BY, PCE.CREATION_DATE CREATION_DATE, PCE.LAST_UPDATED_BY LAST_UPDATED_BY, PCE.LAST_UPDATE_DATE LAST_UPDATE_DATE, PCE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PCE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PCETL.NAME NAME, PCETL.DESCRIPTION DESCRIPTION, PCE.HALF_DAY_FOR_ELAPSED HALF_DAY_FOR_ELAPSED FROM PER_CALENDAR_EVENTS PCE, PER_CALENDAR_EVENTS_TL PCETL WHERE PCETL.CALENDAR_EVENT_ID = PCE.CALENDAR_EVENT_ID AND PCETL.LANGUAGE = USERENV('LANG')