VIEW: APPS.PER_BUDGETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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