Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_BUDGET_ASSIGNMENT_RANGES_V |
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