[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XNP_SV_SOA_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XNP.XNP_SV_SOA_VL
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
SNP_SV_SOA_VL shows porting information for a single telephone number.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SV_SOA_ID | NUMBER | Yes | SOA initiated subscription version identifier | |
| PORTING_ID | VARCHAR2 | (80) | Yes | External reference ID for this SV SOA |
| SUBSCRIPTION_TN | VARCHAR2 | (20) | Yes | Subscription version or telephone number |
| SUBSCRIPTION_TYPE | VARCHAR2 | (10) | Yes | Indicates the portability type which is either equal access or number portability |
| DONOR_SP_ID | NUMBER | Yes | For equal access , this is long distance service provider and for number portability, this is local service provider | |
| RECIPIENT_SP_ID | NUMBER | Yes | For equal access , this is long distance service provider and for number portability, this is local service provider | |
| STATUS_TYPE_CODE | VARCHAR2 | (20) | Yes | Status type code |
| PTO_FLAG | VARCHAR2 | (1) | Yes | Indicates if the porting is to a original service provider |
| CREATED_BY_SP_ID | NUMBER | Service provider who created it which is applicable both for number registration centre and service bureau | ||
| CHANGED_BY_SP_ID | NUMBER | Applicable to NRC when acceptance for porting a TN is received from both the Service providers then the same record for subscription version is updated or changed with the changed service provider id. | ||
| MEDIATOR_SP_ID | NUMBER | For equal access , it indicates local service provider and for number portability indicates number registration centre | ||
| ROUTING_NUMBER_ID | NUMBER | Routing number identifier for the subscription telephone number given by the recipient service provider | ||
| PRE_SPLIT_SUBSCRIPTION_TN | VARCHAR2 | (20) | Telephone number for subscription before number range split | |
| PREV_STATUS_TYPE_CODE | VARCHAR2 | (20) | Status code before updation of the record | |
| CNAM_ADDRESS | VARCHAR2 | (80) | Call naming network address for the subscription version | |
| CNAM_SUBSYSTEM | VARCHAR2 | (80) | Call naming application subsystem for this subscription version | |
| ISVM_ADDRESS | VARCHAR2 | (80) | Integrated services voice mail network address for this subscription version | |
| ISVM_SUBSYSTEM | VARCHAR2 | (80) | Integrated sevices voice mail subsystem address for this subscription version | |
| LIDB_ADDRESS | VARCHAR2 | (80) | Line information databases network address for this subscription version | |
| LIDB_SUBSYSTEM | VARCHAR2 | (80) | Line information databases application subsystem for this subscription version | |
| CLASS_ADDRESS | VARCHAR2 | (80) | Custom local area signalling services network address for this subscription version | |
| CLASS_SUBSYSTEM | VARCHAR2 | (80) | Custom local area signalling services application subsystem for this subscription version | |
| WSMSC_ADDRESS | VARCHAR2 | (80) | Wireless short message service centre network address for this subscription version | |
| WSMSC_SUBSYSTEM | VARCHAR2 | (80) | Wireless short message service centre application subsystem for this subscription version | |
| RN_ADDRESS | VARCHAR2 | (80) | Routing number network address for the subscription version | |
| RN_SUBSYSTEM | VARCHAR2 | (80) | Routing number network address for the subscription version | |
| ACTIVATION_DUE_DATE | DATE | Date at which subscription should be activated | ||
| NEW_SP_DUE_DATE | DATE | Due date planned by the new service provider for service transfer | ||
| OLD_SP_DUE_DATE | DATE | Due date planned by old service provider for transfer of service | ||
| OLD_SP_CUTOFF_DUE_DATE | DATE | Date of service cutoff from the old service provider | ||
| EFFECTIVE_RELEASE_DUE_DATE | DATE | Effective release date of the subscription version | ||
| NUMBER_RETURNED_DUE_DATE | DATE | Due date on which the number is to be returned to the original service provider | ||
| DISCONNECT_DUE_DATE | DATE | Date that the customer's service is to be disconnected | ||
| INVOICE_DUE_DATE | DATE | Date the customer's invoice is due | ||
| STATUS_CHANGE_DATE | DATE | Date the subscription version status changed | ||
| CREATED_DATE | DATE | Date the subscription version record was created | ||
| MODIFIED_DATE | DATE | Date the subscription version was last modified | ||
| CONCURRENCE_FLAG | VARCHAR2 | (1) | Indicates concurrence of both the donor and the recipient service provider | |
| NEW_SP_AUTHORIZATION_FLAG | VARCHAR2 | (1) | Indicates authorization or denial for transfer of service by the new service provider | |
| OLD_SP_AUTHORIZATION_FLAG | VARCHAR2 | (1) | Indicates authorization or denial for transfer of service by the old service provider | |
| RETAIN_DIR_INFO_FLAG | VARCHAR2 | (1) | Flag to indicate if directory information is to be retained or not | |
| RETAIN_TN_FLAG | VARCHAR2 | (1) | Flag to indicate if subscription should be retained | |
| BLOCKED_FLAG | VARCHAR2 | (1) | Flag to indicate if the subscription telephone number is blocked or not | |
| LOCKED_FLAG | VARCHAR2 | (1) | Flag to indicate if subscription is locked | |
| CUSTOMER_CONTACT_REQ_FLAG | VARCHAR2 | (1) | Flag to indicate if contact person is required | |
| BILLING_ID | NUMBER | Used for billing purpose | ||
| USER_LOCTN_VALUE | VARCHAR2 | (80) | Used for billing purpose | |
| USER_LOCTN_TYPE | VARCHAR2 | (20) | Used for billing purpose | |
| CHARGING_INFO | VARCHAR2 | (1996) | Charging information | |
| ORDER_PRIORITY | VARCHAR2 | (30) | Priority for the subscription order whether normal or express | |
| STATUS_CHANGE_CAUSE_CODE | VARCHAR2 | (20) | Reason for status change | |
| PREORDER_AUTHORIZATION_CODE | VARCHAR2 | (20) | Authorization code for changing service provider | |
| CUSTOMER_ID | VARCHAR2 | (80) | Customer identifier | |
| CUSTOMER_NAME | VARCHAR2 | (80) | Name of the customer | |
| CUSTOMER_TYPE | VARCHAR2 | (10) | Type of customer | |
| CONTACT_NAME | VARCHAR2 | (80) | Name of the contact person | |
| ADDRESS_LINE1 | VARCHAR2 | (400) | Street address of the service provider's contact person | |
| ADDRESS_LINE2 | VARCHAR2 | (400) | Street address of the service provider's contact person | |
| CITY | VARCHAR2 | (40) | City name for the service provider's contact person | |
| STATE | VARCHAR2 | (40) | State name for the service provider's contact person | |
| ZIP_CODE | VARCHAR2 | (20) | Zip code for the service provider's contact person | |
| COUNTRY | VARCHAR2 | (40) | Country for the service provider's contact person | |
| PHONE | VARCHAR2 | (20) | Phone number of the service provider's contact person | |
| MOBILE | VARCHAR2 | (20) | Mobile number of the service provider's contact person | |
| FAX | VARCHAR2 | (20) | Fax number of the service provider's contact person | |
| PAGER | VARCHAR2 | (20) | Pager number of the service provider's contact person | |
| PAGER_PIN | VARCHAR2 | (80) | Pager pin number of the service provider's contact person | |
| VARCHAR2 | (80) | Email id of the service provider's contact person | ||
| INTERNET_ADDRESS | VARCHAR2 | (40) | Internet address of the service provider's contact person | |
| PRICE_CODE | VARCHAR2 | (20) | Price code used for billing | |
| PRICE_PER_CALL | NUMBER | (15) | Price per call used for billing | |
| PRICE_PER_MINUTE | NUMBER | (15) | Price per minute used for billing | |
| 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 | |
| STATUS_PHASE | VARCHAR2 | (20) | Yes | Indicates the phase of the status type code |
| STATUS_DISPLAY_NAME | VARCHAR2 | (80) | Yes | Display name of the status |
| STATUS_DESC | VARCHAR2 | (2000) | Description of the status | |
| DON_SP_TYPE | VARCHAR2 | (20) | Yes | Service provider type of the donor |
| DON_CODE | VARCHAR2 | (20) | Yes | Public code of the donor service provider |
| DON_NAME | VARCHAR2 | (80) | Yes | Name of the donor service provider |
| DON_TIMEZONE | VARCHAR2 | (10) | Yes | Time zone of the donor service provider |
| DON_SERVED_BY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the donor service provider is served by the bureau |
| DON_ADDRESS_LINE1 | VARCHAR2 | (40) | Yes | Street address of the donor service provider's contact person |
| DON_CITY | VARCHAR2 | (40) | Yes | City of the donor service provider's contact person |
| DON_STATE | VARCHAR2 | (40) | State of the donor service provider's contact person | |
| DON_ZIP_CODE | VARCHAR2 | (20) | Yes | Zip code of the donor service provider's contact person |
| DON_COUNTRY | VARCHAR2 | (40) | Yes | Country of the donor service provider's contact person |
| DON_PHONE | VARCHAR2 | (20) | Yes | Phone number of the donor service provider's contact person |
| DON_ADDRESS_LINE2 | VARCHAR2 | (40) | Street address of the donor service provider's contact person | |
| DON_MOBILE | VARCHAR2 | (20) | Mobile number of the donor service provider's contact person | |
| DON_FAX | VARCHAR2 | (20) | Fax number of the donor service provider's contact person | |
| DON_PAGER | VARCHAR2 | (20) | Pager number of the donor service provider's contact person | |
| DON_PAGER_PIN | VARCHAR2 | (80) | Pager pin of the donor service provider's contact person | |
| DON_EMAIL | VARCHAR2 | (80) | Email id of the donor service provider | |
| DON_INTERNET | VARCHAR2 | (40) | Internet address of the donor service provider | |
| DON_DEPT | VARCHAR2 | (80) | Department name of the donor service provider | |
| REC_SP_TYPE | VARCHAR2 | (20) | Yes | Service provider type of the recipient |
| REC_CODE | VARCHAR2 | (20) | Yes | Public code of the recipient service provider |
| REC_NAME | VARCHAR2 | (80) | Yes | Name of the recipient service provider |
| REC_TIMEZONE | VARCHAR2 | (10) | Yes | Timezone of the recipient service provider |
| REC_SERVED_BY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the recipient service provider is served by the bureau |
| REC_ADDRESS_LINE1 | VARCHAR2 | (40) | Yes | Street address of the recipient service provider's contact person. |
| REC_CITY | VARCHAR2 | (40) | Yes | City of the recipient service provider |
| REC_STATE | VARCHAR2 | (40) | State of the recipient service provider | |
| REC_ZIP_CODE | VARCHAR2 | (20) | Yes | Zipcode of the recipient service provider |
| REC_COUNTRY | VARCHAR2 | (40) | Yes | Country of the recipient service provider |
| REC_PHONE | VARCHAR2 | (20) | Yes | Phone number of the recipient service provider |
| REC_ADDRESS_LINE2 | VARCHAR2 | (40) | Street address of the recipient service provider | |
| REC_MOBILE | VARCHAR2 | (20) | Mobile number of the recipient service provider | |
| REC_FAX | VARCHAR2 | (20) | Fax number of the recipient service provider | |
| REC_PAGER | VARCHAR2 | (20) | Pager number of the recipient service provider | |
| REC_PAGER_PIN | VARCHAR2 | (80) | Pager pin of the recipient service provider | |
| REC_EMAIL | VARCHAR2 | (80) | Email id of the recipient service provider | |
| REC_INTERNET | VARCHAR2 | (40) | Internet address of the recipient service provider | |
| REC_DEPT | VARCHAR2 | (80) | Department name of the recipient service provider's contact person. | |
| NRC_SP_TYPE | VARCHAR2 | (20) | Service provider type of the number registration center | |
| NRC_CODE | VARCHAR2 | (20) | Public code of the number registration center | |
| NRC_NAME | VARCHAR2 | (80) | Name of the number registration center | |
| NRC_TIMEZONE | VARCHAR2 | (10) | Timezone of the number registration center | |
| NRC_SERVED_BY_FLAG | VARCHAR2 | (1) | Flag to indicate if the number registration center is served by the bureau | |
| NRC_ADDRESS_LINE1 | VARCHAR2 | (40) | Street address of the number registration center | |
| NRC_CITY | VARCHAR2 | (40) | City of the number registration center | |
| NRC_STATE | VARCHAR2 | (40) | State of the number registration center | |
| NRC_ZIP_CODE | VARCHAR2 | (20) | Zip code of the number registration center | |
| NRC_COUNTRY | VARCHAR2 | (40) | Country of the number registration center | |
| NRC_PHONE | VARCHAR2 | (20) | Phone number of the number registration center | |
| NRC_ADDRESS_LINE2 | VARCHAR2 | (40) | Street address of the number registration center | |
| NRC_MOBILE | VARCHAR2 | (20) | Mobile number of the number registration center | |
| NRC_FAX | VARCHAR2 | (20) | Fax number of the number registration center | |
| NRC_PAGER | VARCHAR2 | (20) | Pager number of the number registration center | |
| NRC_PAGER_PIN | VARCHAR2 | (80) | Pager pin of the number registration center | |
| NRC_EMAIL | VARCHAR2 | (80) | Email id of the number registration center | |
| NRC_INTERNET | VARCHAR2 | (40) | Internet address of the number registration center | |
| NRC_DEPT | VARCHAR2 | (80) | Department of the number registration center | |
| ROUTING_REF | VARCHAR2 | (80) | Routing number reference id | |
| INTERCONNECT_TYPE | VARCHAR2 | (10) | Indicates interconnect type whether equal access or number portability | |
| ROUTING_SP_ID | NUMBER | Service provider owning the routing numbers identifying the switch used to port the number or provision a number | ||
| ROUTING_NUMBER | VARCHAR2 | (20) | The switch to which the numbers can be ported | |
| ROUTING_STATUS | VARCHAR2 | (10) | Status for routing number | |
| COMMENTS | VARCHAR2 | (1996) | Comments for subscription version | |
| NOTES | VARCHAR2 | (1996) | Notes for subscription version |
Cut, paste (and edit) the following text to query this object:
SELECT SV_SOA_ID
, PORTING_ID
, SUBSCRIPTION_TN
, SUBSCRIPTION_TYPE
, DONOR_SP_ID
, RECIPIENT_SP_ID
, STATUS_TYPE_CODE
, PTO_FLAG
, CREATED_BY_SP_ID
, CHANGED_BY_SP_ID
, MEDIATOR_SP_ID
, ROUTING_NUMBER_ID
, PRE_SPLIT_SUBSCRIPTION_TN
, PREV_STATUS_TYPE_CODE
, CNAM_ADDRESS
, CNAM_SUBSYSTEM
, ISVM_ADDRESS
, ISVM_SUBSYSTEM
, LIDB_ADDRESS
, LIDB_SUBSYSTEM
, CLASS_ADDRESS
, CLASS_SUBSYSTEM
, WSMSC_ADDRESS
, WSMSC_SUBSYSTEM
, RN_ADDRESS
, RN_SUBSYSTEM
, ACTIVATION_DUE_DATE
, NEW_SP_DUE_DATE
, OLD_SP_DUE_DATE
, OLD_SP_CUTOFF_DUE_DATE
, EFFECTIVE_RELEASE_DUE_DATE
, NUMBER_RETURNED_DUE_DATE
, DISCONNECT_DUE_DATE
, INVOICE_DUE_DATE
, STATUS_CHANGE_DATE
, CREATED_DATE
, MODIFIED_DATE
, CONCURRENCE_FLAG
, NEW_SP_AUTHORIZATION_FLAG
, OLD_SP_AUTHORIZATION_FLAG
, RETAIN_DIR_INFO_FLAG
, RETAIN_TN_FLAG
, BLOCKED_FLAG
, LOCKED_FLAG
, CUSTOMER_CONTACT_REQ_FLAG
, BILLING_ID
, USER_LOCTN_VALUE
, USER_LOCTN_TYPE
, CHARGING_INFO
, ORDER_PRIORITY
, STATUS_CHANGE_CAUSE_CODE
, PREORDER_AUTHORIZATION_CODE
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_TYPE
, CONTACT_NAME
, ADDRESS_LINE1
, ADDRESS_LINE2
, CITY
, STATE
, ZIP_CODE
, COUNTRY
, PHONE
, MOBILE
, FAX
, PAGER
, PAGER_PIN
, EMAIL
, INTERNET_ADDRESS
, PRICE_CODE
, PRICE_PER_CALL
, PRICE_PER_MINUTE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, STATUS_PHASE
, STATUS_DISPLAY_NAME
, STATUS_DESC
, DON_SP_TYPE
, DON_CODE
, DON_NAME
, DON_TIMEZONE
, DON_SERVED_BY_FLAG
, DON_ADDRESS_LINE1
, DON_CITY
, DON_STATE
, DON_ZIP_CODE
, DON_COUNTRY
, DON_PHONE
, DON_ADDRESS_LINE2
, DON_MOBILE
, DON_FAX
, DON_PAGER
, DON_PAGER_PIN
, DON_EMAIL
, DON_INTERNET
, DON_DEPT
, REC_SP_TYPE
, REC_CODE
, REC_NAME
, REC_TIMEZONE
, REC_SERVED_BY_FLAG
, REC_ADDRESS_LINE1
, REC_CITY
, REC_STATE
, REC_ZIP_CODE
, REC_COUNTRY
, REC_PHONE
, REC_ADDRESS_LINE2
, REC_MOBILE
, REC_FAX
, REC_PAGER
, REC_PAGER_PIN
, REC_EMAIL
, REC_INTERNET
, REC_DEPT
, NRC_SP_TYPE
, NRC_CODE
, NRC_NAME
, NRC_TIMEZONE
, NRC_SERVED_BY_FLAG
, NRC_ADDRESS_LINE1
, NRC_CITY
, NRC_STATE
, NRC_ZIP_CODE
, NRC_COUNTRY
, NRC_PHONE
, NRC_ADDRESS_LINE2
, NRC_MOBILE
, NRC_FAX
, NRC_PAGER
, NRC_PAGER_PIN
, NRC_EMAIL
, NRC_INTERNET
, NRC_DEPT
, ROUTING_REF
, INTERCONNECT_TYPE
, ROUTING_SP_ID
, ROUTING_NUMBER
, ROUTING_STATUS
, COMMENTS
, NOTES
FROM APPS.XNP_SV_SOA_VL;
APPS
XNP_ROUTING_NUMBERS
XNP_SERVICE_PROVIDERS
XNP_SV_SOA
XNP_SV_STATUS_TYPES_B
XNP_SV_STATUS_TYPES_TL
APPS
XNP_SV_ORDERS$SOA_SV
- show dependent code
XNP_WEB_UTILS
- show dependent code
|
|
|
|