VIEW: APPS.PA_PROJECT_ASSETS_AMG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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