1. Tables and Views for Project Management
  2. GMS_AWARD_BUDGETS_V

GMS_AWARD_BUDGETS_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

PROJECT_ID

OBJECT_ID1

PLAN_TYPE_ID

PLANNED_FOR_CODE

TIME_PHASED_CODE

PLAN_STATUS_CODE

PLAN_VERSION_ID

TOTAL_PC_RAW_COST

TOTAL_PC_BRDND_COST

PFC_RAW_COST

PFC_BRDND_COST

Query

SQL_Statement

select a.project_id,

a.object_id1,

a.plan_type_id,

a.PLANNED_FOR_CODE,

b.time_phased_code,

a.plan_status_code,

a.plan_version_id,

a.total_pc_raw_cost,

a.total_pc_brdnd_cost,

a.pfc_raw_cost,

a.pfc_brdnd_cost

from pjo_plan_versions_b a, pjo_planning_options b

where a.plan_version_id = b.plan_version_id

and a.current_plan_status_flag = 'Y'

and a.PLAN_CLASS_CODE = 'BUDGET'

AND a.OBJECT_TYPE_CODE = 'AWARD'

and b.plan_type_code = 'FINANCIAL_PLAN'

AND B.APPROVED_COST_PLAN_TYPE_FLAG = 'Y'

order by a.project_id