XLA_OFSAA_BALANCES

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
CREATION_DATE CREATED_BY PERIOD_NAME LEDGER_NAME LEDGER_ID CURRENCY_CODE COA_SEGMENT1 COA_SEGMENT2 COA_SEGMENT3 COA_SEGMENT4 COA_SEGMENT5 COA_SEGMENT6 COA_SEGMENT7 COA_SEGMENT8 COA_SEGMENT9 COA_SEGMENT10 COA_SEGMENT11 COA_SEGMENT12 COA_SEGMENT13 COA_SEGMENT14 COA_SEGMENT15 COA_SEGMENT16 COA_SEGMENT17 COA_SEGMENT18 COA_SEGMENT19 COA_SEGMENT20 COA_SEGMENT21 COA_SEGMENT22 COA_SEGMENT23 COA_SEGMENT24 COA_SEGMENT25 COA_SEGMENT26 COA_SEGMENT27 COA_SEGMENT28 COA_SEGMENT29 COA_SEGMENT30 SUP_REF_CODE1 SUP_REF_CODE2 SUP_REF_CODE3 SUP_REF_CODE4 SUP_REF_CODE5 SUP_REF_CODE6 SUP_REF_CODE7 SUP_REF_CODE8 SUP_REF_CODE9 SUP_REF_CODE10 SUP_REF_CODE11 SUP_REF_CODE12 SUP_REF_CODE13 SUP_REF_CODE14 SUP_REF_CODE15 SUP_REF_CODE16 SUP_REF_CODE17 SUP_REF_CODE18 SUP_REF_CODE19 SUP_REF_CODE20 SUP_REF_CODE21 SUP_REF_CODE22 SUP_REF_CODE23 SUP_REF_CODE24 SUP_REF_CODE25 SUP_REF_CODE26 SUP_REF_CODE27 SUP_REF_CODE28 SUP_REF_CODE29 SUP_REF_CODE30 SR1 SR2 SR3 SR4 SR5 SR6 SR7 SR8 SR9 SR10 SR11 SR12 SR13 SR14 SR15 SR16 SR17 SR18 SR19 SR20 SR21 SR22 SR23 SR24 SR25 SR26 SR27 SR28 SR29 SR30 BEGINNING_BALANCE_DR BEGINNING_BALANCE_CR PERIOD_ENTERED_BALANCE_DR PERIOD_ENTERED_BALANCE_CR PERIOD_BALANCE_DR PERIOD_BALANCE_CR ENTERED_CURRENCY_CODE

Name

CREATION_DATE

CREATED_BY

PERIOD_NAME

LEDGER_NAME

LEDGER_ID

CURRENCY_CODE

COA_SEGMENT1

COA_SEGMENT2

COA_SEGMENT3

COA_SEGMENT4

COA_SEGMENT5

COA_SEGMENT6

COA_SEGMENT7

COA_SEGMENT8

COA_SEGMENT9

COA_SEGMENT10

COA_SEGMENT11

COA_SEGMENT12

COA_SEGMENT13

COA_SEGMENT14

COA_SEGMENT15

COA_SEGMENT16

COA_SEGMENT17

COA_SEGMENT18

COA_SEGMENT19

COA_SEGMENT20

COA_SEGMENT21

COA_SEGMENT22

COA_SEGMENT23

COA_SEGMENT24

COA_SEGMENT25

COA_SEGMENT26

COA_SEGMENT27

COA_SEGMENT28

COA_SEGMENT29

COA_SEGMENT30

SUP_REF_CODE1

SUP_REF_CODE2

SUP_REF_CODE3

SUP_REF_CODE4

SUP_REF_CODE5

SUP_REF_CODE6

SUP_REF_CODE7

SUP_REF_CODE8

SUP_REF_CODE9

SUP_REF_CODE10

SUP_REF_CODE11

SUP_REF_CODE12

SUP_REF_CODE13

SUP_REF_CODE14

SUP_REF_CODE15

SUP_REF_CODE16

SUP_REF_CODE17

SUP_REF_CODE18

SUP_REF_CODE19

SUP_REF_CODE20

SUP_REF_CODE21

SUP_REF_CODE22

SUP_REF_CODE23

SUP_REF_CODE24

SUP_REF_CODE25

SUP_REF_CODE26

SUP_REF_CODE27

SUP_REF_CODE28

SUP_REF_CODE29

SUP_REF_CODE30

SR1

SR2

SR3

SR4

SR5

SR6

SR7

SR8

SR9

SR10

SR11

SR12

SR13

SR14

SR15

SR16

SR17

SR18

SR19

SR20

SR21

SR22

SR23

SR24

SR25

SR26

SR27

SR28

SR29

SR30

BEGINNING_BALANCE_DR

BEGINNING_BALANCE_CR

PERIOD_ENTERED_BALANCE_DR

PERIOD_ENTERED_BALANCE_CR

PERIOD_BALANCE_DR

PERIOD_BALANCE_CR

ENTERED_CURRENCY_CODE

Query

SQL_Statement
select b.creation_date creation_date, b.created_by created_by, b.period_name period_name, ledgers.name ledger_name, b.ledger_id ledger_id, ledgers.currency_code currency_code, cc.segment1 coa_segment1, cc.segment2 coa_segment2, cc.segment3 coa_segment3, cc.segment4 coa_segment4, cc.segment5 coa_segment5, cc.segment6 coa_segment6, cc.segment7 coa_segment7, cc.segment8 coa_segment8, cc.segment9 coa_segment9, cc.segment10 coa_segment10, cc.segment11 coa_segment11, cc.segment12 coa_segment12, cc.segment13 coa_segment13, cc.segment14 coa_segment14, cc.segment15 coa_segment15, cc.segment16 coa_segment16, cc.segment17 coa_segment17, cc.segment18 coa_segment18, cc.segment19 coa_segment19, cc.segment20 coa_segment20, cc.segment21 coa_segment21, cc.segment22 coa_segment22, cc.segment23 coa_segment23, cc.segment24 coa_segment24, cc.segment25 coa_segment25, cc.segment26 coa_segment26, cc.segment27 coa_segment27, cc.segment28 coa_segment28, cc.segment29 coa_segment29, cc.segment30 coa_segment30, xlacc.sup_ref_code1 sup_ref_code1, xlacc.sup_ref_code2 sup_ref_code2, xlacc.sup_ref_code3 sup_ref_code3, xlacc.sup_ref_code4 sup_ref_code4, xlacc.sup_ref_code5 sup_ref_code5, xlacc.sup_ref_code6 sup_ref_code6, xlacc.sup_ref_code7 sup_ref_code7, xlacc.sup_ref_code8 sup_ref_code8, xlacc.sup_ref_code9 sup_ref_code9, xlacc.sup_ref_code10 sup_ref_code10, xlacc.sup_ref_code11 sup_ref_code11, xlacc.sup_ref_code12 sup_ref_code12, xlacc.sup_ref_code13 sup_ref_code13, xlacc.sup_ref_code14 sup_ref_code14, xlacc.sup_ref_code15 sup_ref_code15, xlacc.sup_ref_code16 sup_ref_code16, xlacc.sup_ref_code17 sup_ref_code17, xlacc.sup_ref_code18 sup_ref_code18, xlacc.sup_ref_code19 sup_ref_code19, xlacc.sup_ref_code20 sup_ref_code20, xlacc.sup_ref_code21 sup_ref_code21, xlacc.sup_ref_code22 sup_ref_code22, xlacc.sup_ref_code23 sup_ref_code23, xlacc.sup_ref_code24 sup_ref_code24, xlacc.sup_ref_code25 sup_ref_code25, xlacc.sup_ref_code26 sup_ref_code26, xlacc.sup_ref_code27 sup_ref_code27, xlacc.sup_ref_code28 sup_ref_code28, xlacc.sup_ref_code29 sup_ref_code29, xlacc.sup_ref_code30 sup_ref_code30, b.sr1 sr1, b.sr2 sr2, b.sr3 sr3, b.sr4 sr4, b.sr5 sr5, b.sr6 sr6, b.sr7 sr7, b.sr8 sr8, b.sr9 sr9, b.sr10 sr10, b.sr11 sr11, b.sr12 sr12, b.sr13 sr13, b.sr14 sr14, b.sr15 sr15, b.sr16 sr16, b.sr17 sr17, b.sr18 sr18, b.sr19 sr19, b.sr20 sr20, b.sr21 sr21, b.sr22 sr22, b.sr23 sr23, b.sr24 sr24, b.sr25 sr25, b.sr26 sr26, b.sr27 sr27, b.sr28 sr28, b.sr29 sr29, b.sr30 sr30, b.beginning_balance_dr beginning_balance_dr, b.beginning_balance_cr beginning_balance_cr, b.period_entered_balance_dr period_entered_balance_dr, b.period_entered_balance_cr period_entered_balance_cr, b.period_balance_dr period_balance_dr, b.period_balance_cr period_balance_cr, b.entered_currency_code entered_currency_code from xla_ac_balances b, gl_ledgers ledgers, gl_code_combinations cc, xla_sup_ref_combinations xlacc where ledgers.ledger_id = b.ledger_id and cc.code_combination_id = b.code_combination_id and xlacc.supp_ref_combination_id = b.supp_ref_combination_id

SQL_Statement

select

b.creation_date creation_date,

b.created_by created_by,

b.period_name period_name,

ledgers.name ledger_name,

b.ledger_id ledger_id,

ledgers.currency_code currency_code,

cc.segment1 coa_segment1,

cc.segment2 coa_segment2,

cc.segment3 coa_segment3,

cc.segment4 coa_segment4,

cc.segment5 coa_segment5,

cc.segment6 coa_segment6,

cc.segment7 coa_segment7,

cc.segment8 coa_segment8,

cc.segment9 coa_segment9,

cc.segment10 coa_segment10,

cc.segment11 coa_segment11,

cc.segment12 coa_segment12,

cc.segment13 coa_segment13,

cc.segment14 coa_segment14,

cc.segment15 coa_segment15,

cc.segment16 coa_segment16,

cc.segment17 coa_segment17,

cc.segment18 coa_segment18,

cc.segment19 coa_segment19,

cc.segment20 coa_segment20,

cc.segment21 coa_segment21,

cc.segment22 coa_segment22,

cc.segment23 coa_segment23,

cc.segment24 coa_segment24,

cc.segment25 coa_segment25,

cc.segment26 coa_segment26,

cc.segment27 coa_segment27,

cc.segment28 coa_segment28,

cc.segment29 coa_segment29,

cc.segment30 coa_segment30,

xlacc.sup_ref_code1 sup_ref_code1,

xlacc.sup_ref_code2 sup_ref_code2,

xlacc.sup_ref_code3 sup_ref_code3,

xlacc.sup_ref_code4 sup_ref_code4,

xlacc.sup_ref_code5 sup_ref_code5,

xlacc.sup_ref_code6 sup_ref_code6,

xlacc.sup_ref_code7 sup_ref_code7,

xlacc.sup_ref_code8 sup_ref_code8,

xlacc.sup_ref_code9 sup_ref_code9,

xlacc.sup_ref_code10 sup_ref_code10,

xlacc.sup_ref_code11 sup_ref_code11,

xlacc.sup_ref_code12 sup_ref_code12,

xlacc.sup_ref_code13 sup_ref_code13,

xlacc.sup_ref_code14 sup_ref_code14,

xlacc.sup_ref_code15 sup_ref_code15,

xlacc.sup_ref_code16 sup_ref_code16,

xlacc.sup_ref_code17 sup_ref_code17,

xlacc.sup_ref_code18 sup_ref_code18,

xlacc.sup_ref_code19 sup_ref_code19,

xlacc.sup_ref_code20 sup_ref_code20,

xlacc.sup_ref_code21 sup_ref_code21,

xlacc.sup_ref_code22 sup_ref_code22,

xlacc.sup_ref_code23 sup_ref_code23,

xlacc.sup_ref_code24 sup_ref_code24,

xlacc.sup_ref_code25 sup_ref_code25,

xlacc.sup_ref_code26 sup_ref_code26,

xlacc.sup_ref_code27 sup_ref_code27,

xlacc.sup_ref_code28 sup_ref_code28,

xlacc.sup_ref_code29 sup_ref_code29,

xlacc.sup_ref_code30 sup_ref_code30,

b.sr1 sr1,

b.sr2 sr2,

b.sr3 sr3,

b.sr4 sr4,

b.sr5 sr5,

b.sr6 sr6,

b.sr7 sr7,

b.sr8 sr8,

b.sr9 sr9,

b.sr10 sr10,

b.sr11 sr11,

b.sr12 sr12,

b.sr13 sr13,

b.sr14 sr14,

b.sr15 sr15,

b.sr16 sr16,

b.sr17 sr17,

b.sr18 sr18,

b.sr19 sr19,

b.sr20 sr20,

b.sr21 sr21,

b.sr22 sr22,

b.sr23 sr23,

b.sr24 sr24,

b.sr25 sr25,

b.sr26 sr26,

b.sr27 sr27,

b.sr28 sr28,

b.sr29 sr29,

b.sr30 sr30,

b.beginning_balance_dr beginning_balance_dr,

b.beginning_balance_cr beginning_balance_cr,

b.period_entered_balance_dr period_entered_balance_dr,

b.period_entered_balance_cr period_entered_balance_cr,

b.period_balance_dr period_balance_dr,

b.period_balance_cr period_balance_cr,

b.entered_currency_code entered_currency_code

from

xla_ac_balances b,

gl_ledgers ledgers,

gl_code_combinations cc,

xla_sup_ref_combinations xlacc

where ledgers.ledger_id = b.ledger_id

and cc.code_combination_id = b.code_combination_id

and xlacc.supp_ref_combination_id = b.supp_ref_combination_id