2 queries found for "Credit Rating History"

Retrieve bad credit accounts

SELECT ACCT_ID  FROM  (select ACCT_ID, sum(CR_RATING_PTS) CR_RATING_PTS from cisadm.CI_CR_RAT_HIST where END_DT > sysdate group by ACCT_ID) ACCT_CR_DATA,  
  (SELECT START_CR_RAT_PTS, CR_RAT_THRS FROM cisadm.C0_INSTALLATION ) INST_DATA WHERE (CR_RATING_PTS+START_CR_RAT_PTS) < CR_RAT_THRS;

uploaded by Tushar Mali

Retrieve Good credit accounts

SELECT ACCT_ID  FROM  (select ACCT_ID, sum(CR_RATING_PTS) CR_RATING_PTS from cisadm.CI_CR_RAT_HIST where END_DT > sysdate group by ACCT_ID) ACCT_CR_DATA,  
  (SELECT START_CR_RAT_PTS, CR_RAT_THRS FROM cisadm.C0_INSTALLATION ) INST_DATA WHERE (CR_RATING_PTS+START_CR_RAT_PTS) > CR_RAT_THRS;

uploaded by Tushar Mali