Product: | PA - Projects |
---|---|
Description: | Business view to show information about versions of budgets. |
Implementation/DBA Data: | APPS.PAFV_BUDGET_VERSIONS |
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