Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PABV_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'
, '_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