View: IBY_PURCHASECARD_V

Product:	IBY - Payments
Description:	View used to work with registered purchase cards.
Implementation/DBA Data:	APPS.IBY_PURCHASECARD_V

View Text

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

Columns