ACE_PLANNING_PERIOD_VL

Details

• Schema: FUSION

• Object owner: ACE

• Object type: VIEW

Columns

Name
PLANNING_PERIOD_ID OBJECT_VERSION_NUMBER PLANNING_PERIOD_NUMBER PERIOD_STATUS PERIOD_START_DATE PERIOD_END_DATE START_PLAN_PERIOD_UNIT_ID END_PLAN_PERIOD_UNIT_ID NAME DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ACE_PLANNING_PERIOD_B.PLANNING_PERIOD_ID PLANNING_PERIOD_ID, ACE_PLANNING_PERIOD_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACE_PLANNING_PERIOD_B.PLANNING_PERIOD_NUMBER PLANNING_PERIOD_NUMBER, ACE_PLANNING_PERIOD_B.PERIOD_STATUS PERIOD_STATUS, ACE_PLANNING_PERIOD_B.PERIOD_START_DATE PERIOD_START_DATE, ACE_PLANNING_PERIOD_B.PERIOD_END_DATE PERIOD_END_DATE, ACE_PLANNING_PERIOD_B.START_PLAN_PERIOD_UNIT_ID START_PLAN_PERIOD_UNIT_ID, ACE_PLANNING_PERIOD_B.END_PLAN_PERIOD_UNIT_ID END_PLAN_PERIOD_UNIT_ID, ACE_PLANNING_PERIOD_TL.NAME NAME, ACE_PLANNING_PERIOD_TL.DESCRIPTION DESCRIPTION, ACE_PLANNING_PERIOD_B.CREATED_BY CREATED_BY, ACE_PLANNING_PERIOD_B.CREATION_DATE CREATION_DATE, ACE_PLANNING_PERIOD_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACE_PLANNING_PERIOD_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACE_PLANNING_PERIOD_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ACE_PLANNING_PERIOD_B, ACE_PLANNING_PERIOD_TL WHERE ACE_PLANNING_PERIOD_B.PLANNING_PERIOD_ID = ACE_PLANNING_PERIOD_TL.PLANNING_PERIOD_ID AND ACE_PLANNING_PERIOD_TL.LANGUAGE = USERENV('LANG')