Oracle Fusion/Projects/Project Control

PJO_PLAN_VERSIONS_B

Budget and forecast plan versions for a project — one current baselined version per plan type.

Key Columns

PLAN_VERSION_IDPROJECT_IDFIN_PLAN_TYPE_IDCURRENT_PLAN_STATUS_CODECURRENT_WORKING_FLAG

Parent Table

PJF_PROJECTS_ALL_B

Project definitions — number, type, owning organization, dates and status.

Child Tables

PJO_PLANNING_ELEMENTS

Budget/forecast planning elements — a planned amount at a task + resource (RBS) intersection.

Common Joins

PJO_PLANNING_ELEMENTSvia PLAN_VERSION_ID

The task/resource planning elements that make up this version.

Used In

Project Control

Project budgets and forecasts

Budgets and forecasts are plan versions (PJO_PLAN_VERSIONS_B) made of planning elements at task + resource intersections (PJO_PLANNING_ELEMENTS), spread to periods in PJO_PLAN_LINES.