Oracle Fusion · Data dictionary
PJT_PROJ_PLAN_LINES
SharedUsed in 9 subject areas30 reporting columns
line table, one row per line item under the header.
Likely primary key: PROJ_PLAN_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_EXPENSE_COST_AMOUNT | ● | Actual expense cost amount. | |
| ACTUAL_FINISH_DATE | ● | Actual finish date. | |
| ACTUAL_LABOR_BILLED_AMOUNT | ● | Actual labor billed amount. | |
| ACTUAL_LABOR_COST_AMOUNT | ● | Actual labor cost amount. | |
| ACTUAL_START_DATE | ● | Actual start date. | |
| COST_PERCENT_COMPLETE | ● | Cost percent complete. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DURATION | ● | Duration. | |
| EXPENSE_COST_AMOUNT | ● | Expense cost amount. | |
| FINISH_DATE | ● | Finish date. | |
| ITD_QUANTITY | ● | Itd quantity. | |
| LABOR_BILLED_AMOUNT | ● | Labor billed amount. | |
| LABOR_COST_AMOUNT | ● | Labor cost amount. | |
| LINE_NUMBER | PK? | ○ | Line number. |
| PERCENT_COMPLETE | ● | Percent complete. | |
| PHYSICAL_PERCENT_COMPLETE | ● | Physical percent complete. | |
| PLAN_LINE_TYPE_CODE | ● | Code identifying the plan line type. | |
| PRIORITY | ● | Priority. | |
| PROGRESS_STATUS_CODE | ● | Code identifying the progress status. | |
| PROJECT_ID | ● | Identifier for the project. | |
| PROJ_ELEMENT_ID | ● | Identifier for the proj element. | |
| PROJ_PLAN_HEADER_ID | PK? | ○ | Identifier for the proj plan header. |
| QUANTITY | ● | Quantity. | |
| REMAINING_EXPENSE_COST_AMOUNT | ● | Remaining expense cost amount. | |
| REMAINING_LABOR_BILLED_AMOUNT | ● | Remaining labor billed amount. | |
| REMAINING_LABOR_COST_AMOUNT | ● | Remaining labor cost amount. | |
| REMAINING_QUANTITY | ● | Remaining quantity. | |
| RESOURCE_ALLOCATION_PERCENT | ● | Resource allocation percentage. | |
| START_DATE | ● | Start date. | |
| TOTAL_ACTUAL_COST_AMOUNT | ● | Total actual cost amount. | |
| TOTAL_COST_AMOUNT | ● | Total cost amount. | |
| TOTAL_REMAINING_COST_AMOUNT | ● | Total remaining cost amount. |
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.
- Innovation Management - Product Proposals Real Time
- Product Management - Change Order Real Time
- Project Management - Opportunity Integration Real Time
- Project Management - Planning Real Time
- Project Management - Project Hierarchy Real Time
- Project Management - Requirements Real Time
- Project Management - Task Management Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
Need the extract + dbt staging for PJT_PROJ_PLAN_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table