Advertisement
mugs

available balances

Jun 8th, 2015
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.56 KB | None | 0 0
  1. SELECT A0.UNIV_FISCAL_YR,
  2.   A0.FIN_COA_CD,
  3.   A0.ACCOUNT_NBR,
  4.   A0.FIN_OBJECT_CD,
  5.   A1.FIN_OBJ_TYP_CD,
  6.   SUM(A0.CURR_BDLN_BAL_AMT),
  7.   SUM(A0.ACLN_ACTLS_BAL_AMT),
  8.   SUM(A0.ACLN_ENCUM_BAL_AMT)
  9. FROM GL_ACCT_BALANCES_T A0
  10. INNER JOIN CA_OBJECT_CODE_T A1
  11. ON A0.UNIV_FISCAL_YR=A1.UNIV_FISCAL_YR
  12. AND A0.FIN_COA_CD   =A1.FIN_COA_CD
  13. AND A0.FIN_OBJECT_CD=A1.FIN_OBJECT_CD
  14. WHERE ((A0.FIN_COA_CD LIKE 'I')
  15. AND A0.UNIV_FISCAL_YR = 2015)
  16. AND A0.ACCOUNT_NBR    = '0'
  17. GROUP BY A0.UNIV_FISCAL_YR,
  18.   A0.FIN_COA_CD,
  19.   A0.ACCOUNT_NBR,
  20.   A0.FIN_OBJECT_CD,
  21.   A1.FIN_OBJ_TYP_CD
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement