FND Design Data [Home] [Help]

View: PAFV_ASSET_LINE_DETAILS

Product: PA - Projects
Description: Business view to show details about asset lines to be transferred to Oracle Assets.
Implementation/DBA Data: ViewAPPS.PAFV_ASSET_LINE_DETAILS
View Text

SELECT PASD.PROJ_ASSET_LINE_DTL_UNIQ_ID
, PASD.CIP_COST
, '_LA:PASD.REVERSED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PASD.PROJECT_ASSET_LINE_DETAIL_ID
, PAS.DESCRIPTION
, PASD.EXPENDITURE_ITEM_ID
, PASD.LINE_NUM
, PASD.LAST_UPDATE_DATE
, PASD.LAST_UPDATED_BY
, PASD.CREATION_DATE
, PASD.CREATED_BY
FROM PA_PROJECT_ASSET_LINE_DETAILS PASD
, PA_PROJECT_ASSET_LINES_ALL PAS
WHERE PASD.PROJECT_ASSET_LINE_DETAIL_ID = PAS.PROJECT_ASSET_LINE_DETAIL_ID
AND '_SEC:PAS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PROJECT_ASSET_LINE_DTL_UNIQ_ID
CIP_COST
"_LA:REVERSED_FLAG"
PROJECT_ASSET_LINE_DETAIL_ID
DESCRIPTION
EXPENDITURE_ITEM_ID
LINE_NUM
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY