Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
SELECT FIN_COA_CD
      ,FIN_COA_DESC
      ,FIN_COA_ACTIVE_CD
      ,FIN_CASH_OBJ_CD
      ,FIN_AP_OBJ_CD
      ,INCBDGT_ELIMOBJ_CD
      ,EXPBDGT_ELIMOBJ_CD
      ,RPTS_TO_FIN_COA_CD
      ,FIN_AR_OBJ_CD
      ,FIN_INT_ENC_OBJ_CD
      ,FIN_EXT_ENC_OBJ_CD
      ,FIN_PRE_ENC_OBJ_CD
      ,ICR_INC_FIN_OBJ_CD
      ,ICR_EXP_FIN_OBJ_CD
      ,FND_BAL_OBJ_CD
  FROM ca_chart_t
WHERE FIN_COA_ACTIVE_CD <> 'N' 
andAND FIN_COA_CD IN ('<kfsChartCode1>', '<kfsChartCode2>', etc)

...