Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: |
![]() |
SELECT BA.ROWID ROW_ID
, BA.LEDGER_ID LEDGER_ID
, BA.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BA.RANGE_ID RANGE_ID
, BA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, BA.ENTRY_CODE ENTRY_CODE
, BA.ORDERING_VALUE ORDERING_VALUE
, BA.CREATION_DATE CREATION_DATE
, BA.CREATED_BY CREATED_BY
, BA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BA.LAST_UPDATED_BY LAST_UPDATED_BY
, BA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BA.PROGRAM_ID PROGRAM_ID
, BA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BA.REQUEST_ID REQUEST_ID
, BA.CONTEXT CONTEXT
, BA.ATTRIBUTE1 ATTRIBUTE1
, BA.ATTRIBUTE2 ATTRIBUTE2
, BA.ATTRIBUTE3 ATTRIBUTE3
, BA.ATTRIBUTE4 ATTRIBUTE4
, BA.ATTRIBUTE5 ATTRIBUTE5
, BA.ATTRIBUTE6 ATTRIBUTE6
, BA.ATTRIBUTE7 ATTRIBUTE7
, BA.ATTRIBUTE8 ATTRIBUTE8
, CC.SEGMENT1 SEGMENT1
, CC.SEGMENT2 SEGMENT2
, CC.SEGMENT3 SEGMENT3
, CC.SEGMENT4 SEGMENT4
, CC.SEGMENT5 SEGMENT5
, CC.SEGMENT6 SEGMENT6
, CC.SEGMENT7 SEGMENT7
, CC.SEGMENT8 SEGMENT8
, CC.SEGMENT9 SEGMENT9
, CC.SEGMENT10 SEGMENT10
, CC.SEGMENT11 SEGMENT11
, CC.SEGMENT12 SEGMENT12
, CC.SEGMENT13 SEGMENT13
, CC.SEGMENT14 SEGMENT14
, CC.SEGMENT15 SEGMENT15
, CC.SEGMENT16 SEGMENT16
, CC.SEGMENT17 SEGMENT17
, CC.SEGMENT18 SEGMENT18
, CC.SEGMENT19 SEGMENT19
, CC.SEGMENT20 SEGMENT20
, CC.SEGMENT21 SEGMENT21
, CC.SEGMENT22 SEGMENT22
, CC.SEGMENT23 SEGMENT23
, CC.SEGMENT24 SEGMENT24
, CC.SEGMENT25 SEGMENT25
, CC.SEGMENT26 SEGMENT26
, CC.SEGMENT27 SEGMENT27
, CC.SEGMENT28 SEGMENT28
, CC.SEGMENT29 SEGMENT29
, CC.SEGMENT30 SEGMENT30
FROM GL_BUDGET_ASSIGNMENTS BA
, GL_CODE_COMBINATIONS CC
WHERE CC.CODE_COMBINATION_ID = BA.CODE_COMBINATION_ID