VIEW: APPS.PABV_ASSETS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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