[Home] [Help] [Dependency Information]
Object Name: | XNP_ROUTING_NUMBERS |
---|---|
Object Type: | TABLE |
Owner: | XNP |
FND Design Data: | XNP.XNP_ROUTING_NUMBERS |
Subobject Name: | |
Status: | VALID |
XNP_ROUTING_NUMBERS stores Routing Numbers for a given Service ProviderThe Routing Number is used by all service providers to port telephone number to the appropriate service provider.
A Routing Number typically identifies a specific destination within a service provider's network such as switch.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XNP_ROUTING_NUMBERS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ROUTING_NUMBER_ID |
XNP_ROUTING_NUMBERS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
SP_ID
ROUTING_NUMBER INTERCONNECT_TYPE |
XNP_ROUTING_NUMBERS_U3 | NORMAL | UNIQUE | APPS_TS_SEED | OBJECT_REFERENCE |
XNP_ROUTING_NUMBERS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_NUMBER_ID | NUMBER | Yes | Routing number identifier | |
OBJECT_REFERENCE | VARCHAR2 | (80) | Yes | External Reference id or the code used by an external system for the routing number |
INTERCONNECT_TYPE | VARCHAR2 | (10) | Yes | Indicates interconnect type whether Equal Access or Number Portability |
SP_ID | NUMBER | Yes | Service provider owning the routing numbers | |
ROUTING_NUMBER | VARCHAR2 | (20) | Yes | Routing Number that identifies the destination for porting telephone numbers |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the routing number is active |
STATUS | VARCHAR2 | (10) | Domain of status for routing numbers | |
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 | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ROUTING_NUMBER_ID
, OBJECT_REFERENCE
, INTERCONNECT_TYPE
, SP_ID
, ROUTING_NUMBER
, ACTIVE_FLAG
, STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XNP.XNP_ROUTING_NUMBERS;
XNP.XNP_ROUTING_NUMBERS does not reference any database object
XNP.XNP_ROUTING_NUMBERS is referenced by following:
|
|
|