VIEW: PA.PA_PROJECT_ASSETS_ALL#

Source

View Text - Preformatted

select PROJECT_ASSET_ID PROJECT_ASSET_ID, PROJECT_ID PROJECT_ID, ASSET_NUMBER ASSET_NUMBER, ASSET_NAME ASSET_NAME, ASSET_DESCRIPTION ASSET_DESCRIPTION, LOCATION_ID LOCATION_ID, ASSIGNED_TO_PERSON_ID ASSIGNED_TO_PERSON_ID, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_UNITS ASSET_UNITS, DEPRECIATE_FLAG DEPRECIATE_FLAG, DEPRECIATION_EXPENSE_CCID DEPRECIATION_EXPENSE_CCID, AMORTIZE_FLAG AMORTIZE_FLAG, COST_ADJUSTMENT_FLAG COST_ADJUSTMENT_FLAG, CAPITALIZED_FLAG CAPITALIZED_FLAG, CAPITALIZED_DATE CAPITALIZED_DATE, REVERSE_FLAG REVERSE_FLAG, REVERSAL_DATE REVERSAL_DATE, ESTIMATED_IN_SERVICE_DATE ESTIMATED_IN_SERVICE_DATE, CAPITALIZED_COST CAPITALIZED_COST, GROUPED_CIP_COST GROUPED_CIP_COST, NEW_MASTER_FLAG NEW_MASTER_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, ASSET_KEY_CCID ASSET_KEY_CCID, CAPITAL_EVENT_ID CAPITAL_EVENT_ID, FA_PERIOD_NAME FA_PERIOD_NAME, PM_PRODUCT_CODE PM_PRODUCT_CODE, PM_ASSET_REFERENCE PM_ASSET_REFERENCE, ESTIMATED_COST ESTIMATED_COST, ESTIMATED_ASSET_UNITS ESTIMATED_ASSET_UNITS, PARENT_ASSET_ID PARENT_ASSET_ID, MANUFACTURER_NAME MANUFACTURER_NAME, MODEL_NUMBER MODEL_NUMBER, TAG_NUMBER TAG_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, RET_TARGET_ASSET_ID RET_TARGET_ASSET_ID, PROJECT_ASSET_TYPE PROJECT_ASSET_TYPE, FA_ASSET_ID FA_ASSET_ID, CAPITAL_HOLD_FLAG CAPITAL_HOLD_FLAG from "PA"."PA_PROJECT_ASSETS_ALL"

View Text - HTML Formatted

SELECT PROJECT_ASSET_ID PROJECT_ASSET_ID
, PROJECT_ID PROJECT_ID
, ASSET_NUMBER ASSET_NUMBER
, ASSET_NAME ASSET_NAME
, ASSET_DESCRIPTION ASSET_DESCRIPTION
, LOCATION_ID LOCATION_ID
, ASSIGNED_TO_PERSON_ID ASSIGNED_TO_PERSON_ID
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_UNITS ASSET_UNITS
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, DEPRECIATION_EXPENSE_CCID DEPRECIATION_EXPENSE_CCID
, AMORTIZE_FLAG AMORTIZE_FLAG
, COST_ADJUSTMENT_FLAG COST_ADJUSTMENT_FLAG
, CAPITALIZED_FLAG CAPITALIZED_FLAG
, CAPITALIZED_DATE CAPITALIZED_DATE
, REVERSE_FLAG REVERSE_FLAG
, REVERSAL_DATE REVERSAL_DATE
, ESTIMATED_IN_SERVICE_DATE ESTIMATED_IN_SERVICE_DATE
, CAPITALIZED_COST CAPITALIZED_COST
, GROUPED_CIP_COST GROUPED_CIP_COST
, NEW_MASTER_FLAG NEW_MASTER_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, ASSET_KEY_CCID ASSET_KEY_CCID
, CAPITAL_EVENT_ID CAPITAL_EVENT_ID
, FA_PERIOD_NAME FA_PERIOD_NAME
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, PM_ASSET_REFERENCE PM_ASSET_REFERENCE
, ESTIMATED_COST ESTIMATED_COST
, ESTIMATED_ASSET_UNITS ESTIMATED_ASSET_UNITS
, PARENT_ASSET_ID PARENT_ASSET_ID
, MANUFACTURER_NAME MANUFACTURER_NAME
, MODEL_NUMBER MODEL_NUMBER
, TAG_NUMBER TAG_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, RET_TARGET_ASSET_ID RET_TARGET_ASSET_ID
, PROJECT_ASSET_TYPE PROJECT_ASSET_TYPE
, FA_ASSET_ID FA_ASSET_ID
, CAPITAL_HOLD_FLAG CAPITAL_HOLD_FLAG
FROM "PA"."PA_PROJECT_ASSETS_ALL"