Oracle Fusion · Data dictionary
PJC_PRJ_ASSETS_ALL
ProjectsUsed in 1 subject areas25 reporting columns
Projects Costing (PJC), transaction table (rows scoped across all operating units).
Primary key: PROJECT_ASSET_ID
Joins (inferred from key columns): BOOK_TYPE_CODE → FA_BOOK_CONTROLS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMORTIZE_FLAG | ● | Indicator (Y/N) for the amortize. | |
| ASSET_DESCRIPTION | ● | Description of the asset. | |
| ASSET_NAME | ● | Name of the asset. | |
| ASSET_NUMBER | ● | Asset number. | |
| ASSET_UNITS | ● | Asset units. | |
| BOOK_TYPE_CODE | ● | Code identifying the book type. | |
| CAPITAL_HOLD_FLAG | ● | Indicator (Y/N) for the capital hold. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DATE_PLACED_IN_SERVICE | ● | Date placed in service. | |
| DEPRECIATE_FLAG | ● | Indicator (Y/N) for the depreciate. | |
| ESTIMATED_ASSET_UNITS | ● | Estimated asset units. | |
| ESTIMATED_COST | ● | Estimated cost. | |
| ESTIMATED_IN_SERVICE_DATE | ● | Estimated in service date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MANUFACTURER_NAME | ● | Name of the manufacturer. | |
| MODEL_NUMBER | ● | Model number. | |
| PM_ASSET_REFERENCE | ● | Pm asset reference. | |
| PM_PRODUCT_CODE | ● | Code identifying the pm product. | |
| PROJECT_ASSET_ID | PK | ● | Identifier for the project asset. |
| PROJECT_ASSET_TYPE | ● | Type of project asset. | |
| REVERSE_FLAG | ● | Indicator (Y/N) for the reverse. | |
| SERIAL_NUMBER | ● | Serial number. | |
| TAG_NUMBER | ● | Tag number. |
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_ASSETS_ALL.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for PJC_PRJ_ASSETS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table