[Home] [Help]
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
Name |
INSTRID |
PCNUMBER |
EXPIRYDATE |
FINAME |
ACCTTYPE |
CHNAME |
INSTRNAME |
SUBTYPE |
OWNERTYPE |
OWNERID |
INSTRBUF |
ENCRYPTED |