PJS_PLAN_VERSION_D_V

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name
PROJECT_ID PARENT_PLAN_VERSION_ID PLAN_VERSION_NAME PLAN_VERSION_ID PLAN_TYPE_ID PLAN_CLASS_CODE TIME_PHASED_TYPE_CODE CURRENT_BUDGET_FLAG ORIGINAL_BUDGET_FLAG CURRENT_FORECAST_FLAG PRIOR_FORECAST_FLAG

Query

SQL_Statement
select PROJECT_ID, PARENT_PLAN_VERSION_ID, PLAN_VERSION_NAME, PLAN_VERSION_ID, PLAN_TYPE_ID, PLAN_CLASS_CODE, TIME_PHASED_TYPE_CODE, CURRENT_BUDGET_FLAG, ORIGINAL_BUDGET_FLAG, CURRENT_FORECAST_FLAG, PRIOR_FORECAST_FLAG from PJS_PLAN_VERSION_D ver where ver.PLAN_VERSION_ID in (0, 1) order by PLAN_VERSION_ID