VIEW: APPS.PA_BUDGET_VERSIONS_BASELINED_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 , 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'

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
, 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'