GMS_PROJECT_TASK_PERIOD

Details

Schema: FUSION
Object owner: GMS
Object type: VIEW

Columns

Name
AWARD_PROJECT_ID AWARD_ID AWARD_PERIOD_ID BUDGET_PERIOD START_DATE END_DATE PROJECT_ID PLAN_VERSION_ID ELEMENT_ID OLAP_SELF_NODE_FLAG PROJECTPEO_ID PROJECT_NAME PROJ_ELEMENT_ID TASK_PROJECT_ID TASK_NAME PARENT_ELEMENT_ID PARENT_PROJ_ELEMENT_ID PARENET_PROJECT_ID PARENT_TASK_NAME ELEMENT_VERSION_ID DISPLAY_SEQUENCE PARENT_ELEMENT_VERSION_ID PARENT_DISAPLY_SEQUENCE

Name

AWARD_PROJECT_ID

AWARD_ID

AWARD_PERIOD_ID

BUDGET_PERIOD

START_DATE

END_DATE

PROJECT_ID

PLAN_VERSION_ID

ELEMENT_ID

OLAP_SELF_NODE_FLAG

PROJECTPEO_ID

PROJECT_NAME

PROJ_ELEMENT_ID

TASK_PROJECT_ID

TASK_NAME

PARENT_ELEMENT_ID

PARENT_PROJ_ELEMENT_ID

PARENET_PROJECT_ID

PARENT_TASK_NAME

ELEMENT_VERSION_ID

DISPLAY_SEQUENCE

PARENT_ELEMENT_VERSION_ID

PARENT_DISAPLY_SEQUENCE

Query

SQL_Statement
select AwardProjectPEO.id as award_project_id, AwardProjectPEO.award_id, PeriodPEO.id as award_period_id, periodpeo.budget_period, periodpeo.start_date, periodpeo.end_date, AwardProjectPEO.project_id, PjoPlanningOptions.plan_version_id, task_structure.element_id, task_structure.olap_self_node_flag, projectpeo.project_id as projectpeo_id, ProjectPEO.name as project_name, task_info.proj_element_id, task_info.project_id as task_project_id, task_info.name as task_name, task_structure.parent_element_id, parent_info.proj_element_id as parent_proj_element_id, parent_info.project_id as parenet_project_id, nvl(parent_info.name, task_info.name) as parent_task_name, task_version_info.element_version_id, task_version_info.display_sequence, parent_version_info.element_version_id as parent_element_version_id, parent_version_info.display_sequence as parent_disaply_sequence from gms_award_projects AwardProjectPEO, gms_award_budget_periods PeriodPEO, pjs_fbs_d task_structure, pjf_proj_elements_vl task_info, PJF_PROJ_ELEMENT_VERSION task_version_info, pjf_proj_elements_vl parent_info, PJF_PROJ_ELEMENT_VERSION parent_version_info, PJO_PLAN_VERSIONS_VL PjoPlanVersionsVl, PJO_PLANNING_OPTIONS PjoPlanningOptions, PJF_PROJECTS_ALL_VL ProjectPEO where AwardProjectPEO.award_id = PeriodPEO.award_id and AwardProjectPEO.project_id = task_structure.project_id and task_structure.leaf_node_flag = 'Y' and task_structure.element_id = task_info.proj_element_id and task_structure.parent_element_id = parent_info.proj_element_id(+) and task_structure.element_id = task_version_info.proj_element_id and task_structure.project_id = task_version_info.project_id and task_structure.parent_element_id = parent_version_info.proj_element_id(+) and task_structure.project_id = parent_version_info.project_id(+) and AwardProjectPEO.project_id = ProjectPEO.project_id and AwardProjectPEO.PROJECT_ID = PjoPlanVersionsVl.PROJECT_ID and PjoPlanVersionsVl.PLAN_VERSION_ID = PjoPlanningOptions.PLAN_VERSION_ID and PjoPlanVersionsVl.PLAN_STATUS_CODE = 'B' AND PjoPlanVersionsVl.CURRENT_PLAN_STATUS_FLAG = 'Y' and PjoPlanningOptions.plan_type_code = 'FINANCIAL_PLAN' and PjoPlanVersionsVl.plan_class_code = 'BUDGET' and PjoPlanVersionsVl.plan_version_id = PjoPlanningOptions.plan_version_id and PjoPlanningOptions.approved_cost_plan_type_flag = 'Y' and PjoPlanningOptions.APPROVED_REV_PLAN_TYPE_FLAG = 'Y' order by ProjectPEO.name, parent_version_info.display_sequence, task_version_info.display_sequence, periodpeo.start_date

SQL_Statement

select AwardProjectPEO.id as award_project_id,

AwardProjectPEO.award_id,

PeriodPEO.id as award_period_id,

periodpeo.budget_period,

periodpeo.start_date,

periodpeo.end_date,

AwardProjectPEO.project_id,

PjoPlanningOptions.plan_version_id,

task_structure.element_id,

task_structure.olap_self_node_flag,

projectpeo.project_id as projectpeo_id,

ProjectPEO.name as project_name,

task_info.proj_element_id,

task_info.project_id as task_project_id,

task_info.name as task_name,

task_structure.parent_element_id,

parent_info.proj_element_id as parent_proj_element_id,

parent_info.project_id as parenet_project_id,

nvl(parent_info.name, task_info.name) as parent_task_name,

task_version_info.element_version_id,

task_version_info.display_sequence,

parent_version_info.element_version_id as parent_element_version_id,

parent_version_info.display_sequence as parent_disaply_sequence

from gms_award_projects AwardProjectPEO,

gms_award_budget_periods PeriodPEO,

pjs_fbs_d task_structure,

pjf_proj_elements_vl task_info,

PJF_PROJ_ELEMENT_VERSION task_version_info,

pjf_proj_elements_vl parent_info,

PJF_PROJ_ELEMENT_VERSION parent_version_info,

PJO_PLAN_VERSIONS_VL PjoPlanVersionsVl,

PJO_PLANNING_OPTIONS PjoPlanningOptions,

PJF_PROJECTS_ALL_VL ProjectPEO

where AwardProjectPEO.award_id = PeriodPEO.award_id

and AwardProjectPEO.project_id = task_structure.project_id

and task_structure.leaf_node_flag = 'Y'

and task_structure.element_id = task_info.proj_element_id

and task_structure.parent_element_id = parent_info.proj_element_id(+)

and task_structure.element_id = task_version_info.proj_element_id

and task_structure.project_id = task_version_info.project_id

and task_structure.parent_element_id = parent_version_info.proj_element_id(+)

and task_structure.project_id = parent_version_info.project_id(+)

and AwardProjectPEO.project_id = ProjectPEO.project_id

and AwardProjectPEO.PROJECT_ID = PjoPlanVersionsVl.PROJECT_ID

and PjoPlanVersionsVl.PLAN_VERSION_ID = PjoPlanningOptions.PLAN_VERSION_ID

and PjoPlanVersionsVl.PLAN_STATUS_CODE = 'B'

AND PjoPlanVersionsVl.CURRENT_PLAN_STATUS_FLAG = 'Y'

and PjoPlanningOptions.plan_type_code = 'FINANCIAL_PLAN'

and PjoPlanVersionsVl.plan_class_code = 'BUDGET'

and PjoPlanVersionsVl.plan_version_id = PjoPlanningOptions.plan_version_id

and PjoPlanningOptions.approved_cost_plan_type_flag = 'Y'

and PjoPlanningOptions.APPROVED_REV_PLAN_TYPE_FLAG = 'Y'

order by ProjectPEO.name, parent_version_info.display_sequence, task_version_info.display_sequence,

periodpeo.start_date