Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT A0.UNIV_FISCAL_YR,
- A0.FIN_COA_CD,
- A0.ACCOUNT_NBR,
- A0.FIN_OBJECT_CD,
- A1.FIN_OBJ_TYP_CD,
- SUM(A0.CURR_BDLN_BAL_AMT),
- SUM(A0.ACLN_ACTLS_BAL_AMT),
- SUM(A0.ACLN_ENCUM_BAL_AMT)
- FROM GL_ACCT_BALANCES_T A0
- INNER JOIN CA_OBJECT_CODE_T A1
- ON A0.UNIV_FISCAL_YR=A1.UNIV_FISCAL_YR
- AND A0.FIN_COA_CD =A1.FIN_COA_CD
- AND A0.FIN_OBJECT_CD=A1.FIN_OBJECT_CD
- WHERE ((A0.FIN_COA_CD LIKE 'I')
- AND A0.UNIV_FISCAL_YR = 2015)
- AND A0.ACCOUNT_NBR = '0'
- GROUP BY A0.UNIV_FISCAL_YR,
- A0.FIN_COA_CD,
- A0.ACCOUNT_NBR,
- A0.FIN_OBJECT_CD,
- A1.FIN_OBJ_TYP_CD
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement