VIEW: RG.RG_DSS_VARIABLES#

Source

View Text - Preformatted

select VARIABLE_ID VARIABLE_ID, NAME NAME, LEDGER_ID LEDGER_ID, BALANCE_TYPE BALANCE_TYPE, CURRENCY_TYPE CURRENCY_TYPE, LEVEL_CODE LEVEL_CODE, STATUS_CODE STATUS_CODE, OBJECT_NAME OBJECT_NAME, COLUMN_LABEL COLUMN_LABEL, ID_FLEX_CODE ID_FLEX_CODE, ID_FLEX_NUM ID_FLEX_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CURRENCY_CODE CURRENCY_CODE, BUDGET_VERSION_ID BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, DESCRIPTION DESCRIPTION, SEGMENT1_TYPE SEGMENT1_TYPE, SEGMENT2_TYPE SEGMENT2_TYPE, SEGMENT3_TYPE SEGMENT3_TYPE, SEGMENT4_TYPE SEGMENT4_TYPE, SEGMENT5_TYPE SEGMENT5_TYPE, SEGMENT6_TYPE SEGMENT6_TYPE, SEGMENT7_TYPE SEGMENT7_TYPE, SEGMENT8_TYPE SEGMENT8_TYPE, SEGMENT9_TYPE SEGMENT9_TYPE, SEGMENT10_TYPE SEGMENT10_TYPE, SEGMENT11_TYPE SEGMENT11_TYPE, SEGMENT12_TYPE SEGMENT12_TYPE, SEGMENT13_TYPE SEGMENT13_TYPE, SEGMENT14_TYPE SEGMENT14_TYPE, SEGMENT15_TYPE SEGMENT15_TYPE, SEGMENT16_TYPE SEGMENT16_TYPE, SEGMENT17_TYPE SEGMENT17_TYPE, SEGMENT18_TYPE SEGMENT18_TYPE, SEGMENT19_TYPE SEGMENT19_TYPE, SEGMENT20_TYPE SEGMENT20_TYPE, SEGMENT21_TYPE SEGMENT21_TYPE, SEGMENT22_TYPE SEGMENT22_TYPE, SEGMENT23_TYPE SEGMENT23_TYPE, SEGMENT24_TYPE SEGMENT24_TYPE, SEGMENT25_TYPE SEGMENT25_TYPE, SEGMENT26_TYPE SEGMENT26_TYPE, SEGMENT27_TYPE SEGMENT27_TYPE, SEGMENT28_TYPE SEGMENT28_TYPE, SEGMENT29_TYPE SEGMENT29_TYPE, SEGMENT30_TYPE SEGMENT30_TYPE, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15 from "RG"."RG_DSS_VARIABLES"

View Text - HTML Formatted

SELECT VARIABLE_ID VARIABLE_ID
, NAME NAME
, LEDGER_ID LEDGER_ID
, BALANCE_TYPE BALANCE_TYPE
, CURRENCY_TYPE CURRENCY_TYPE
, LEVEL_CODE LEVEL_CODE
, STATUS_CODE STATUS_CODE
, OBJECT_NAME OBJECT_NAME
, COLUMN_LABEL COLUMN_LABEL
, ID_FLEX_CODE ID_FLEX_CODE
, ID_FLEX_NUM ID_FLEX_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CURRENCY_CODE CURRENCY_CODE
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, DESCRIPTION DESCRIPTION
, SEGMENT1_TYPE SEGMENT1_TYPE
, SEGMENT2_TYPE SEGMENT2_TYPE
, SEGMENT3_TYPE SEGMENT3_TYPE
, SEGMENT4_TYPE SEGMENT4_TYPE
, SEGMENT5_TYPE SEGMENT5_TYPE
, SEGMENT6_TYPE SEGMENT6_TYPE
, SEGMENT7_TYPE SEGMENT7_TYPE
, SEGMENT8_TYPE SEGMENT8_TYPE
, SEGMENT9_TYPE SEGMENT9_TYPE
, SEGMENT10_TYPE SEGMENT10_TYPE
, SEGMENT11_TYPE SEGMENT11_TYPE
, SEGMENT12_TYPE SEGMENT12_TYPE
, SEGMENT13_TYPE SEGMENT13_TYPE
, SEGMENT14_TYPE SEGMENT14_TYPE
, SEGMENT15_TYPE SEGMENT15_TYPE
, SEGMENT16_TYPE SEGMENT16_TYPE
, SEGMENT17_TYPE SEGMENT17_TYPE
, SEGMENT18_TYPE SEGMENT18_TYPE
, SEGMENT19_TYPE SEGMENT19_TYPE
, SEGMENT20_TYPE SEGMENT20_TYPE
, SEGMENT21_TYPE SEGMENT21_TYPE
, SEGMENT22_TYPE SEGMENT22_TYPE
, SEGMENT23_TYPE SEGMENT23_TYPE
, SEGMENT24_TYPE SEGMENT24_TYPE
, SEGMENT25_TYPE SEGMENT25_TYPE
, SEGMENT26_TYPE SEGMENT26_TYPE
, SEGMENT27_TYPE SEGMENT27_TYPE
, SEGMENT28_TYPE SEGMENT28_TYPE
, SEGMENT29_TYPE SEGMENT29_TYPE
, SEGMENT30_TYPE SEGMENT30_TYPE
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
FROM "RG"."RG_DSS_VARIABLES"