1. Tables and Views for Financials
  2. GL_OFSAA_BALANCES_DELTA_V

GL_OFSAA_BALANCES_DELTA_V

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: VIEW

Columns

Name

DELTA_RUN_ID

PERIOD_NAME

LEDGER_NAME

SHORT_NAME

BALANCE_TYPE

ENTERED_CURRENCY_CODE

CHART_OF_ACCOUNTS_ID

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

PERIOD_NET_ENTERED

PERIOD_NET

BEGIN_BALANCE

BEGIN_BALANCE_ENTERED

Query

SQL_Statement

select

glb.delta_run_id delta_run_id,

glb.period_name period_name,

ledgers.name ledger_name,

ledgers.short_name short_name,

glb.actual_flag balance_type,

glb.currency_code entered_currency_code,

ledgers.chart_of_accounts_id chart_of_accounts_id,

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,

decode(cc.account_type,

'A', glb.period_net_dr - glb.period_net_cr,

'E', glb.period_net_dr - glb.period_net_cr,

glb.period_net_cr - glb.period_net_dr) period_net_entered,

decode(cc.account_type,

'A', decode(glb.translated_flag, null, glb.period_net_dr, glb.period_net_dr_beq) - decode(glb.translated_flag, null, glb.period_net_cr, glb.period_net_cr_beq),

'E', decode(glb.translated_flag, null, glb.period_net_dr, glb.period_net_dr_beq) - decode(glb.translated_flag, null, glb.period_net_cr, glb.period_net_cr_beq),

decode(glb.translated_flag, null, glb.period_net_cr, glb.period_net_cr_beq) - decode(glb.translated_flag, null, glb.period_net_dr, glb.period_net_dr_beq)) period_net,

decode(cc.account_type,

'A', decode(glb.translated_flag, null, glb.begin_balance_dr, glb.begin_balance_dr_beq) - decode(glb.translated_flag, null, glb.begin_balance_cr, glb.begin_balance_cr_beq),

'E', decode(glb.translated_flag, null, glb.begin_balance_dr, glb.begin_balance_dr_beq) - decode(glb.translated_flag, null, glb.begin_balance_cr, glb.begin_balance_cr_beq),

decode(glb.translated_flag, null, glb.begin_balance_cr, glb.begin_balance_cr_beq) - decode(glb.translated_flag, null, glb.begin_balance_dr, glb.begin_balance_dr_beq)) begin_balance,

decode(cc.account_type,

'A', glb.begin_balance_dr - glb.begin_balance_cr,

'E', glb.begin_balance_dr - glb.begin_balance_cr,

glb.begin_balance_cr - glb.begin_balance_dr) begin_balance_entered

from

gl_balances_delta glb,

gl_ledgers ledgers,

gl_code_combinations cc

where ledgers.ledger_id = glb.ledger_id

and cc.code_combination_id = glb.code_combination_id

and nvl(glb.translated_flag, 'R') = 'R'

and glb.actual_flag = 'A'