PJC_PRJ_ASSETS_ALL
PA_PROJECT_ASSETS_ALL stores information about assets defined under capital projects. Some table columns correspond to asset information in the Oracle Assets product.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_PRJ_ASSETS_ALL_PK |
PROJECT_ASSET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PROJECT_ASSET_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the asset | ||
| IB_REFERENCE_ID | NUMBER | 18 | The installed base asset reference identifier. | |||
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project to which this asset belongs | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item that will be created as an asset. | |||
| ASSET_NUMBER | VARCHAR2 | 30 | Unique asset identifier; can be user-entered or system-generated by Oracle Assets | |||
| AP_INVOICE_DISTRIBUTION_ID | NUMBER | 18 | The accounts payables invoice distribution identifier. This is used to associate eligible project related non-accrual expense costs to an asset or assets. | |||
| ASSET_NAME | VARCHAR2 | 240 | Yes | User-defined name that uniquely identifies an asset within a project | ||
| CST_TRANSACTION_ID | NUMBER | 18 | The transaction identifier of a supply chain inventory cost transaction. This is used to associate eligible project related inventory costs to an asset or assets. | |||
| ASSET_DESCRIPTION | VARCHAR2 | 80 | Yes | Description; placed on parent mass additions line upon transfer to Oracle Assets | ||
| DELIVER_TRANSACTION_ID | NUMBER | 18 | The transaction identifier of a supply chain receipt delivery transaction. This is used to associate eligible project related accrual expense costs to an asset or assets. | |||
| LOCATION_ID | NUMBER | 18 | The identifier of the location to which the asset is assigned | |||
| PO_DISTRIBUTION_ID | NUMBER | 18 | The identifier of a purchase order distribution that is populated by the Installed Base product that belongs to Oracle Fusion Maintenance. This is used to associate project related expense accrual variances to an asset or assets. Applies for both 2-way and 3-way invoice match options. | |||
| ASSIGNED_TO_PERSON_ID | NUMBER | 18 | The identifier of the employee to whom the asset is assigned | |||
| RECEIPT_TRANSACTION_ID | NUMBER | 18 | The parent or root transaction identifier of a purchase order receipt. This is used to associate project related expense accrual variances to an asset or assets. Applies only for a 3-way invoie match option. | |||
| DATE_PLACED_IN_SERVICE | DATE | Date placed in service of the asset | ||||
| ASSET_CATEGORY_ID | NUMBER | 18 | The identifier of the asset category to which the asset is assigned | |||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | The corporate book to which the asset is assigned | |||
| ASSET_UNITS | NUMBER | The number of asset units | ||||
| DEPRECIATE_FLAG | VARCHAR2 | 1 | Indicates whether or not the asset should be depreciated in Oracle Assets | |||
| DEPRECIATION_EXPENSE_CCID | NUMBER | 18 | The identifier of the depreciation expense account for the asset | |||
| AMORTIZE_FLAG | VARCHAR2 | 1 | Indicates whether or not cost adjustments should be amortized in Oracle Assets | |||
| COST_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Indicates whether asset cost adjustments have been interfaced to Oracle Assets | |||
| CAPITALIZED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether or not the asset has been interfaced to Oracle Assets | ||
| CAPITALIZED_DATE | DATE | The last date non-reversing cost adjustments were interfaced to Oracle Assets | ||||
| REVERSE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the asset will be reversed in the next Generate Asset Lines run | ||
| REVERSAL_DATE | DATE | The last date reversing asset lines were created. | ||||
| ESTIMATED_IN_SERVICE_DATE | DATE | The asset's estimated date placed in service | ||||
| CAPITALIZED_COST | NUMBER | The cost amount which has been interfaced to Oracle Assets for capitalization. | ||||
| GROUPED_CIP_COST | NUMBER | The asset's cost amount which has been grouped into asset lines. | ||||
| NEW_MASTER_FLAG | VARCHAR2 | 1 | Determines whether Oracle Assets will reclassify asset based on cost adjustment | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Assets (PJC_PRJ_ASSETS_DESC_FLEX) | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| ASSET_KEY_CCID | NUMBER | 18 | Key flexfield code combination identifier for asset key flexfield | |||
| CAPITAL_EVENT_ID | NUMBER | 18 | Capital Event Identifier | |||
| FA_PERIOD_NAME | VARCHAR2 | 15 | Asset book depreciation calendar period name to which the asset was posted. | |||
| PM_PRODUCT_CODE | VARCHAR2 | 30 | The identifier of the external project management system from which the project was imported. | |||
| PM_ASSET_REFERENCE | VARCHAR2 | 240 | The identifier of the project in the external project management system from which the project was imported. | |||
| ESTIMATED_COST | NUMBER | Estimated Asset Cost | ||||
| ESTIMATED_ASSET_UNITS | NUMBER | Estimated Asset Units | ||||
| PARENT_ASSET_ID | NUMBER | 18 | Parent Asset Identifier | |||
| MANUFACTURER_NAME | VARCHAR2 | 30 | Name of the Asset Manufacturer | |||
| MODEL_NUMBER | VARCHAR2 | 40 | Model Number of the Asset | |||
| TAG_NUMBER | VARCHAR2 | 15 | Tag Number of the Asset | |||
| SERIAL_NUMBER | VARCHAR2 | 35 | Serial Number of the Asset | |||
| RET_TARGET_ASSET_ID | NUMBER | 18 | Identifies the asset to be adjusted as retirement costs are processed. | |||
| PROJECT_ASSET_TYPE | VARCHAR2 | 30 | Yes | Project Asset Classification. Default value is ESTIMATED. | ||
| FA_ASSET_ID | NUMBER | 18 | FA Asset identifier for Tieback purposes. | |||
| CAPITAL_HOLD_FLAG | VARCHAR2 | 1 | Yes | Flag to prevent generation of new asset lines. Default N | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CREATION_SOURCE | VARCHAR2 | 30 | Capture source that creates Asset | |||
| FA_PERIOD_NAME_SOURCE | VARCHAR2 | 30 | The source, such as FBDI, REST, and so on, that was used to update the FA_PERIOD_NAME of a PPM asset. If the Tieback process was used to tie the asset's details back from FA to Projects, this column should be blank. | |||
| FA_ASSET_ID_SOURCE | VARCHAR2 | 30 | The source, such as FBDI, REST, and so on, that was used to update the FA_ASSET_ID of a PPM asset. If the Tieback process was used to tie the asset's details back from FA to Projects, this column should be blank. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_PRJ_ASSETS_ALL | pjf_projects_all_b | PROJECT_ID |
| PJC_PRJ_ASSETS_ALL | fa_categories_b | ASSET_CATEGORY_ID |
| PJC_PRJ_ASSETS_ALL | fa_additions_b | PARENT_ASSET_ID |
| PJC_PRJ_ASSETS_ALL | fa_additions_b | RET_TARGET_ASSET_ID |
| PJC_PRJ_ASSETS_ALL | fa_additions_b | FA_ASSET_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_PRJ_ASSETS_ALL_N1 | Non Unique | Default | PROJECT_ID |
| PJC_PRJ_ASSETS_ALL_N2 | Non Unique | Default | REVERSE_FLAG |
| PJC_PRJ_ASSETS_ALL_N3 | Non Unique | Default | REQUEST_ID |
| PJC_PRJ_ASSETS_ALL_N4 | Non Unique | Default | ASSET_NAME, PROJECT_ID |
| PJC_PRJ_ASSETS_ALL_N5 | Non Unique | Default | ASSET_NUMBER |
| PJC_PRJ_ASSETS_ALL_U1 | Unique | Default | PROJECT_ASSET_ID |