VIEW: APPS.RG_BUDGETS_V

Source

View Text - Preformatted

SELECT PA.ROWID ROW_ID , PA.PARAMETER_SET_ID , PA.LAST_UPDATE_DATE , PA.LAST_UPDATED_BY , PA.LAST_UPDATE_LOGIN , PA.CREATION_DATE , PA.CREATED_BY , PA.PARAMETER_NUM , PA.PARAMETER_ID , GL_BUDGET_VERSIONS.BUDGET_NAME , GL_BUDGETS.DESCRIPTION , PA.DATA_TYPE , PA.CONTEXT , PA.ATTRIBUTE1 , PA.ATTRIBUTE2 , PA.ATTRIBUTE3 , PA.ATTRIBUTE4 , PA.ATTRIBUTE5 , PA.ATTRIBUTE6 , PA.ATTRIBUTE7 , PA.ATTRIBUTE8 , PA.ATTRIBUTE9 , PA.ATTRIBUTE10 , PA.ATTRIBUTE11 , PA.ATTRIBUTE12 , PA.ATTRIBUTE13 , PA.ATTRIBUTE14 , PA.ATTRIBUTE15 FROM RG_REPORT_PARAMETERS PA,GL_BUDGET_VERSIONS ,GL_BUDGETS WHERE PA.DATA_TYPE = 'B' AND PA.PARAMETER_ID = GL_BUDGET_VERSIONS.BUDGET_VERSION_ID AND GL_BUDGET_VERSIONS.BUDGET_NAME = GL_BUDGETS.BUDGET_NAME

View Text - HTML Formatted

SELECT PA.ROWID ROW_ID
, PA.PARAMETER_SET_ID
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.PARAMETER_NUM
, PA.PARAMETER_ID
, GL_BUDGET_VERSIONS.BUDGET_NAME
, GL_BUDGETS.DESCRIPTION
, PA.DATA_TYPE
, PA.CONTEXT
, PA.ATTRIBUTE1
, PA.ATTRIBUTE2
, PA.ATTRIBUTE3
, PA.ATTRIBUTE4
, PA.ATTRIBUTE5
, PA.ATTRIBUTE6
, PA.ATTRIBUTE7
, PA.ATTRIBUTE8
, PA.ATTRIBUTE9
, PA.ATTRIBUTE10
, PA.ATTRIBUTE11
, PA.ATTRIBUTE12
, PA.ATTRIBUTE13
, PA.ATTRIBUTE14
, PA.ATTRIBUTE15
FROM RG_REPORT_PARAMETERS PA
, GL_BUDGET_VERSIONS
, GL_BUDGETS
WHERE PA.DATA_TYPE = 'B'
AND PA.PARAMETER_ID = GL_BUDGET_VERSIONS.BUDGET_VERSION_ID
AND GL_BUDGET_VERSIONS.BUDGET_NAME = GL_BUDGETS.BUDGET_NAME