...
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) |
...