[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJECT_ASSETS_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | PA |
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ASSET_ID | NUMBER | (15) | Yes | |
| PROJECT_ID | NUMBER | (15) | Yes | |
| ASSET_NUMBER | VARCHAR2 | (15) | ||
| ASSET_NAME | VARCHAR2 | (240) | Yes | |
| ASSET_DESCRIPTION | VARCHAR2 | (80) | Yes | |
| LOCATION_ID | NUMBER | (15) | ||
| ASSIGNED_TO_PERSON_ID | NUMBER | (15) | ||
| DATE_PLACED_IN_SERVICE | DATE | |||
| ASSET_CATEGORY_ID | NUMBER | (15) | ||
| BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
| ASSET_UNITS | NUMBER | |||
| DEPRECIATE_FLAG | VARCHAR2 | (1) | ||
| DEPRECIATION_EXPENSE_CCID | NUMBER | (15) | ||
| AMORTIZE_FLAG | VARCHAR2 | (1) | ||
| COST_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
| CAPITALIZED_FLAG | VARCHAR2 | (1) | Yes | |
| CAPITALIZED_DATE | DATE | |||
| REVERSE_FLAG | VARCHAR2 | (1) | Yes | |
| REVERSAL_DATE | DATE | |||
| ESTIMATED_IN_SERVICE_DATE | DATE | |||
| CAPITALIZED_COST | NUMBER | (22) | ||
| GROUPED_CIP_COST | NUMBER | (22) | ||
| NEW_MASTER_FLAG | VARCHAR2 | (1) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ORG_ID | NUMBER | (15) | ||
| ASSET_KEY_CCID | NUMBER | (15) | ||
| CAPITAL_EVENT_ID | NUMBER | (15) | Capital Event Identifier. | |
| FA_PERIOD_NAME | VARCHAR2 | (15) | FA Period into which 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 | (15) | 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 | (15) | 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 | (15) | FA Asset identifier for Tieback purposes. | |
| CAPITAL_HOLD_FLAG | VARCHAR2 | (1) | Yes | Flag to prevent generation of new asset lines. Default "N". |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ASSET_ID
, PROJECT_ID
, ASSET_NUMBER
, ASSET_NAME
, ASSET_DESCRIPTION
, LOCATION_ID
, ASSIGNED_TO_PERSON_ID
, DATE_PLACED_IN_SERVICE
, ASSET_CATEGORY_ID
, BOOK_TYPE_CODE
, ASSET_UNITS
, DEPRECIATE_FLAG
, DEPRECIATION_EXPENSE_CCID
, AMORTIZE_FLAG
, COST_ADJUSTMENT_FLAG
, CAPITALIZED_FLAG
, CAPITALIZED_DATE
, REVERSE_FLAG
, REVERSAL_DATE
, ESTIMATED_IN_SERVICE_DATE
, CAPITALIZED_COST
, GROUPED_CIP_COST
, NEW_MASTER_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, ASSET_KEY_CCID
, CAPITAL_EVENT_ID
, FA_PERIOD_NAME
, PM_PRODUCT_CODE
, PM_ASSET_REFERENCE
, ESTIMATED_COST
, ESTIMATED_ASSET_UNITS
, PARENT_ASSET_ID
, MANUFACTURER_NAME
, MODEL_NUMBER
, TAG_NUMBER
, SERIAL_NUMBER
, RET_TARGET_ASSET_ID
, PROJECT_ASSET_TYPE
, FA_ASSET_ID
, CAPITAL_HOLD_FLAG
FROM PA.PA_PROJECT_ASSETS_ALL#;
PA
PA_PROJECT_ASSETS_ALL
APPS
PA_PROJECT_ASSETS
PA_PROJECT_ASSETS_ALL
|
|
|
|