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

TABLE: AP.AP_CARD_DETAILS

Object Details
Object Name: AP_CARD_DETAILS
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_CARD_DETAILS
Subobject Name:
Status: VALID


The AP_CARD_DETAILS table stores extra information provided by the credit card providers about new credit cards. This information is used to uniquely identify the correct employee to whom the card was issued.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_CARD_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARD_ID
Columns
Name Datatype Length Mandatory Comments
CARD_ID NUMBER (15) Yes Card identifier
FULL_NAME VARCHAR2 (80)
Employee full name
FIRST_NAME VARCHAR2 (40)
Employee first name
MIDDLE_NAME VARCHAR2 (40)
Employee middle name
LAST_NAME VARCHAR2 (40)
Employee last name
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
NATIONAL_IDENTIFIER VARCHAR2 (30)
National identifier
REQUEST_ID NUMBER (15)
Request Identifier
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
CARD_HOLDER_IDENTIFICATION VARCHAR2 (40)
Card holder ID specified by the credit card acceptor.
Query Text

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


SELECT CARD_ID
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      EMPLOYEE_NUMBER
,      NATIONAL_IDENTIFIER
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CARD_HOLDER_IDENTIFICATION
FROM AP.AP_CARD_DETAILS;

Dependencies

[top of page]

AP.AP_CARD_DETAILS does not reference any database object

AP.AP_CARD_DETAILS is referenced by following:

SchemaAPPS
SynonymAP_CARD_DETAILS