View: PAFV_ASSET_LINES

Product:	PA - Projects
Description:	Business view to show information about asset lines to be transferred to Oracle Assets.
Implementation/DBA Data:	APPS.PAFV_ASSET_LINES

View Text

SELECT PPAL.PROJECT_ASSET_LINE_ID
, PPAL.PROJECT_ASSET_LINE_DETAIL_ID
, PPAL.ORIGINAL_ASSET_COST
, PPAL.CURRENT_ASSET_COST
, PPAL.DESCRIPTION
, GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, TRANSFER_REJECTION_REASON
, '_LA:PPAL.AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPAL.PROJECT_ASSET_ID
, PPAA.ASSET_NAME
, PPAL.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PPAL.ASSET_CATEGORY_ID
, FC.DESCRIPTION
, PPAL.CIP_CCID
, PPAL.REV_PROJ_ASSET_LINE_ID
, PPAL.ORG_ID
, T.NAME
, PPAL.LAST_UPDATE_DATE
, PPAL.LAST_UPDATED_BY
, PPAL.CREATION_DATE
, PPAL.CREATED_BY
, PPAL.INVOICE_ID
, PPAL.INVOICE_NUMBER
FROM PA_PROJECT_ASSET_LINES_ALL PPAL
, PA_TASKS PT
, PA_PROJECT_ASSETS_ALL PPAA
, FA_CATEGORIES FC
, HR_ALL_ORGANIZATION_UNITS_TL T
WHERE PPAL.PROJECT_ASSET_ID = PPAA.PROJECT_ASSET_ID(+)
AND PPAL.TASK_ID = PT.TASK_ID
AND PPAL.ASSET_CATEGORY_ID = FC.CATEGORY_ID(+)
AND '_SEC:PPAL.ORG_ID' IS NOT NULL
AND PPAL.ORG_ID=T.ORGANIZATION_ID (+)
AND T.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY

Columns