SELECT LEDGER_ID
, LEGAL_ENTITY_ID
, COMPANY_SEGMENT
, PERIOD_NAME
, CURRENCY_CODE
, COST_CENTER
, THIRD_PARTY_TYPE
, THIRD_PARTY_ID
, THIRD_PARTY_NUMBER
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_SOURCE
, ACCOUNT_SEGMENT
, PERSONNEL_ID
, PERSONNEL_NUMBER
, FUNC_BEGIN_BALANCE_DR
, FUNC_BEGIN_BALANCE_CR
, ORIG_BEGIN_BALANCE_DR
, ORIG_BEGIN_BALANCE_CR
, FUNC_PERIOD_NET_DR
, FUNC_PERIOD_NET_CR
, ORIG_PERIOD_NET_DR
, ORIG_PERIOD_NET_CR
, PERIOD_MON
, account_type
, decode(account_type,'A',nvl(FUNC_BEGIN_BALANCE_DR,0)-nvl(FUNC_BEGIN_BALANCE_CR,0)
,'E',nvl(FUNC_BEGIN_BALANCE_DR,0)-nvl(FUNC_BEGIN_BALANCE_CR,0)
,nvl(FUNC_BEGIN_BALANCE_CR,0)-nvl(FUNC_BEGIN_BALANCE_DR,0)
) func_begin_balance
, decode(account_type,'A',nvl(ORIG_BEGIN_BALANCE_DR,0)-nvl(ORIG_BEGIN_BALANCE_cR,0)
,'E',nvl(ORIG_BEGIN_BALANCE_DR,0)-nvl(ORIG_BEGIN_BALANCE_cR,0)
,nvl(FUNC_BEGIN_BALANCE_CR,0)-nvl(FUNC_BEGIN_BALANCE_DR,0)
) orig_begin_balance
, nvl(FUNC_BEGIN_BALANCE_DR,0) + nvl(FUNC_PERIOD_NET_DR,0) func_end_balance_dr
, nvl(FUNC_BEGIN_BALANCE_cR,0) + nvl(FUNC_PERIOD_NET_cR,0) func_end_balance_cr
, nvl(ORIG_BEGIN_BALANCE_DR,0) + nvl(ORIG_PERIOD_NET_DR,0) ORIG_end_balance_dr
, nvl(ORIG_BEGIN_BALANCE_cR,0) + nvl(ORIG_PERIOD_NET_cR,0) ORIG_end_balance_cr
, decode(account_type,'A',nvl(FUNC_BEGIN_BALANCE_DR,0) + nvl(FUNC_PERIOD_NET_DR,0) -
(nvl(FUNC_BEGIN_BALANCE_cR,0) + nvl(FUNC_PERIOD_NET_cR,0))
,'E',nvl(FUNC_BEGIN_BALANCE_DR,0) + nvl(FUNC_PERIOD_NET_DR,0) -
(nvl(FUNC_BEGIN_BALANCE_cR,0) + nvl(FUNC_PERIOD_NET_cR,0))
,nvl(FUNC_BEGIN_BALANCE_cR,0) + nvl(FUNC_PERIOD_NET_cR,0) -
(nvl(FUNC_BEGIN_BALANCE_DR,0) + nvl(FUNC_PERIOD_NET_DR,0))
) func_end_balance
, decode(account_type,'A',nvl(ORIG_BEGIN_BALANCE_DR,0) + nvl(ORIG_PERIOD_NET_DR,0) -
(nvl(ORIG_BEGIN_BALANCE_cR,0) + nvl(ORIG_PERIOD_NET_cR,0))
,'E',nvl(ORIG_BEGIN_BALANCE_DR,0) + nvl(ORIG_PERIOD_NET_DR,0) -
(nvl(ORIG_BEGIN_BALANCE_cR,0) + nvl(ORIG_PERIOD_NET_cR,0))
,nvl(ORIG_BEGIN_BALANCE_cR,0) + nvl(ORIG_PERIOD_NET_cR,0) -
(nvl(ORIG_BEGIN_BALANCE_DR,0) + nvl(ORIG_PERIOD_NET_DR,0))
) orig_end_balance
FROM ja_cn_account_balances
SELECT LEDGER_ID
, LEGAL_ENTITY_ID
, COMPANY_SEGMENT
, PERIOD_NAME
, CURRENCY_CODE
, COST_CENTER
, THIRD_PARTY_TYPE
, THIRD_PARTY_ID
, THIRD_PARTY_NUMBER
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_SOURCE
, ACCOUNT_SEGMENT
, PERSONNEL_ID
, PERSONNEL_NUMBER
, FUNC_BEGIN_BALANCE_DR
, FUNC_BEGIN_BALANCE_CR
, ORIG_BEGIN_BALANCE_DR
, ORIG_BEGIN_BALANCE_CR
, FUNC_PERIOD_NET_DR
, FUNC_PERIOD_NET_CR
, ORIG_PERIOD_NET_DR
, ORIG_PERIOD_NET_CR
, PERIOD_MON
, ACCOUNT_TYPE
, DECODE(ACCOUNT_TYPE
, 'A'
, NVL(FUNC_BEGIN_BALANCE_DR
, 0)-NVL(FUNC_BEGIN_BALANCE_CR
, 0)
, 'E'
, NVL(FUNC_BEGIN_BALANCE_DR
, 0)-NVL(FUNC_BEGIN_BALANCE_CR
, 0)
, NVL(FUNC_BEGIN_BALANCE_CR
, 0)-NVL(FUNC_BEGIN_BALANCE_DR
, 0)
) FUNC_BEGIN_BALANCE
, DECODE(ACCOUNT_TYPE
, 'A'
, NVL(ORIG_BEGIN_BALANCE_DR
, 0)-NVL(ORIG_BEGIN_BALANCE_CR
, 0)
, 'E'
, NVL(ORIG_BEGIN_BALANCE_DR
, 0)-NVL(ORIG_BEGIN_BALANCE_CR
, 0)
, NVL(FUNC_BEGIN_BALANCE_CR
, 0)-NVL(FUNC_BEGIN_BALANCE_DR
, 0)
) ORIG_BEGIN_BALANCE
, NVL(FUNC_BEGIN_BALANCE_DR
, 0) + NVL(FUNC_PERIOD_NET_DR
, 0) FUNC_END_BALANCE_DR
, NVL(FUNC_BEGIN_BALANCE_CR
, 0) + NVL(FUNC_PERIOD_NET_CR
, 0) FUNC_END_BALANCE_CR
, NVL(ORIG_BEGIN_BALANCE_DR
, 0) + NVL(ORIG_PERIOD_NET_DR
, 0) ORIG_END_BALANCE_DR
, NVL(ORIG_BEGIN_BALANCE_CR
, 0) + NVL(ORIG_PERIOD_NET_CR
, 0) ORIG_END_BALANCE_CR
, DECODE(ACCOUNT_TYPE
, 'A'
, NVL(FUNC_BEGIN_BALANCE_DR
, 0) + NVL(FUNC_PERIOD_NET_DR
, 0) -
(NVL(FUNC_BEGIN_BALANCE_CR
, 0) + NVL(FUNC_PERIOD_NET_CR
, 0))
, 'E'
, NVL(FUNC_BEGIN_BALANCE_DR
, 0) + NVL(FUNC_PERIOD_NET_DR
, 0) -
(NVL(FUNC_BEGIN_BALANCE_CR
, 0) + NVL(FUNC_PERIOD_NET_CR
, 0))
, NVL(FUNC_BEGIN_BALANCE_CR
, 0) + NVL(FUNC_PERIOD_NET_CR
, 0) -
(NVL(FUNC_BEGIN_BALANCE_DR
, 0) + NVL(FUNC_PERIOD_NET_DR
, 0))
) FUNC_END_BALANCE
, DECODE(ACCOUNT_TYPE
, 'A'
, NVL(ORIG_BEGIN_BALANCE_DR
, 0) + NVL(ORIG_PERIOD_NET_DR
, 0) -
(NVL(ORIG_BEGIN_BALANCE_CR
, 0) + NVL(ORIG_PERIOD_NET_CR
, 0))
, 'E'
, NVL(ORIG_BEGIN_BALANCE_DR
, 0) + NVL(ORIG_PERIOD_NET_DR
, 0) -
(NVL(ORIG_BEGIN_BALANCE_CR
, 0) + NVL(ORIG_PERIOD_NET_CR
, 0))
, NVL(ORIG_BEGIN_BALANCE_CR
, 0) + NVL(ORIG_PERIOD_NET_CR
, 0) -
(NVL(ORIG_BEGIN_BALANCE_DR
, 0) + NVL(ORIG_PERIOD_NET_DR
, 0))
) ORIG_END_BALANCE
FROM JA_CN_ACCOUNT_BALANCES
|
|
|