FND Design Data [Home] [Help]

View: PABV_ASSET_LINES

Product: PA - Projects
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.PABV_ASSET_LINES
View Text

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

Columns

Name
PROJECT_ASSET_LINE_ID
ORIGINAL_ASSET_COST
CURRENT_ASSET_COST
DESCRIPTION
GL_DATE
"_LA:TRANSFER_STATUS"
TRANSFER_REJECTION_REASON
"_LA:AMORTIZE_FLAG"
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