[Home] [Help]
View: PER_ASSIGNMENT_BUDGET_VALUES_D
View Text
SELECT ABV.ASSIGNMENT_BUDGET_VALUE_ID
, ABV.EFFECTIVE_START_DATE
, ABV.EFFECTIVE_END_DATE
, LK1.MEANING
, ABV.VALUE
, ABV.LAST_UPDATE_DATE
, USR.USER_NAME LAST_UPDATED_BY
FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
, HR_LOOKUPS LK1
, FND_USER_VIEW USR
WHERE LK1.LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE'
AND LK1.LOOKUP_CODE = ABV.UNIT
AND USR.USER_ID (+) = ABV.LAST_UPDATED_BY
Columns
Name |
ASSIGNMENT_BUDGET_VALUE_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
UNIT |
VALUE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |