[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XNP_SERVICE_PROVIDERS |
|---|---|
| Object Type: | TABLE |
| Owner: | XNP |
| FND Design Data: |  XNP.XNP_SERVICE_PROVIDERS
|
| Subobject Name: | |
| Status: | VALID |
XNP_SERVICE_PROVIDERS is the definition table for service providers. This table holds service provider details used by the Number Portability Service delivery Management System (NP SMS), Number Portability Service Order Administration (NP SOA) and Number Registration Center (NRC).
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XNP_SERVICE_PROVIDERS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 SP_ID
|
| XNP_SERVICE_PROVIDERS_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SP_ID | NUMBER | Yes | Service provider identifier | |
| SP_TYPE | VARCHAR2 | (20) | Yes | Type of service provider |
| CODE | VARCHAR2 | (20) | Yes | Public Code for Service Provider |
| NAME | VARCHAR2 | (80) | Yes | Name of service provider |
| TIMEZONE | VARCHAR2 | (10) | Yes | Time zone for the service provider |
| SERVED_BY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the service provider is served by the bureau |
| ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the organization is active or not. |
| ADDRESS_LINE1 | VARCHAR2 | (40) | Yes | Street address of the service provider |
| CITY | VARCHAR2 | (40) | Yes | City of the service provider |
| STATE | VARCHAR2 | (40) | State of the service provider | |
| ZIP_CODE | VARCHAR2 | (20) | Yes | Zip code of the service provider |
| COUNTRY | VARCHAR2 | (40) | Yes | Country of the service provider |
| PHONE | VARCHAR2 | (20) | Yes | Telephone number of the service provider |
| ADDRESS_LINE2 | VARCHAR2 | (40) | Street address of the service provider | |
| MOBILE | VARCHAR2 | (20) | Cellular number of the service provider | |
| FAX | VARCHAR2 | (20) | Fax number of the service provider | |
| PAGER | VARCHAR2 | (20) | Pager number of the service provider | |
| PAGER_PIN | VARCHAR2 | (80) | Pager pin number of the service provider | |
| VARCHAR2 | (80) | Email id of the service provider | ||
| INTERNET_ADDRESS | VARCHAR2 | (40) | Web address of the service provider | |
| DEPARTMENT | VARCHAR2 | (80) | Department name of the service provider | |
| SOA_MGT_FLAG | VARCHAR2 | (1) | Flag to indicate whether the service provider can download subscription version data from NRC | |
| SOA_NETWORK_MGT_FLAG | VARCHAR2 | (1) | Flag to indicate whether the service provider can download subscription version data from NRC | |
| SMS_DOWNLOAD_FLAG | VARCHAR2 | (1) | Flag to indicate whether the service provider can download subscription version data from NRC | |
| SMS_NETWORK_MGT_FLAG | VARCHAR2 | (1) | Flag to indicate whether the service provider can download subscription version data from NRC | |
| SMS_QUERY_FLAG | VARCHAR2 | (1) | Flag to indicate from the view point of NAPC whether the service provider can make query on SMS | |
| SV_DOWNLOAD_FLAG | VARCHAR2 | (1) | Flag to indicate whether the service provider can download subscription version data from NRC | |
| NETWORK_DOWNLOAD_FLAG | VARCHAR2 | (1) | Flag to indicate whether the service provider can download subscription version data from NRC | |
| 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 SP_ID
, SP_TYPE
, CODE
, NAME
, TIMEZONE
, SERVED_BY_FLAG
, ACTIVE_FLAG
, ADDRESS_LINE1
, CITY
, STATE
, ZIP_CODE
, COUNTRY
, PHONE
, ADDRESS_LINE2
, MOBILE
, FAX
, PAGER
, PAGER_PIN
, EMAIL
, INTERNET_ADDRESS
, DEPARTMENT
, SOA_MGT_FLAG
, SOA_NETWORK_MGT_FLAG
, SMS_DOWNLOAD_FLAG
, SMS_NETWORK_MGT_FLAG
, SMS_QUERY_FLAG
, SV_DOWNLOAD_FLAG
, NETWORK_DOWNLOAD_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XNP.XNP_SERVICE_PROVIDERS;
XNP.XNP_SERVICE_PROVIDERS does not reference any database object
XNP.XNP_SERVICE_PROVIDERS is referenced by following:
APPS
XNP_SERVICE_PROVIDERS
|
|
|
|