DBA Data[Home] [Help]

VIEW: APPS.PSB_GL_BUDGET_SETS_V

Source

View Text - Preformatted

SELECT sets.rowid ,sets.gl_budget_set_id ,sets.gl_budget_set_name ,sets.set_of_books_id ,sets.last_update_date ,sets.last_updated_by ,sets.last_update_login ,sets.created_by ,sets.creation_date ,sets.context ,sets.attribute1 ,sets.attribute2 ,sets.attribute3 ,sets.attribute4 ,sets.attribute5 ,sets.attribute6 ,sets.attribute7 ,sets.attribute8 ,sets.attribute9 ,sets.attribute10 ,sob.name FROM psb_gl_budget_sets sets , gl_sets_of_books sob WHERE sets.set_of_books_id = sob.set_of_books_id
View Text - HTML Formatted

SELECT SETS.ROWID
, SETS.GL_BUDGET_SET_ID
, SETS.GL_BUDGET_SET_NAME
, SETS.SET_OF_BOOKS_ID
, SETS.LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY
, SETS.LAST_UPDATE_LOGIN
, SETS.CREATED_BY
, SETS.CREATION_DATE
, SETS.CONTEXT
, SETS.ATTRIBUTE1
, SETS.ATTRIBUTE2
, SETS.ATTRIBUTE3
, SETS.ATTRIBUTE4
, SETS.ATTRIBUTE5
, SETS.ATTRIBUTE6
, SETS.ATTRIBUTE7
, SETS.ATTRIBUTE8
, SETS.ATTRIBUTE9
, SETS.ATTRIBUTE10
, SOB.NAME
FROM PSB_GL_BUDGET_SETS SETS
, GL_SETS_OF_BOOKS SOB
WHERE SETS.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID