Oracle Fusion · Data dictionary
PJO_PLANNING_OPTIONS
ProjectsUsed in 2 subject areas11 reporting columns
Projects Planning (PJO).
Primary key: not yet catalogued for PJO_PLANNING_OPTIONS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| APPROVED_COST_PLAN_TYPE_FLAG | ● | Indicator (Y/N) for the approved cost plan type. | |
| APPROVED_REV_PLAN_TYPE_FLAG | ● | Indicator (Y/N) for the approved rev plan type. | |
| BUDGET_CREATION_METHOD | ● | Budget creation method. | |
| CURRENT_PLANNING_PERIOD | ● | Current planning period. | |
| MARGIN_DERIVED_FROM_CODE | ● | Code identifying the margin derived from. | |
| PLANNED_FOR_CODE | ● | Code identifying the planned for. | |
| PLAN_IN_MULTI_CURR_FLAG | ● | Indicator (Y/N) for the plan in multi currency. | |
| PLAN_LEVEL_CODE | ● | Code identifying the plan level. | |
| REV_CLASSIFICATION_METHOD | ● | Rev classification method. | |
| TIME_PHASED_CODE | ● | Code identifying the time phased. | |
| USE_PLANNING_RATES_FLAG | ● | Indicator (Y/N) for the use planning rates. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for PJO_PLANNING_OPTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.