View: PER_BUDGETS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_BUDGETS_V

View Text

SELECT BUD.ROWID ROW_ID
, BUD.BUDGET_ID BUDGET_ID
, BUD.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BUD.COMMENTS COMMENTS
, BUD.UNIT UNIT
, BUD.REQUEST_ID REQUEST_ID
, BUD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BUD.PROGRAM_ID PROGRAM_ID
, BUD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BUD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BUD.ATTRIBUTE1 ATTRIBUTE1
, BUD.ATTRIBUTE2 ATTRIBUTE2
, BUD.ATTRIBUTE3 ATTRIBUTE3
, BUD.ATTRIBUTE4 ATTRIBUTE4
, BUD.ATTRIBUTE5 ATTRIBUTE5
, BUD.ATTRIBUTE6 ATTRIBUTE6
, BUD.ATTRIBUTE7 ATTRIBUTE7
, BUD.ATTRIBUTE8 ATTRIBUTE8
, BUD.ATTRIBUTE9 ATTRIBUTE9
, BUD.ATTRIBUTE10 ATTRIBUTE10
, BUD.ATTRIBUTE11 ATTRIBUTE11
, BUD.ATTRIBUTE12 ATTRIBUTE12
, BUD.ATTRIBUTE13 ATTRIBUTE13
, BUD.ATTRIBUTE14 ATTRIBUTE14
, BUD.ATTRIBUTE15 ATTRIBUTE15
, BUD.ATTRIBUTE16 ATTRIBUTE16
, BUD.ATTRIBUTE17 ATTRIBUTE17
, BUD.ATTRIBUTE18 ATTRIBUTE18
, BUD.ATTRIBUTE19 ATTRIBUTE19
, BUD.ATTRIBUTE20 ATTRIBUTE20
, BUD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BUD.LAST_UPDATED_BY LAST_UPDATED_BY
, BUD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BUD.CREATED_BY CREATED_BY
, BUD.CREATION_DATE CREATION_DATE
, BUD.NAME NAME
, BUD.PERIOD_SET_NAME PERIOD_SET_NAME
, CAL.ACTUAL_PERIOD_TYPE ACTUAL_PERIOD_TYPE
, LK.MEANING UNIT_MEANING
, BUD.BUDGET_TYPE_CODE BUDGET_TYPE_CODE
FROM PER_BUDGETS BUD
, PAY_CALENDARS CAL
, HR_LOOKUPS LK
WHERE BUD.PERIOD_SET_NAME = CAL.PERIOD_SET_NAME
AND (BUD.UNIT = LK.LOOKUP_CODE (+)
AND LK.LOOKUP_TYPE (+) = 'BUDGET_MEASUREMENT_TYPE')

Columns