PJS_CUSTOM_ATC_V
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: VIEW
Columns
Name |
---|
PROJECT_ID PROJECT_ELEMENT_ID TIME_ID RBS_VERSION_ID RBS_ELEMENT_ID CURRENCY_TYPE CURRENCY_CODE CALENDAR_TYPE ATC_CUSTOM1 ATC_CUSTOM2 ATC_CUSTOM3 ATC_CUSTOM4 ATC_CUSTOM5 ATC_CUSTOM6 ATC_CUSTOM7 ATC_CUSTOM8 ATC_CUSTOM9 ATC_CUSTOM10 ATC_CUSTOM11 ATC_CUSTOM12 ATC_CUSTOM13 ATC_CUSTOM14 ATC_CUSTOM15 |
Query
SQL_Statement |
---|
select /*+ ordered push_pred(per) push_pred(fct) */ fct.PROJECT_ID, fct.PROJECT_ELEMENT_ID, per.CALENDAR_ID TIME_ID, fct.RBS_VERSION_ID, fct.RBS_ELEMENT_ID, fct.CURRENCY_TYPE, fct.CURRENCY_CODE, fct.CALENDAR_TYPE, fct.CUSTOM1 ATC_CUSTOM1, fct.CUSTOM2 ATC_CUSTOM2, fct.CUSTOM3 ATC_CUSTOM3, fct.CUSTOM4 ATC_CUSTOM4, fct.CUSTOM5 ATC_CUSTOM5, fct.CUSTOM6 ATC_CUSTOM6, fct.CUSTOM7 ATC_CUSTOM7, fct.CUSTOM8 ATC_CUSTOM8, fct.CUSTOM9 ATC_CUSTOM9, fct.CUSTOM10 ATC_CUSTOM10, fct.CUSTOM11 ATC_CUSTOM11, fct.CUSTOM12 ATC_CUSTOM12, fct.CUSTOM13 ATC_CUSTOM13, fct.CUSTOM14 ATC_CUSTOM14, fct.CUSTOM15 ATC_CUSTOM15 from PJS_TIME_CAL_PERIOD per, PJS_CUSTOM_F fct where per.CAL_PERIOD_ID = fct.TIME_ID |