9 queries found for "Account"

Get all from Account

select * 
from CI_ACCT

uploaded by Nuno Rodrigues

Get specific Account

select * 
from CI_ACCT
where 
ACCT_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve Account Mailing Address

SELECT
    a.acct_id, p.*
FROM
    ci_acct a, ci_prem p
WHERE 
   a.mailing_prem_id = p.prem_id
   and acct_id = 'INSERT_ACCOUNT_ID'

uploaded by Nuno Rodrigues

Check Account is Open Item

SELECT CCL.OPEN_ITEM_SW
FROM   CI_CUST_CL CCL,
       CI_ACCT ACCT
WHERE  CCL.CUST_CL_CD = ACCT.CUST_CL_CD
       AND ACCT.ACCT_ID = 'INSERT_ACCOUNT_ID'

uploaded by Nuno Rodrigues

Retrieve blank AMG on account

SELECT ac.cust_cl_cd, ac.acct_id, ac.acct_mgmt_grp_cd, pn.entity_name_upr
  FROM ci_acct@production ac,
       ci_acct_per@production ap,
       ci_per_name@production pn
 WHERE ac.acct_id = ap.acct_id
   AND ap.per_id = pn.per_id
   AND pn.prim_name_sw = 'Y'
   AND ac.acct_mgmt_grp_cd = ' '

uploaded by Muhammad Junaid

Retrieve unmatched Bill Cyc and SP MR Cyc code

SELECT ac.mailing_prem_id, ac.bill_cyc_cd, ac.acct_id, sp.prem_id,
       sp.mr_rte_cd, sp.mr_cyc_cd, sp.sp_id
  FROM ci_acct ac, ci_sp sp
 WHERE sp.prem_id = ac.mailing_prem_id 
 AND ac.bill_cyc_cd <> sp.mr_cyc_cd

uploaded by Muhammad Junaid

Retrieve Current balance of the account

select sum(f.CUR_AMT)
from cisadm.CI_ACCT a, cisadm.ci_sa s, cisadm.CI_FT f
where a.ACCT_ID=s.ACCT_ID
and f.SA_ID=s.SA_ID
and a.ACCT_ID = 'INSERT ACCT ID'
group by s.ACCT_ID;

uploaded by Tushar Mali

Find out account details

select * from CI_ACCT;

uploaded by vini

Retrieve Account's Last Bill Details

SELECT bil1.acct_id,
  bil1.due_dt last_bill_due_dt,
  bil1.bill_id last_bill_id,
  bil1.BILL_DT LAst_bill_dt,
  ACCT.CUST_CL_CD
FROM ci_bill bil1,
  ci_acct acct
WHERE bil1.acct_id = 'INSERT_ACCOUNT_ID'
AND bil1.bill_dt =
  (SELECT MAX(BILL_DT)
  FROM ci_bill bil2
  WHERE bil2.acct_id = bil1.acct_id
  )
AND bil1.acct_id = acct.acct_id;

uploaded by Ninad Deshpande