Oracle Fusion · Data dictionary
PJC_PRJ_ASSET_LN_DETS
ProjectsUsed in 6 subject areas2 reporting columns
Projects Costing (PJC).
Primary key: PROJECT_ASSET_LINE_DETAIL_ID
Joins (inferred from key columns): EXPENDITURE_ITEM_ID → PJC_EXP_ITEMS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EXPENDITURE_ITEM_ID | ● | Identifier for the expenditure item. | |
| LINE_NUM | ● | Line number. | |
| PROJECT_ASSET_LINE_DETAIL_ID | PK | ○ | Identifier for the project asset line detail. |
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.
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Assets Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for PJC_PRJ_ASSET_LN_DETS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table