VIEW: APPS.IBY_PURCHASECARD_V

Source

View Text - Preformatted

SELECT c.instrid, c.ccnumber, c.expirydate, c.finame, y.accttype, c.chname, c.instrname, c.subtype, h.ownertype, h.ownerid, c.description instrbuf, c.encrypted from iby_creditcard c, iby_instrholder h, iby_accttype y where c.instrid = h.instrid and h.instrtype = 'PURCHASECARD' and c.accttypeid = y.accttypeid and h.activestatus = 1

View Text - HTML Formatted

SELECT C.INSTRID
, C.CCNUMBER
, C.EXPIRYDATE
, C.FINAME
, Y.ACCTTYPE
, C.CHNAME
, C.INSTRNAME
, C.SUBTYPE
, H.OWNERTYPE
, H.OWNERID
, C.DESCRIPTION INSTRBUF
, C.ENCRYPTED
FROM IBY_CREDITCARD C
, IBY_INSTRHOLDER H
, IBY_ACCTTYPE Y
WHERE C.INSTRID = H.INSTRID
AND H.INSTRTYPE = 'PURCHASECARD'
AND C.ACCTTYPEID = Y.ACCTTYPEID
AND H.ACTIVESTATUS = 1