Product: | PA - Projects |
---|---|
Description: | Single-Org |
Implementation/DBA Data: | APPS.PA_PROJECT_ASSETS_AMG_V |
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
, ASSET_KEY_CCID
, 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
, CAPITAL_EVENT_ID
, PROJECT_ASSET_TYPE
, 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
, FA_ASSET_ID
, CAPITAL_HOLD_FLAG
FROM PA_PROJECT_ASSETS