VIEW: APPS.PABV_ASSET_LINES

Source

View Text - Preformatted

SELECT project_asset_line_id , original_asset_cost , current_asset_cost , description , gl_date , '_LA:transfer_status_code:PA_LOOKUPS:TRANSFER STATUS:MEANING' , transfer_rejection_reason , '_LA:amortize_flag:FND_LOOKUPS:YES_NO:MEANING' , project_asset_id , task_id , asset_category_id , cip_ccid , rev_proj_asset_line_id , org_id , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , INVOICE_ID FROM pa_project_asset_lines_all WHERE '_SEC:org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PROJECT_ASSET_LINE_ID
, ORIGINAL_ASSET_COST
, CURRENT_ASSET_COST
, DESCRIPTION
, GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, TRANSFER_REJECTION_REASON
, '_LA:AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PROJECT_ASSET_ID
, TASK_ID
, ASSET_CATEGORY_ID
, CIP_CCID
, REV_PROJ_ASSET_LINE_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, INVOICE_ID
FROM PA_PROJECT_ASSET_LINES_ALL
WHERE '_SEC:ORG_ID' IS NOT NULL WITH READ ONLY