DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IBY_CREDITCARD_V

Object Details
Object Name: IBY_CREDITCARD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_CREDITCARD_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View used to work with registered credit cards.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTRID NUMBER (15) Yes ID that iPayment uses to identify a registered credit card.
CARD_OWNER_ID NUMBER (15)
Card Owner ID
CCNUMBER VARCHAR2 (30) Yes Credit card number.
CC_NUMBER_HASH1 VARCHAR2 (64)
Credit card number hash #1
CC_NUMBER_HASH2 VARCHAR2 (64)
Credit card number hash #2
EXPIRYDATE DATE

Date after which the credit card expires.
FINAME VARCHAR2 (80)
The name of the financial institution (bank) that issued the card.
ACCTTYPE VARCHAR2 (0)
Type of credit card account.
CHNAME VARCHAR2 (80)
Card holder name.
INSTRNAME VARCHAR2 (80)
Mnemonic for a registered credit card.
OWNERTYPE VARCHAR2 (0)
The type of the account holder (e.g. user).
OWNERID VARCHAR2 (0)
ID that iPayment uses to identify credit card holder.
INSTRBUF VARCHAR2 (240)
Description of registered credit card.
ENCRYPTED VARCHAR2 (1)
Indicates if the instrument is encrypted
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INSTRID
,      CARD_OWNER_ID
,      CCNUMBER
,      CC_NUMBER_HASH1
,      CC_NUMBER_HASH2
,      EXPIRYDATE
,      FINAME
,      ACCTTYPE
,      CHNAME
,      INSTRNAME
,      OWNERTYPE
,      OWNERID
,      INSTRBUF
,      ENCRYPTED
FROM APPS.IBY_CREDITCARD_V;

Dependencies

[top of page]

APPS.IBY_CREDITCARD_V references the following:

SchemaAPPS
SynonymIBY_CREDITCARD
APPS.IBY_CREDITCARD_V is referenced by following:

SchemaAPPS
Package BodyIBY_INSTRREG_PUB - show dependent code
Package BodyIBY_OFFLINEDB_PKG - show dependent code
PL/SQL PackageIBY_SCHED - show dependent code
Package BodyIBY_SCHED - show dependent code