eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V

Source

View Text - Preformatted


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
      , SEGMENT1
      , SEGMENT2
      , SEGMENT3
      , SEGMENT4
      , SEGMENT5
      , SEGMENT6
      , SEGMENT7
      , SEGMENT8
      , SEGMENT9
      , SEGMENT10
      , SEGMENT11
      , SEGMENT12
      , SEGMENT13
      , SEGMENT14
      , SEGMENT15
      , SEGMENT16
      , SEGMENT17
      , SEGMENT18
      , SEGMENT19
      , SEGMENT20
      , SEGMENT21
      , SEGMENT22
      , SEGMENT23
      , SEGMENT24
      , SEGMENT25
      , SEGMENT26
      , SEGMENT27
      , SEGMENT28
      , SEGMENT29
      , SEGMENT30
      , 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
      /*by jarwang for bug 16572904
      , 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*/
       , 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(ORIG_BEGIN_BALANCE_cR,0)-nvl(ORIG_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

View Text - HTML Formatted

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
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, 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 /*BY JARWANG FOR BUG 16572904
, 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*/
, 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(ORIG_BEGIN_BALANCE_CR
, 0)-NVL(ORIG_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