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