View: PAFV_BUDGET_LINES

Product:	PA - Projects
Description:	Business view to show information on the budget lines.
Implementation/DBA Data:	APPS.PAFV_BUDGET_LINES

View Text

SELECT PRA.RESOURCE_ASSIGNMENT_ID
, PBL.START_DATE
, PBL.END_DATE
, PBL.QUANTITY
, PBL.RAW_COST
, PBL.BURDENED_COST
, PBL.REVENUE
, PBL.DESCRIPTION
, PBL.PERIOD_NAME
, '_DF:PA:PA_BUDGET_LINES_DESC_FLEX:PBL'
, '_LA:PBL.CHANGE_REASON_CODE:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING'
, '_LA:PRA.UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, PRA.BUDGET_VERSION_ID
, PBV.VERSION_NAME
, PRA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PRA.TASK_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, PRA.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, PBL.LAST_UPDATE_DATE
, PBL.LAST_UPDATED_BY
, PBL.CREATION_DATE
, PBL.CREATED_BY
FROM PA_BUDGET_LINES PBL
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_PROJECTS_ALL PPA
, PA_BUDGET_VERSIONS PBV
, PA_RESOURCE_LIST_MEMBERS PRLM
, PA_TASKS PT
WHERE PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PRA.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND PRA.PROJECT_ID = PPA.PROJECT_ID
AND PRA.RESOURCE_LIST_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_ID
AND PRA.TASK_ID = PT.TASK_ID (+)
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns