3 queries found for "Installation Options"

Retrieve Cash Only Accounts

SELECT ACCT_ID  
FROM
  (SELECT ACCT_ID,
    SUM(CASH_ONLY_PTS) CASH_ONLY_PTS
  FROM CI_ACCT_CR_R_VW
  GROUP BY ACCT_ID
  ) ACCT_CR_DATA,
  (SELECT START_CASH_ONL_PTS,CASH_ONLY_PTS_THRS FROM C0_INSTALLATION
  ) INST_DATA
WHERE (CASH_ONLY_PTS+START_CASH_ONL_PTS) > CASH_ONLY_PTS_THRS;

uploaded by Vinay Kumar Endla

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