VIEW: APPS.PA_BUDGET_VERSIONS_DRAFT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'