VIEW: APPS.PABV_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 , '_LA:pbl.change_reason_code:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING' , '_LA:pra.unit_of_measure:PA_LOOKUPS:UNIT:MEANING' , '_DF:PA:PA_BUDGET_LINES_DESC_FLEX:pbl' , pra.budget_version_id , pra.project_id , pra.task_id , pra.resource_list_member_id , 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 WHERE pbl.resource_assignment_id = pra.resource_assignment_id and pra.project_id = ppa.project_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
, '_LA:PBL.CHANGE_REASON_CODE:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING'
, '_LA:PRA.UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, '_DF:PA:PA_BUDGET_LINES_DESC_FLEX:PBL'
, PRA.BUDGET_VERSION_ID
, PRA.PROJECT_ID
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, 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
WHERE PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PRA.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY