VIEW: APPS.GL_BUDGET_ASSIGNMENT_RANGES_V

Source

View Text - Preformatted

SELECT BAR.ROWID ROW_ID , BAR.LEDGER_ID LEDGER_ID , BAR.BUDGET_ENTITY_ID BUDGET_ENTITY_ID , BAR.RANGE_ID RANGE_ID , BAR.SEQUENCE_NUMBER SEQUENCE_NUMBER , BAR.CURRENCY_CODE CURRENCY_CODE , BAR.ENTRY_CODE ENTRY_CODE , BAR.STATUS STATUS , L3.MEANING SHOW_STATUS , BAR.SEGMENT1_LOW SEGMENT1_LOW , BAR.SEGMENT2_LOW SEGMENT2_LOW , BAR.SEGMENT3_LOW SEGMENT3_LOW , BAR.SEGMENT4_LOW SEGMENT4_LOW , BAR.SEGMENT5_LOW SEGMENT5_LOW , BAR.SEGMENT6_LOW SEGMENT6_LOW , BAR.SEGMENT7_LOW SEGMENT7_LOW , BAR.SEGMENT8_LOW SEGMENT8_LOW , BAR.SEGMENT9_LOW SEGMENT9_LOW , BAR.SEGMENT10_LOW SEGMENT10_LOW , BAR.SEGMENT11_LOW SEGMENT11_LOW , BAR.SEGMENT12_LOW SEGMENT12_LOW , BAR.SEGMENT13_LOW SEGMENT13_LOW , BAR.SEGMENT14_LOW SEGMENT14_LOW , BAR.SEGMENT15_LOW SEGMENT15_LOW , BAR.SEGMENT16_LOW SEGMENT16_LOW , BAR.SEGMENT17_LOW SEGMENT17_LOW , BAR.SEGMENT18_LOW SEGMENT18_LOW , BAR.SEGMENT19_LOW SEGMENT19_LOW , BAR.SEGMENT20_LOW SEGMENT20_LOW , BAR.SEGMENT21_LOW SEGMENT21_LOW , BAR.SEGMENT22_LOW SEGMENT22_LOW , BAR.SEGMENT23_LOW SEGMENT23_LOW , BAR.SEGMENT24_LOW SEGMENT24_LOW , BAR.SEGMENT25_LOW SEGMENT25_LOW , BAR.SEGMENT26_LOW SEGMENT26_LOW , BAR.SEGMENT27_LOW SEGMENT27_LOW , BAR.SEGMENT28_LOW SEGMENT28_LOW , BAR.SEGMENT29_LOW SEGMENT29_LOW , BAR.SEGMENT30_LOW SEGMENT30_LOW , BAR.SEGMENT1_HIGH SEGMENT1_HIGH , BAR.SEGMENT2_HIGH SEGMENT2_HIGH , BAR.SEGMENT3_HIGH SEGMENT3_HIGH , BAR.SEGMENT4_HIGH SEGMENT4_HIGH , BAR.SEGMENT5_HIGH SEGMENT5_HIGH , BAR.SEGMENT6_HIGH SEGMENT6_HIGH , BAR.SEGMENT7_HIGH SEGMENT7_HIGH , BAR.SEGMENT8_HIGH SEGMENT8_HIGH , BAR.SEGMENT9_HIGH SEGMENT9_HIGH , BAR.SEGMENT10_HIGH SEGMENT10_HIGH , BAR.SEGMENT11_HIGH SEGMENT11_HIGH , BAR.SEGMENT12_HIGH SEGMENT12_HIGH , BAR.SEGMENT13_HIGH SEGMENT13_HIGH , BAR.SEGMENT14_HIGH SEGMENT14_HIGH , BAR.SEGMENT15_HIGH SEGMENT15_HIGH , BAR.SEGMENT16_HIGH SEGMENT16_HIGH , BAR.SEGMENT17_HIGH SEGMENT17_HIGH , BAR.SEGMENT18_HIGH SEGMENT18_HIGH , BAR.SEGMENT19_HIGH SEGMENT19_HIGH , BAR.SEGMENT20_HIGH SEGMENT20_HIGH , BAR.SEGMENT21_HIGH SEGMENT21_HIGH , BAR.SEGMENT22_HIGH SEGMENT22_HIGH , BAR.SEGMENT23_HIGH SEGMENT23_HIGH , BAR.SEGMENT24_HIGH SEGMENT24_HIGH , BAR.SEGMENT25_HIGH SEGMENT25_HIGH , BAR.SEGMENT26_HIGH SEGMENT26_HIGH , BAR.SEGMENT27_HIGH SEGMENT27_HIGH , BAR.SEGMENT28_HIGH SEGMENT28_HIGH , BAR.SEGMENT29_HIGH SEGMENT29_HIGH , BAR.SEGMENT30_HIGH SEGMENT30_HIGH , BAR.CONTEXT CONTEXT , BAR.ATTRIBUTE1 ATTRIBUTE1 , BAR.ATTRIBUTE2 ATTRIBUTE2 , BAR.ATTRIBUTE3 ATTRIBUTE3 , BAR.ATTRIBUTE4 ATTRIBUTE4 , BAR.ATTRIBUTE5 ATTRIBUTE5 , BAR.ATTRIBUTE6 ATTRIBUTE6 , BAR.ATTRIBUTE7 ATTRIBUTE7 , BAR.ATTRIBUTE8 ATTRIBUTE8 , BAR.ATTRIBUTE9 ATTRIBUTE9 , BAR.ATTRIBUTE10 ATTRIBUTE10 , BAR.ATTRIBUTE11 ATTRIBUTE11 , BAR.ATTRIBUTE12 ATTRIBUTE12 , BAR.ATTRIBUTE13 ATTRIBUTE13 , BAR.ATTRIBUTE14 ATTRIBUTE14 , BAR.ATTRIBUTE15 ATTRIBUTE15 , BAR.CREATION_DATE CREATION_DATE , BAR.CREATED_BY CREATED_BY , BAR.LAST_UPDATE_DATE LAST_UPDATE_DATE , BAR.LAST_UPDATED_BY LAST_UPDATED_BY , BAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , BAR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID , BAR.PROGRAM_ID PROGRAM_ID , BAR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE , BAR.REQUEST_ID REQUEST_ID FROM GL_BUDGET_ASSIGNMENT_RANGES BAR, GL_LOOKUPS L3 WHERE L3.LOOKUP_TYPE(+) = 'GLBAAR_STATUSES' AND L3.LOOKUP_CODE(+) = BAR.STATUS

View Text - HTML Formatted

SELECT BAR.ROWID ROW_ID
, BAR.LEDGER_ID LEDGER_ID
, BAR.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BAR.RANGE_ID RANGE_ID
, BAR.SEQUENCE_NUMBER SEQUENCE_NUMBER
, BAR.CURRENCY_CODE CURRENCY_CODE
, BAR.ENTRY_CODE ENTRY_CODE
, BAR.STATUS STATUS
, L3.MEANING SHOW_STATUS
, BAR.SEGMENT1_LOW SEGMENT1_LOW
, BAR.SEGMENT2_LOW SEGMENT2_LOW
, BAR.SEGMENT3_LOW SEGMENT3_LOW
, BAR.SEGMENT4_LOW SEGMENT4_LOW
, BAR.SEGMENT5_LOW SEGMENT5_LOW
, BAR.SEGMENT6_LOW SEGMENT6_LOW
, BAR.SEGMENT7_LOW SEGMENT7_LOW
, BAR.SEGMENT8_LOW SEGMENT8_LOW
, BAR.SEGMENT9_LOW SEGMENT9_LOW
, BAR.SEGMENT10_LOW SEGMENT10_LOW
, BAR.SEGMENT11_LOW SEGMENT11_LOW
, BAR.SEGMENT12_LOW SEGMENT12_LOW
, BAR.SEGMENT13_LOW SEGMENT13_LOW
, BAR.SEGMENT14_LOW SEGMENT14_LOW
, BAR.SEGMENT15_LOW SEGMENT15_LOW
, BAR.SEGMENT16_LOW SEGMENT16_LOW
, BAR.SEGMENT17_LOW SEGMENT17_LOW
, BAR.SEGMENT18_LOW SEGMENT18_LOW
, BAR.SEGMENT19_LOW SEGMENT19_LOW
, BAR.SEGMENT20_LOW SEGMENT20_LOW
, BAR.SEGMENT21_LOW SEGMENT21_LOW
, BAR.SEGMENT22_LOW SEGMENT22_LOW
, BAR.SEGMENT23_LOW SEGMENT23_LOW
, BAR.SEGMENT24_LOW SEGMENT24_LOW
, BAR.SEGMENT25_LOW SEGMENT25_LOW
, BAR.SEGMENT26_LOW SEGMENT26_LOW
, BAR.SEGMENT27_LOW SEGMENT27_LOW
, BAR.SEGMENT28_LOW SEGMENT28_LOW
, BAR.SEGMENT29_LOW SEGMENT29_LOW
, BAR.SEGMENT30_LOW SEGMENT30_LOW
, BAR.SEGMENT1_HIGH SEGMENT1_HIGH
, BAR.SEGMENT2_HIGH SEGMENT2_HIGH
, BAR.SEGMENT3_HIGH SEGMENT3_HIGH
, BAR.SEGMENT4_HIGH SEGMENT4_HIGH
, BAR.SEGMENT5_HIGH SEGMENT5_HIGH
, BAR.SEGMENT6_HIGH SEGMENT6_HIGH
, BAR.SEGMENT7_HIGH SEGMENT7_HIGH
, BAR.SEGMENT8_HIGH SEGMENT8_HIGH
, BAR.SEGMENT9_HIGH SEGMENT9_HIGH
, BAR.SEGMENT10_HIGH SEGMENT10_HIGH
, BAR.SEGMENT11_HIGH SEGMENT11_HIGH
, BAR.SEGMENT12_HIGH SEGMENT12_HIGH
, BAR.SEGMENT13_HIGH SEGMENT13_HIGH
, BAR.SEGMENT14_HIGH SEGMENT14_HIGH
, BAR.SEGMENT15_HIGH SEGMENT15_HIGH
, BAR.SEGMENT16_HIGH SEGMENT16_HIGH
, BAR.SEGMENT17_HIGH SEGMENT17_HIGH
, BAR.SEGMENT18_HIGH SEGMENT18_HIGH
, BAR.SEGMENT19_HIGH SEGMENT19_HIGH
, BAR.SEGMENT20_HIGH SEGMENT20_HIGH
, BAR.SEGMENT21_HIGH SEGMENT21_HIGH
, BAR.SEGMENT22_HIGH SEGMENT22_HIGH
, BAR.SEGMENT23_HIGH SEGMENT23_HIGH
, BAR.SEGMENT24_HIGH SEGMENT24_HIGH
, BAR.SEGMENT25_HIGH SEGMENT25_HIGH
, BAR.SEGMENT26_HIGH SEGMENT26_HIGH
, BAR.SEGMENT27_HIGH SEGMENT27_HIGH
, BAR.SEGMENT28_HIGH SEGMENT28_HIGH
, BAR.SEGMENT29_HIGH SEGMENT29_HIGH
, BAR.SEGMENT30_HIGH SEGMENT30_HIGH
, BAR.CONTEXT CONTEXT
, BAR.ATTRIBUTE1 ATTRIBUTE1
, BAR.ATTRIBUTE2 ATTRIBUTE2
, BAR.ATTRIBUTE3 ATTRIBUTE3
, BAR.ATTRIBUTE4 ATTRIBUTE4
, BAR.ATTRIBUTE5 ATTRIBUTE5
, BAR.ATTRIBUTE6 ATTRIBUTE6
, BAR.ATTRIBUTE7 ATTRIBUTE7
, BAR.ATTRIBUTE8 ATTRIBUTE8
, BAR.ATTRIBUTE9 ATTRIBUTE9
, BAR.ATTRIBUTE10 ATTRIBUTE10
, BAR.ATTRIBUTE11 ATTRIBUTE11
, BAR.ATTRIBUTE12 ATTRIBUTE12
, BAR.ATTRIBUTE13 ATTRIBUTE13
, BAR.ATTRIBUTE14 ATTRIBUTE14
, BAR.ATTRIBUTE15 ATTRIBUTE15
, BAR.CREATION_DATE CREATION_DATE
, BAR.CREATED_BY CREATED_BY
, BAR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BAR.LAST_UPDATED_BY LAST_UPDATED_BY
, BAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BAR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BAR.PROGRAM_ID PROGRAM_ID
, BAR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BAR.REQUEST_ID REQUEST_ID
FROM GL_BUDGET_ASSIGNMENT_RANGES BAR
, GL_LOOKUPS L3
WHERE L3.LOOKUP_TYPE(+) = 'GLBAAR_STATUSES'
AND L3.LOOKUP_CODE(+) = BAR.STATUS