1. Tables and Views for Project Management
  2. PJS_TIME_V

PJS_TIME_V

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: VIEW

Columns

Name

TIME_ID

NAME

CALENDAR_ID

PERIOD_TYPE

START_DATE

END_DATE

Query

SQL_Statement

select /*+ push_pred(time) */

time.TIME_ID,

time.NAME,

time.CALENDAR_ID,

time.PERIOD_TYPE,

time.START_DATE,

time.END_DATE

from

(

select

CAL_PERIOD_ID TIME_ID,

NAME,

CALENDAR_ID,

'PERIOD' PERIOD_TYPE,

START_DATE,

END_DATE

from

PJS_TIME_CAL_PERIOD

union all

select

CAL_QTR_ID TIME_ID,

NAME,

CALENDAR_ID,

'QUARTER' PERIOD_TYPE,

START_DATE,

END_DATE

from

PJS_TIME_CAL_QTR

union all

select

CAL_YEAR_ID TIME_ID,

NAME,

CALENDAR_ID,

'YEAR' PERIOD_TYPE,

START_DATE,

END_DATE

from

PJS_TIME_CAL_YEAR

union all

select

CALENDAR_ID TIME_ID,

NAME,

CALENDAR_ID,

'CALENDAR' PERIOD_TYPE,

to_date(null) START_DATE,

to_date(null) END_DATE

from

PJS_TIME_CAL_NAME

) time