1. Tables and Views for Project Management
  2. GMS_APRD_COST_PLAN_VERSIONS_V

GMS_APRD_COST_PLAN_VERSIONS_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

VERSION_NAME

VERSION_NUMBER

PROJECT_ID

PLAN_VERSION_ID

PLAN_TYPE_ID

PLAN_STATUS_CODE

PLAN_CLASS_CODE

PLANNED_FOR_CODE

MULTI_ERROR_FLAG

CURRENT_PLAN_STATUS_FLAG

OBJECT_ID1

OBJECT_TYPE_CODE

APPROVED_COST_PLAN_TYPE_FLAG

PLANNING_OPTION_ID

TIME_PHASED_CODE

PLAN_LEVEL_CODE

LOCKED_BY_PERSON_ID

NAME1

RBS_HEADER_ID

NAME2

RBS_HEADER_ID1

CENTRALLY_CONTROL_FLAG

SOURCE_RBS_HEADER_ID

NAME

Query

SQL_Statement

SELECT PjoPlanVersionsVl.VERSION_NAME,

PjoPlanVersionsVl.VERSION_NUMBER,

PjoPlanVersionsVl.PROJECT_ID,

PjoPlanVersionsVl.PLAN_VERSION_ID,

PjoPlanVersionsVl.PLAN_TYPE_ID,

PjoPlanVersionsVl.PLAN_STATUS_CODE,

PjoPlanVersionsVl.PLAN_CLASS_CODE,

PjoPlanVersionsVl.PLANNED_FOR_CODE,

PjoPlanVersionsVl.MULTI_ERROR_FLAG,

PjoPlanVersionsVl.CURRENT_PLAN_STATUS_FLAG,

PjoPlanVersionsVl.OBJECT_ID1,

PjoPlanVersionsVl.OBJECT_TYPE_CODE,

PjoPlanningOptions.APPROVED_COST_PLAN_TYPE_FLAG,

PjoPlanningOptions.PLANNING_OPTION_ID,

PjoPlanningOptions.TIME_PHASED_CODE,

PjoPlanningOptions.PLAN_LEVEL_CODE,

PjoPlanVersionsVl.LOCKED_BY_PERSON_ID,

RBSHeader.NAME AS NAME1,

RBSHeader.RBS_HEADER_ID,

ParentRBSHeader.NAME AS NAME2,

ParentRBSHeader.RBS_HEADER_ID AS RBS_HEADER_ID1,

RBSHeader.CENTRALLY_CONTROL_FLAG,

RBSHeader.SOURCE_RBS_HEADER_ID,

case when (RBSHeader.CENTRALLY_CONTROL_FLAG = 'N' and RBSHeader.SOURCE_RBS_HEADER_ID is not null) then ParentRBSHeader.NAME else RBSHeader.NAME end as Name

FROM PJO_PLAN_VERSIONS_VL PjoPlanVersionsVl, PJO_PLANNING_OPTIONS PjoPlanningOptions, PJF_RBS_VERSIONS_B ProjectResourceBreakdownStru1, PJF_RBS_HEADERS_VL RBSHeader, PJF_RBS_HEADERS_VL ParentRBSHeader

WHERE PjoPlanVersionsVl.plan_version_id = PjoPlanningOptions.plan_version_id

and PjoPlanVersionsVl.plan_class_code = 'BUDGET'

and PjoPlanVersionsVl.structure_version_id is null

AND (PjoPlanVersionsVl.PLANNED_FOR_CODE <> 'REVENUE' )

AND (PjoPlanningOptions.APPROVED_COST_PLAN_TYPE_FLAG = 'Y' )

AND (PjoPlanningOptions.TIME_PHASED_CODE = 'A' )

AND PjoPlanningOptions.RBS_VERSION_ID = ProjectResourceBreakdownStru1.RBS_VERSION_ID

AND ProjectResourceBreakdownStru1.RBS_HEADER_ID = RBSHeader.RBS_HEADER_ID

AND RBSHeader.SOURCE_RBS_HEADER_ID = ParentRBSHeader.RBS_HEADER_ID(+)