View: PA_BUDGET_VERSIONS_BASELINED_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_BUDGET_VERSIONS_BASELINED_V

View Text

SELECT V.ROWID
, V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, V.VERSION_NAME
, V.DESCRIPTION
, V.CURRENT_FLAG
, V.ORIGINAL_FLAG
, V.CURRENT_ORIGINAL_FLAG
, V.RESOURCE_ACCUMULATED_FLAG
, V.RESOURCE_LIST_ID
, R.NAME
, V.BASELINED_BY_PERSON_ID
, P.FULL_NAME
, V.BASELINED_DATE
, V.CHANGE_REASON_CODE
, L1.MEANING
, V.LABOR_QUANTITY
, V.LABOR_UNIT_OF_MEASURE
, L2.MEANING
, V.RAW_COST
, V.BURDENED_COST
, V.REVENUE
, V.BUDGET_ENTRY_METHOD_CODE
, M.BUDGET_ENTRY_METHOD
, M.ENTRY_LEVEL_CODE
, M.CATEGORIZATION_CODE
, M.COST_QUANTITY_FLAG
, M.RAW_COST_FLAG
, M.BURDENED_COST_FLAG
, M.REV_QUANTITY_FLAG
, M.REVENUE_FLAG
, M.TIME_PHASED_TYPE_CODE
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATE_LOGIN
, V.ATTRIBUTE_CATEGORY
, V.ATTRIBUTE1
, V.ATTRIBUTE2
, V.ATTRIBUTE3
, V.ATTRIBUTE4
, V.ATTRIBUTE5
, V.ATTRIBUTE6
, V.ATTRIBUTE7
, V.ATTRIBUTE8
, V.ATTRIBUTE9
, V.ATTRIBUTE10
, V.ATTRIBUTE11
, V.ATTRIBUTE12
, V.ATTRIBUTE13
, V.ATTRIBUTE14
, V.ATTRIBUTE15
, V.FIRST_BUDGET_PERIOD
, V.PM_PRODUCT_CODE
, V.PM_BUDGET_REFERENCE
FROM PA_LOOKUPS L2
, PA_LOOKUPS L1
, PA_BUDGET_ENTRY_METHODS M
, PER_PEOPLE_F P
, PA_RESOURCE_LISTS R
, PA_BUDGET_VERSIONS V
WHERE V.RESOURCE_LIST_ID = R.RESOURCE_LIST_ID
AND V.BASELINED_BY_PERSON_ID = P.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE (+)
AND P.EFFECTIVE_END_DATE (+)
AND V.CHANGE_REASON_CODE = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'BUDGET CHANGE REASON'
AND V.BUDGET_ENTRY_METHOD_CODE = M.BUDGET_ENTRY_METHOD_CODE (+)
AND V.LABOR_UNIT_OF_MEASURE = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'UNIT'
AND V.BUDGET_STATUS_CODE = 'B'

Columns