PJO_DIS_PD_PERIOD

Details

Schema: FUSION
Object owner: PJO
Object type: VIEW

Columns

Name
PLANNING_ELEMENT_ID PROJECT_ID OBJECT_ID1 TASK_ID RBS_ELEMENT_ID PLAN_VERSION_ID PLANNING_START_DATE PLANNING_END_DATE UNIT_OF_MEASURE SPREAD_CURVE_ID START_DATE CURRENT_REPORTING_PERIOD END_DATE FROM_ANCHOR_POSITION PERIOD_PROMPT START_PERIOD_NAME END_PERIOD_NAME PERIOD_PROFILE_ID ORG_ID SESSION_ID TXN_CURRENCY_CODE PLAN_LINE_ID

Name

PLANNING_ELEMENT_ID

PROJECT_ID

OBJECT_ID1

TASK_ID

RBS_ELEMENT_ID

PLAN_VERSION_ID

PLANNING_START_DATE

PLANNING_END_DATE

UNIT_OF_MEASURE

SPREAD_CURVE_ID

START_DATE

CURRENT_REPORTING_PERIOD

END_DATE

FROM_ANCHOR_POSITION

PERIOD_PROMPT

START_PERIOD_NAME

END_PERIOD_NAME

PERIOD_PROFILE_ID

ORG_ID

SESSION_ID

TXN_CURRENCY_CODE

PLAN_LINE_ID

Query

SQL_Statement
select ppe.planning_element_id, ppe.project_id, ppe.object_id1, ppe.task_id, ppe.rbs_element_id, ppe.plan_version_id, ppe.planning_start_date, ppe.planning_end_date, ppe.unit_of_measure, ppe.spread_curve_id, decode(ppd.period_prompt, 'Preceding Period', DECODE(SIGN(ppd.start_date - ppe.planning_start_date), -1, pjo_edit_plan_setup.get_period_start_date(ppe.planning_start_date,ppj.org_id,ppo.time_phased_code), ppd.start_date), 'Succeeding Period', DECODE(SIGN(ppd.start_date - ppe.planning_start_date), -1, pjo_edit_plan_setup.get_period_start_date(ppe.planning_start_date,ppj.org_id,ppo.time_phased_code), ppd.start_date), ppd.start_date) START_DATE, ppd.current_reporting_period, decode(ppd.period_prompt, 'Succeeding Period', DECODE(SIGN(ppd.end_date - ppe.planning_end_date), -1, ppd.end_date, pjo_edit_plan_setup.get_period_end_date(ppe.planning_end_date,ppj.org_id,ppo.time_phased_code)), 'Preceding Period', DECODE(SIGN(ppd.end_date - ppe.planning_end_date), -1, ppd.end_date, pjo_edit_plan_setup.get_period_end_date(ppe.planning_end_date,ppj.org_id,ppo.time_phased_code)), ppd.end_date) END_DATE, ppd.from_anchor_position, ppd.period_prompt, ppd.start_period_name, ppd.end_period_name, ppd.period_profile_id, ppd.org_id, ppd.session_id, ppl.txn_currency_code, ppl.plan_line_id from pjo_planning_elements ppe, pjo_plan_lines ppl, PJO_DIS_SESSION_PERIODS ppd, pjo_planning_options ppo, pjf_projects_all_b ppj where ppe.planning_start_date <= ppd.end_date and ppe.planning_end_date >= ppd.start_date and ppe.planning_element_id = ppl.planning_element_id and ppe.plan_version_id = ppo.plan_version_id and ppo.period_profile_id = ppd.period_profile_id and ppd.current_reporting_period = ppo.current_planning_period and ppe.project_id = ppj.project_id and ppj.org_id = ppd.org_id and ppo.time_phased_code <> 'A' union select ppe.planning_element_id, ppe.project_id, ppe.object_id1, ppe.task_id, ppe.rbs_element_id, ppe.plan_version_id, ppe.planning_start_date, ppe.planning_end_date, ppe.unit_of_measure, ppe.spread_curve_id, ppd.start_date start_date, ppd.current_reporting_period, ppd.end_date end_date, ppd.from_anchor_position, ppd.period_prompt, ppd.start_period_name, ppd.end_period_name, ppd.period_profile_id, ppd.org_id, ppd.session_id, ppl.txn_currency_code, ppl.plan_line_id from pjo_planning_elements ppe, pjo_plan_lines ppl, pjo_dis_session_periods ppd, pjo_planning_options ppo, pjf_projects_all_b ppj, pjo_plan_versions_b ppv, GMS_AWD_STR_END_PR_DATE_V gms where gms.bp_start_date <= ppd.end_date and gms.bp_end_date >= ppd.start_date and ppe.planning_element_id = ppl.planning_element_id and ppe.plan_version_id = ppo.plan_version_id and ppe.project_id = ppj.project_id and ppj.org_id = ppd.org_id and ppo.time_phased_code = 'A' and ppv.plan_version_id = ppo.plan_version_id and ppv.object_id1 = ppd.award_id and ppv.object_id1 = gms.id

SQL_Statement

select ppe.planning_element_id,

ppe.project_id,

ppe.object_id1,

ppe.task_id,

ppe.rbs_element_id,

ppe.plan_version_id,

ppe.planning_start_date,

ppe.planning_end_date,

ppe.unit_of_measure,

ppe.spread_curve_id,

decode(ppd.period_prompt,

'Preceding Period', DECODE(SIGN(ppd.start_date - ppe.planning_start_date), -1, pjo_edit_plan_setup.get_period_start_date(ppe.planning_start_date,ppj.org_id,ppo.time_phased_code), ppd.start_date),

'Succeeding Period', DECODE(SIGN(ppd.start_date - ppe.planning_start_date), -1, pjo_edit_plan_setup.get_period_start_date(ppe.planning_start_date,ppj.org_id,ppo.time_phased_code), ppd.start_date), ppd.start_date) START_DATE,

ppd.current_reporting_period,

decode(ppd.period_prompt, 'Succeeding Period', DECODE(SIGN(ppd.end_date - ppe.planning_end_date), -1,

ppd.end_date, pjo_edit_plan_setup.get_period_end_date(ppe.planning_end_date,ppj.org_id,ppo.time_phased_code)),

'Preceding Period', DECODE(SIGN(ppd.end_date - ppe.planning_end_date), -1,

ppd.end_date, pjo_edit_plan_setup.get_period_end_date(ppe.planning_end_date,ppj.org_id,ppo.time_phased_code)), ppd.end_date) END_DATE,

ppd.from_anchor_position,

ppd.period_prompt,

ppd.start_period_name,

ppd.end_period_name,

ppd.period_profile_id,

ppd.org_id,

ppd.session_id,

ppl.txn_currency_code,

ppl.plan_line_id

from pjo_planning_elements ppe, pjo_plan_lines ppl,

PJO_DIS_SESSION_PERIODS ppd, pjo_planning_options ppo, pjf_projects_all_b ppj

where ppe.planning_start_date <= ppd.end_date

and ppe.planning_end_date >= ppd.start_date

and ppe.planning_element_id = ppl.planning_element_id

and ppe.plan_version_id = ppo.plan_version_id

and ppo.period_profile_id = ppd.period_profile_id

and ppd.current_reporting_period = ppo.current_planning_period

and ppe.project_id = ppj.project_id

and ppj.org_id = ppd.org_id

and ppo.time_phased_code <> 'A'

union

select ppe.planning_element_id,

ppe.project_id,

ppe.object_id1,

ppe.task_id,

ppe.rbs_element_id,

ppe.plan_version_id,

ppe.planning_start_date,

ppe.planning_end_date,

ppe.unit_of_measure,

ppe.spread_curve_id,

ppd.start_date start_date,

ppd.current_reporting_period,

ppd.end_date end_date,

ppd.from_anchor_position,

ppd.period_prompt,

ppd.start_period_name,

ppd.end_period_name,

ppd.period_profile_id,

ppd.org_id,

ppd.session_id,

ppl.txn_currency_code,

ppl.plan_line_id

from pjo_planning_elements ppe,

pjo_plan_lines ppl,

pjo_dis_session_periods ppd,

pjo_planning_options ppo,

pjf_projects_all_b ppj,

pjo_plan_versions_b ppv,

GMS_AWD_STR_END_PR_DATE_V gms

where gms.bp_start_date <= ppd.end_date

and gms.bp_end_date >= ppd.start_date

and ppe.planning_element_id = ppl.planning_element_id

and ppe.plan_version_id = ppo.plan_version_id

and ppe.project_id = ppj.project_id

and ppj.org_id = ppd.org_id

and ppo.time_phased_code = 'A'

and ppv.plan_version_id = ppo.plan_version_id

and ppv.object_id1 = ppd.award_id

and ppv.object_id1 = gms.id