PJO_DIS_PD_PERIOD_ALL

Details

Schema: FUSION
Object owner: PJO
Object type: VIEW

Columns

Name
PLANNING_ELEMENT_ID PERIOD_PROFILE_ID START_PERIOD_NAME END_PERIOD_NAME START_DATE END_DATE PERIOD_NAME FROM_ANCHOR_START CURRENT_PERIOD_NAME PLAN_VERSION_ID PROJECT_ID OBJECT_ID1 TASK_ID RBS_ELEMENT_ID PLANNING_START_DATE PLANNING_END_DATE UNIT_OF_MEASURE SPREAD_CURVE_ID TXN_CURRENCY_CODE PLAN_LINE_ID PLAN_TYPE_ID MARGIN_DERIVED_FROM_CODE

Name

PLANNING_ELEMENT_ID

PERIOD_PROFILE_ID

START_PERIOD_NAME

END_PERIOD_NAME

START_DATE

END_DATE

PERIOD_NAME

FROM_ANCHOR_START

CURRENT_PERIOD_NAME

PLAN_VERSION_ID

PROJECT_ID

OBJECT_ID1

TASK_ID

RBS_ELEMENT_ID

PLANNING_START_DATE

PLANNING_END_DATE

UNIT_OF_MEASURE

SPREAD_CURVE_ID

TXN_CURRENCY_CODE

PLAN_LINE_ID

PLAN_TYPE_ID

MARGIN_DERIVED_FROM_CODE

Query

SQL_Statement
select ppe.planning_element_id, ppd.period_profile_id, ppd.start_period_name, ppd.end_period_name, decode(ppd.from_anchor_start,-99999,ppe.planning_start_date,ppd.start_date) START_DATE, decode(ppd.from_anchor_end,99999,ppe.planning_end_date,ppd.end_date) END_DATE, decode(ppd.from_anchor_start,'-99999','Preceding Period',decode(ppd.from_anchor_end,'99999','Succeeding Period',ppd.period_name)) PERIOD_NAME, ppd.from_anchor_start, ppd.current_period_name, ppe.plan_Version_id, ppe.project_id, ppe.object_id1, ppe.task_id, ppe.rbs_element_id, ppe.planning_start_date, ppe.planning_end_date, ppe.unit_of_measure, ppe.spread_curve_id, ppl.txn_currency_code, ppl.plan_line_id, ppo.plan_type_id, ppo.margin_derived_from_code from pjo_planning_elements ppe, pjo_plan_lines ppl, pjo_dis_pd_prof_gl_v ppd, pjo_planning_options ppo where ppe.planning_element_id = ppl.planning_element_id and ppd.end_date >= ppe.planning_start_date and ppd.start_date <= ppe.planning_end_date and ppe.plan_version_id = ppo.plan_version_id and ppo.time_phased_code = 'G' union all select ppe.planning_element_id, ppd.period_profile_id, ppd.start_period_name, ppd.end_period_name, decode(ppd.from_anchor_start,-99999,ppe.planning_start_date,ppd.start_date) START_DATE, decode(ppd.from_anchor_end,99999,ppe.planning_end_date,ppd.end_date) END_DATE, decode(ppd.from_anchor_start,'-99999','Preceding Period',decode(ppd.from_anchor_end,'99999','Succeeding Period',ppd.period_name)) PERIOD_NAME, ppd.from_anchor_start, ppd.current_period_name, ppe.plan_Version_id, ppe.project_id, ppe.object_id1, ppe.task_id, ppe.rbs_element_id, ppe.planning_start_date, ppe.planning_end_date, ppe.unit_of_measure, ppe.spread_curve_id, ppl.txn_currency_code, ppl.plan_line_id, ppo.plan_type_id, ppo.margin_derived_from_code from pjo_planning_elements ppe, pjo_plan_lines ppl, pjo_dis_pd_prof_pa_v ppd, pjo_planning_options ppo where ppe.planning_element_id = ppl.planning_element_id and ppd.end_date >= ppe.planning_start_date and ppd.start_date <= ppe.planning_end_date and ppe.plan_version_id = ppo.plan_version_id and ppo.time_phased_code = 'P'

SQL_Statement

select ppe.planning_element_id,

ppd.period_profile_id,

ppd.start_period_name,

ppd.end_period_name,

decode(ppd.from_anchor_start,-99999,ppe.planning_start_date,ppd.start_date) START_DATE,

decode(ppd.from_anchor_end,99999,ppe.planning_end_date,ppd.end_date) END_DATE,

decode(ppd.from_anchor_start,'-99999','Preceding Period',decode(ppd.from_anchor_end,'99999','Succeeding Period',ppd.period_name)) PERIOD_NAME,

ppd.from_anchor_start,

ppd.current_period_name,

ppe.plan_Version_id,

ppe.project_id,

ppe.object_id1,

ppe.task_id,

ppe.rbs_element_id,

ppe.planning_start_date,

ppe.planning_end_date,

ppe.unit_of_measure,

ppe.spread_curve_id,

ppl.txn_currency_code,

ppl.plan_line_id,

ppo.plan_type_id,

ppo.margin_derived_from_code

from pjo_planning_elements ppe, pjo_plan_lines ppl,

pjo_dis_pd_prof_gl_v ppd,

pjo_planning_options ppo

where ppe.planning_element_id = ppl.planning_element_id

and ppd.end_date >= ppe.planning_start_date

and ppd.start_date <= ppe.planning_end_date

and ppe.plan_version_id = ppo.plan_version_id

and ppo.time_phased_code = 'G'

union all