[Home] [Help] [Dependency Information]
Object Name: | IBY_CREDITCARD_ISSUERS_TL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_CREDITCARD_ISSUERS_TL |
Subobject Name: | |
Status: | VALID |
Holds the list of accepted card brands
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_CREDITCARD_ISSUERS_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CARD_ISSUER_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CARD_ISSUER_CODE | VARCHAR2 | (30) | Yes | Card Issuer Code if know. Otherwise UNKNOWN. |
CARD_ISSUER_NAME | VARCHAR2 | (100) | Yes | Credit card brand name |
DESCRIPTION | VARCHAR2 | (240) | Description of the credit card brand | |
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 | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the record's current language |
Cut, paste (and edit) the following text to query this object:
SELECT CARD_ISSUER_CODE
, CARD_ISSUER_NAME
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, LANGUAGE
, SOURCE_LANG
FROM IBY.IBY_CREDITCARD_ISSUERS_TL;
IBY.IBY_CREDITCARD_ISSUERS_TL does not reference any database object
IBY.IBY_CREDITCARD_ISSUERS_TL is referenced by following:
|
|
|