1. Tables and Views for Project Management
  2. PJO_TASK_ASSIGNMENTS_V

PJO_TASK_ASSIGNMENTS_V

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: VIEW

Columns

Name

PROJECT_ID

TASK_ID

PLAN_VERSION_ID

STRUCTURE_VERSION_ID

ALIAS

PLAN_STATUS_CODE

CURRENT_PLAN_STATUS_FLAG

PLANNING_ELEMENT_ID

RBS_VERSION_ID

Query

SQL_Statement

select

PjoPlanningElements.project_id

, PjoPlanningElements.task_id

, PjoPlanVersions.plan_version_id

, PjoPlanVersions.structure_version_id

, PjfRbsElements.ALIAS

, PjoPlanVersions.plan_status_code

, PjoPlanVersions.current_plan_status_flag

, PjoPlanningElements.planning_element_id

, PjfRbsElements.rbs_version_id

FROM PJF_RBS_ELEMENTS_VL PjfRbsElements

, PJO_PLANNING_ELEMENTS PjoPlanningElements

, pjo_planning_options PjoPlanningOptions

, pjo_plan_versions_b PjoPlanVersions

where

PjoPlanningOptions.project_id = PjoPlanVersions.project_id

and PjoPlanningOptions.plan_version_id = PjoPlanVersions.plan_version_id

and PjoPlanningOptions.plan_type_code = 'PROJECT_PLAN'

AND PjoPlanningElements.PROJECT_ID = PjoPlanningOptions.PROJECT_ID

AND PjoPlanningElements.PLAN_VERSION_ID = PjoPlanningOptions.plan_version_id

and PjoPlanningOptions.rbs_version_id = PjfRbsElements.rbs_version_id

AND PjoPlanningElements.RBS_ELEMENT_ID = PjfRbsElements.RBS_ELEMENT_ID

and PjoPlanVersions.plan_status_code = 'W'

and PjoPlanVersions.current_plan_status_flag = 'Y'