View: PABV_ASSETS

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_ASSETS

View Text

SELECT PROJECT_ASSET_ID
, ASSET_NUMBER
, ASSET_NAME
, ASSET_UNITS
, '_LA:AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, CAPITALIZED_COST
, CAPITALIZED_DATE
, '_LA:CAPITALIZED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:DEPRECIATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, ASSET_DESCRIPTION
, DATE_PLACED_IN_SERVICE
, ESTIMATED_IN_SERVICE_DATE
, GROUPED_CIP_COST
, REVERSAL_DATE
, '_LA:REVERSE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:PA:PA_PROJECT_ASSETS:PPA'
, PROJECT_ID
, ASSET_CATEGORY_ID
, ASSIGNED_TO_PERSON_ID
, PPA.LOCATION_ID
, PPA.BOOK_TYPE_CODE
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM PA_PROJECT_ASSETS_ALL PPA
WHERE '_SEC:ORG_ID' IS NOT NULL WITH READ ONLY

Columns