ACE_PLAN_PERIOD_UNITS_VL
Details
-
Schema: FUSION
-
Object owner: ACE
-
Object type: VIEW
Columns
Name |
---|
UNIT_ID OBJECT_VERSION_NUMBER PP_UNITS_CONFIG_ID START_DATE END_DATE DURATION LABEL CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT ACE_PLAN_PERIOD_UNITS_B.UNIT_ID UNIT_ID, ACE_PLAN_PERIOD_UNITS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACE_PLAN_PERIOD_UNITS_B.PP_UNITS_CONFIG_ID PP_UNITS_CONFIG_ID, ACE_PLAN_PERIOD_UNITS_B.START_DATE START_DATE, ACE_PLAN_PERIOD_UNITS_B.END_DATE END_DATE, ACE_PLAN_PERIOD_UNITS_B.DURATION DURATION, ACE_PLAN_PERIOD_UNITS_TL.LABEL LABEL, ACE_PLAN_PERIOD_UNITS_B.CREATED_BY CREATED_BY, ACE_PLAN_PERIOD_UNITS_B.CREATION_DATE CREATION_DATE, ACE_PLAN_PERIOD_UNITS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACE_PLAN_PERIOD_UNITS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACE_PLAN_PERIOD_UNITS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ACE_PLAN_PERIOD_UNITS_B, ACE_PLAN_PERIOD_UNITS_TL WHERE ACE_PLAN_PERIOD_UNITS_B.UNIT_ID = ACE_PLAN_PERIOD_UNITS_TL.UNIT_ID AND ACE_PLAN_PERIOD_UNITS_TL.LANGUAGE = USERENV('LANG') |