VIEW: APPS.PAFV_BUDGET_VERSIONS

Source

View Text - Preformatted

SELECT pbv.budget_version_id , pbv.version_number , pbv.version_name , pbv.description , '_LA:pbv.current_flag:FND_LOOKUPS:YES_NO:meaning' , '_LA:pbv.original_flag:FND_LOOKUPS:YES_NO:meaning' , pbv.labor_quantity , '_LA:pbv.labor_unit_of_measure:PA_LOOKUPS:UNIT:MEANING' , pbv.raw_cost , pbv.burdened_cost , pbv.revenue , '_LA:pbv.BUDGET_STATUS_CODE:PA_LOOKUPS:BUDGET STATUS:MEANING' , '_LA:pbv.CHANGE_REASON_CODE:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING' , '_LA:pbv.current_original_flag:FND_LOOKUPS:YES_NO:meaning' , baselined_date , '_LA:pbv.pm_product_code:PA_LOOKUPS:PM_PRODUCT_CODE:meaning' , PM_BUDGET_REFERENCE , '_LA:pbv.wf_status_code:PA_LOOKUPS:WF_STATUS_CODE:meaning' , baselined_by_person_id , pap.full_name , '_DF:PA:PA_BUDGET_VERSIONS_DESC_FLEX:pbv' , pbv.project_id , ppa.name,ppa.segment1 , pbv.budget_type_code , pbt.budget_type , pbv.resource_list_id , prla.name , pbv.LAST_UPDATE_DATE , pbv.LAST_UPDATED_BY , pbv.CREATION_DATE , pbv.CREATED_BY FROM pa_budget_versions pbv , pa_projects_all ppa , pa_budget_types pbt , pa_resource_lists_all_bg prla , per_all_people_f pap WHERE pbv.project_id = ppa.project_id and pbv.budget_type_code = pbt.budget_type_code and pbv.resource_list_id = prla.resource_list_id and '_SEC:ppa.org_id' is not null and pbv.baselined_by_person_id = pap.person_id (+) and trunc(sysdate) between pap.effective_start_date (+) and pap.effective_end_date (+) WITH READ ONLY

View Text - HTML Formatted

SELECT PBV.BUDGET_VERSION_ID
, PBV.VERSION_NUMBER
, PBV.VERSION_NAME
, PBV.DESCRIPTION
, '_LA:PBV.CURRENT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PBV.ORIGINAL_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PBV.LABOR_QUANTITY
, '_LA:PBV.LABOR_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, PBV.RAW_COST
, PBV.BURDENED_COST
, PBV.REVENUE
, '_LA:PBV.BUDGET_STATUS_CODE:PA_LOOKUPS:BUDGET STATUS:MEANING'
, '_LA:PBV.CHANGE_REASON_CODE:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING'
, '_LA:PBV.CURRENT_ORIGINAL_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, BASELINED_DATE
, '_LA:PBV.PM_PRODUCT_CODE:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING'
, PM_BUDGET_REFERENCE
, '_LA:PBV.WF_STATUS_CODE:PA_LOOKUPS:WF_STATUS_CODE:MEANING'
, BASELINED_BY_PERSON_ID
, PAP.FULL_NAME
, '_DF:PA:PA_BUDGET_VERSIONS_DESC_FLEX:PBV'
, PBV.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PBV.BUDGET_TYPE_CODE
, PBT.BUDGET_TYPE
, PBV.RESOURCE_LIST_ID
, PRLA.NAME
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATED_BY
, PBV.CREATION_DATE
, PBV.CREATED_BY
FROM PA_BUDGET_VERSIONS PBV
, PA_PROJECTS_ALL PPA
, PA_BUDGET_TYPES PBT
, PA_RESOURCE_LISTS_ALL_BG PRLA
, PER_ALL_PEOPLE_F PAP
WHERE PBV.PROJECT_ID = PPA.PROJECT_ID
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBV.RESOURCE_LIST_ID = PRLA.RESOURCE_LIST_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL
AND PBV.BASELINED_BY_PERSON_ID = PAP.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE (+)
AND PAP.EFFECTIVE_END_DATE (+) WITH READ ONLY