[Home] [Help]
View: IBY_CREDITCARD_V
Product: | IBY - Payments |
Description: | View used to work with registered credit cards. |
Implementation/DBA Data: |
APPS.IBY_CREDITCARD_V
|
View Text
SELECT C.INSTRID
, C.CARD_OWNER_ID
, C.CCNUMBER
, C.CC_NUMBER_HASH1
, C.CC_NUMBER_HASH2
, C.EXPIRYDATE
, C.FINAME
, NULL
, C.CHNAME
, C.INSTRNAME
, NULL
, NULL
, C.DESCRIPTION INSTRBUF
, C.ENCRYPTED
FROM IBY_CREDITCARD C
Columns
Name |
INSTRID |
CARD_OWNER_ID |
CCNUMBER |
CC_NUMBER_HASH1 |
CC_NUMBER_HASH2 |
EXPIRYDATE |
FINAME |
ACCTTYPE |
CHNAME |
INSTRNAME |
OWNERTYPE |
OWNERID |
INSTRBUF |
ENCRYPTED |