PJS_DIMENSION_CONTEXT

Details

Schema: FUSION
Object owner: PJS
Object type: VIEW

Columns

Name
XTD_TIME_ID ATC_TIME_ID PROJECT_ID PROJECT_ELEMENT_ID RBS_VERSION_ID RBS_ELEMENT_ID BGT_C_COST_PLAN_VERSION_ID BGT_C_REV_PLAN_VERSION_ID BGT_O_COSTPLAN_VERSION_ID BGT_O_REV_PLAN_VERSION_ID FCST_C_COST_PLAN_VERSION_ID FCST_C_REV_PLAN_VERSION_ID FCST_P_COST_PLAN_VERSION_ID FCST_P_REV_PLAN_VERSION_ID CURRENCY_TYPE

Name

XTD_TIME_ID

ATC_TIME_ID

PROJECT_ID

PROJECT_ELEMENT_ID

RBS_VERSION_ID

RBS_ELEMENT_ID

BGT_C_COST_PLAN_VERSION_ID

BGT_C_REV_PLAN_VERSION_ID

BGT_O_COSTPLAN_VERSION_ID

BGT_O_REV_PLAN_VERSION_ID

FCST_C_COST_PLAN_VERSION_ID

FCST_C_REV_PLAN_VERSION_ID

FCST_P_COST_PLAN_VERSION_ID

FCST_P_REV_PLAN_VERSION_ID

CURRENCY_TYPE

Query

SQL_Statement
select /+ push_pred(time_xtd) push_pred(time_atc) push_pred(fbs) push_pred(rbs) push_pred(plan_bgt_c_cost) push_pred(plan_bgt_c_rev) push_pred(plan_bgt_o_cost) push_pred(plan_bgt_o_rev) push_pred(plan_fcst_c_cost) push_pred(plan_fcst_c_rev) push_pred(plan_fcst_p_cost) push_pred(plan_fcst_p_rev) push_pred(cur) / time_xtd.TIME_ID XTD_TIME_ID, time_atc.TIME_ID ATC_TIME_ID, fbs.PROJECT_ID PROJECT_ID, fbs.PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID, rbs.RBS_VERSION_ID RBS_VERSION_ID, rbs.RBS_ELEMENT_ID RBS_ELEMENT_ID, plan_bgt_c_cost.PLAN_VERSION_ID BGT_C_COST_PLAN_VERSION_ID, plan_bgt_c_rev.PLAN_VERSION_ID BGT_C_REV_PLAN_VERSION_ID, plan_bgt_o_cost.PLAN_VERSION_ID BGT_O_COSTPLAN_VERSION_ID, plan_bgt_o_rev.PLAN_VERSION_ID BGT_O_REV_PLAN_VERSION_ID, plan_fcst_c_cost.PLAN_VERSION_ID FCST_C_COST_PLAN_VERSION_ID, plan_fcst_c_rev.PLAN_VERSION_ID FCST_C_REV_PLAN_VERSION_ID, plan_fcst_p_cost.PLAN_VERSION_ID FCST_P_COST_PLAN_VERSION_ID, plan_fcst_p_rev.PLAN_VERSION_ID FCST_P_REV_PLAN_VERSION_ID, cur.CURRENCY_TYPE_NAME CURRENCY_TYPE from PJS_TIME_V time_xtd, PJS_TIME_V time_atc, PJS_FBS_V fbs, PJS_RBS_V rbs, PJS_PLAN_VERSION_V plan_bgt_c_cost, PJS_PLAN_VERSION_V plan_bgt_c_rev, PJS_PLAN_VERSION_V plan_bgt_o_cost, PJS_PLAN_VERSION_V plan_bgt_o_rev, PJS_PLAN_VERSION_V plan_fcst_c_cost, PJS_PLAN_VERSION_V plan_fcst_c_rev, PJS_PLAN_VERSION_V plan_fcst_p_cost, PJS_PLAN_VERSION_V plan_fcst_p_rev, PJS_CURR_TYPE_V cur

SQL_Statement

select /*+ push_pred(time_xtd)

push_pred(time_atc)

push_pred(fbs)

push_pred(rbs)

push_pred(plan_bgt_c_cost)

push_pred(plan_bgt_c_rev)

push_pred(plan_bgt_o_cost)

push_pred(plan_bgt_o_rev)

push_pred(plan_fcst_c_cost)

push_pred(plan_fcst_c_rev)

push_pred(plan_fcst_p_cost)

push_pred(plan_fcst_p_rev)

push_pred(cur) */

time_xtd.TIME_ID XTD_TIME_ID,

time_atc.TIME_ID ATC_TIME_ID,

fbs.PROJECT_ID PROJECT_ID,

fbs.PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID,

rbs.RBS_VERSION_ID RBS_VERSION_ID,

rbs.RBS_ELEMENT_ID RBS_ELEMENT_ID,

plan_bgt_c_cost.PLAN_VERSION_ID BGT_C_COST_PLAN_VERSION_ID,

plan_bgt_c_rev.PLAN_VERSION_ID BGT_C_REV_PLAN_VERSION_ID,

plan_bgt_o_cost.PLAN_VERSION_ID BGT_O_COSTPLAN_VERSION_ID,

plan_bgt_o_rev.PLAN_VERSION_ID BGT_O_REV_PLAN_VERSION_ID,

plan_fcst_c_cost.PLAN_VERSION_ID FCST_C_COST_PLAN_VERSION_ID,

plan_fcst_c_rev.PLAN_VERSION_ID FCST_C_REV_PLAN_VERSION_ID,

plan_fcst_p_cost.PLAN_VERSION_ID FCST_P_COST_PLAN_VERSION_ID,

plan_fcst_p_rev.PLAN_VERSION_ID FCST_P_REV_PLAN_VERSION_ID,

cur.CURRENCY_TYPE_NAME CURRENCY_TYPE

from

PJS_TIME_V time_xtd,

PJS_TIME_V time_atc,

PJS_FBS_V fbs,

PJS_RBS_V rbs,

PJS_PLAN_VERSION_V plan_bgt_c_cost,

PJS_PLAN_VERSION_V plan_bgt_c_rev,

PJS_PLAN_VERSION_V plan_bgt_o_cost,

PJS_PLAN_VERSION_V plan_bgt_o_rev,

PJS_PLAN_VERSION_V plan_fcst_c_cost,

PJS_PLAN_VERSION_V plan_fcst_c_rev,

PJS_PLAN_VERSION_V plan_fcst_p_cost,

PJS_PLAN_VERSION_V plan_fcst_p_rev,

PJS_CURR_TYPE_V cur