VIEW: APPS.PABV_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' , '_LA:pbv.current_original_flag:FND_LOOKUPS:YES_NO:meaning' , pbv.baselined_date , '_LA:pbv.pm_product_code:PA_LOOKUPS:PM_PRODUCT_CODE:meaning' , pbv.PM_BUDGET_REFERENCE , '_LA:pbv.wf_status_code:PA_LOOKUPS:WF_STATUS_CODE:meaning' , pbv.baselined_by_person_id , pbv.labor_quantity , '_LA:pbv.labor_unit_of_measure:PA_LOOKUPS:UNIT:MEANING' , pbv.raw_cost , pbv.burdened_cost , pbv.revenue , '_LA:BUDGET_STATUS_CODE:PA_LOOKUPS:BUDGET STATUS:MEANING' , '_LA:CHANGE_REASON_CODE:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING' , '_DF:PA:PA_BUDGET_VERSIONS_DESC_FLEX:pbv' , pbv.project_id , pbv.budget_type_code , pbv.resource_list_id , pbv.LAST_UPDATE_DATE , pbv.LAST_UPDATED_BY , pbv.CREATION_DATE , pbv.CREATED_BY FROM pa_budget_versions pbv , pa_projects_all ppa WHERE pbv.project_id = ppa.project_id and '_SEC:ppa.org_id' is not null 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'
, '_LA:PBV.CURRENT_ORIGINAL_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PBV.BASELINED_DATE
, '_LA:PBV.PM_PRODUCT_CODE:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING'
, PBV.PM_BUDGET_REFERENCE
, '_LA:PBV.WF_STATUS_CODE:PA_LOOKUPS:WF_STATUS_CODE:MEANING'
, PBV.BASELINED_BY_PERSON_ID
, PBV.LABOR_QUANTITY
, '_LA:PBV.LABOR_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, PBV.RAW_COST
, PBV.BURDENED_COST
, PBV.REVENUE
, '_LA:BUDGET_STATUS_CODE:PA_LOOKUPS:BUDGET STATUS:MEANING'
, '_LA:CHANGE_REASON_CODE:PA_LOOKUPS:BUDGET CHANGE REASON:MEANING'
, '_DF:PA:PA_BUDGET_VERSIONS_DESC_FLEX:PBV'
, PBV.PROJECT_ID
, PBV.BUDGET_TYPE_CODE
, PBV.RESOURCE_LIST_ID
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATED_BY
, PBV.CREATION_DATE
, PBV.CREATED_BY
FROM PA_BUDGET_VERSIONS PBV
, PA_PROJECTS_ALL PPA
WHERE PBV.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY