View: PA_BUDGET_VERSIONS_DRAFT_V

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

View Text

SELECT V.ROWID
, V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, DECODE(V.WF_STATUS_CODE
, NULL
, L1.MEANING
, L5.MEANING)
, 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.CHANGE_REASON_CODE
, L2.MEANING
, V.BUDGET_ENTRY_METHOD_CODE
, M.BUDGET_ENTRY_METHOD
, V.LABOR_QUANTITY
, V.LABOR_UNIT_OF_MEASURE
, L3.MEANING
, V.RAW_COST
, V.BURDENED_COST
, V.REVENUE
, 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.BASELINED_BY_PERSON_ID
, V.BASELINED_DATE
, B.LABOR_QUANTITY
, B.LABOR_UNIT_OF_MEASURE
, L4.MEANING
, B.RAW_COST
, B.BURDENED_COST
, B.REVENUE
, B.BASELINED_DATE
, 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
, V.WF_STATUS_CODE
FROM PA_BUDGET_VERSIONS B
, PA_LOOKUPS L5
, PA_LOOKUPS L4
, PA_LOOKUPS L3
, PA_LOOKUPS L2
, PA_LOOKUPS L1
, PA_BUDGET_ENTRY_METHODS M
, PA_RESOURCE_LISTS R
, PA_BUDGET_VERSIONS V
WHERE V.BUDGET_STATUS_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'BUDGET STATUS'
AND V.RESOURCE_LIST_ID = R.RESOURCE_LIST_ID
AND V.CHANGE_REASON_CODE = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'BUDGET CHANGE REASON'
AND V.LABOR_UNIT_OF_MEASURE = L3.LOOKUP_CODE (+)
AND L3.LOOKUP_TYPE (+) = 'UNIT'
AND V.BUDGET_ENTRY_METHOD_CODE = M.BUDGET_ENTRY_METHOD_CODE (+)
AND V.PROJECT_ID = B.PROJECT_ID (+)
AND V.BUDGET_TYPE_CODE = B.BUDGET_TYPE_CODE (+)
AND B.CURRENT_FLAG (+) = 'Y'
AND B.LABOR_UNIT_OF_MEASURE = L4.LOOKUP_CODE (+)
AND L4.LOOKUP_TYPE (+) = 'UNIT'
AND V.BUDGET_STATUS_CODE IN ('W'
, 'S')
AND V.WF_STATUS_CODE = L5.LOOKUP_CODE (+)
AND L5.LOOKUP_TYPE (+) = 'WF_STATUS_CODE'

Columns