1. Tables and Views for Project Management
  2. GMS_BUDGET_SUMMARY_V

GMS_BUDGET_SUMMARY_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

PLAN_VERSION_ID

PROJECT_ID

PROJECT_ELEMENT_ID

RBS_VERSION_ID

RBS_VERSION_ID1

RBS_ELEMENT_ID

RBS_ELEMENT_ID1

RESOURCE_NAME

SCENARIO

PLAN_VERSION_ID_FLAG

TIME_ID

BUDGET_RAW_COST

BUDGET_BRDND_COST

CURRENCY_CODE

CURRENCY_TYPE

Query

SQL_Statement

select budget.plan_version_id,

budget.project_id,

budget.project_element_id,

budget.rbs_version_id,

rbsversion.rbs_version_id as rbs_version_id1,

budget.rbs_element_id,

resourcedef.rbs_element_id as rbs_element_id1,

resourcedef.resource_name,

budget.scenario,

budget.Plan_version_id_flag,

budget.time_id,

budget.raw_cost as budget_raw_cost,

budget.brdn_cost as budget_brdnd_cost,

budget.currency_code,

budget.currency_type

from PJS_FP_PROJ_BGT_F budget,

pjf_rbs_prj_assignments rbsversion,

pjs_rbs_d resourcedef

where budget.currency_type = 'F'

and budget.rbs_element_id <> 0

and budget.calendar_type = 'A'

and budget.plan_version_id_flag = 1

and rbsversion.project_id = budget.project_id

and rbsversion.primary_reporting_rbs_flag = 'Y'

and budget.rbs_version_id = rbsversion.rbs_version_id

and budget.rbs_version_id = resourcedef.rbs_version_id

and budget.rbs_element_id = resourcedef.rbs_element_id