Oracle Fusion · Data dictionary
PJC_PRJ_ASSET_LNS_ALL
ProjectsUsed in 2 subject areas15 reporting columns
Projects Costing (PJC), transaction table (rows scoped across all operating units).
Primary key: PROJECT_ASSET_LINE_DETAIL_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENT_ASSET_COST | ● | Current asset cost. | |
| DESCRIPTION | ● | Description. | |
| FA_PERIOD_NAME | ● | Name of the fa period. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_TYPE | ● | Type of line. | |
| ORIGINAL_ASSET_COST | ● | Original asset cost. | |
| PROJECT_ASSET_LINE_DETAIL_ID | PK | ○ | Identifier for the project asset line detail. |
| PROJECT_ASSET_LINE_ID | ● | Identifier for the project asset line. | |
| RETIREMENT_COST_TYPE | ● | Type of retirement cost. | |
| RET_ADJUSTMENT_TXN_ID | ● | Identifier for the ret adjustment transaction. | |
| REV_PROJ_ASSET_LINE_ID | ● | Identifier for the rev proj asset line. | |
| TRANSFER_REJECTION_REASON | ● | Transfer rejection reason. | |
| TRANSFER_STATUS_CODE | ● | Code identifying the transfer status. |
2 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to PJC_PRJ_ASSET_LNS_ALL.
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 PJC_PRJ_ASSET_LNS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table