VIEW: APPS.PAFV_BUDGET_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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