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

TABLE: XNP.XNP_SV_SOA

Object Details
Object Name: XNP_SV_SOA
Object Type: TABLE
Owner: XNP
FND Design Data: TableXNP.XNP_SV_SOA
Subobject Name:
Status: VALID


XNP_SV_SOA contains a log of all subscription versions created. This entity will also service subscription version queries and contains a local copy of NRC porting data for a given SP.
In case of a service bureau, this entity contains all subscription versions created by its members.
The five vertical services that are associated with a telephone line are included in the table. Services may include Caller Naming (CNAM), Integrated Services Voice Mail (ISVM), Line Information Databases (LIDB) for calling card verification, Custom Local Area Signaling Services (CLASS) and Wireless Short Message Service Center (WSMSC).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XNP_SV_SOA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSV_SOA_ID
XNP_SV_SOA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROUTING_NUMBER_ID
XNP_SV_SOA_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBSCRIPTION_TN
XNP_SV_SOA_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDONOR_SP_ID
XNP_SV_SOA_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECIPIENT_SP_ID
XNP_SV_SOA_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANGED_BY_SP_ID
XNP_SV_SOA_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMEDIATOR_SP_ID
XNP_SV_SOA_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_TYPE_CODE
XNP_SV_SOA_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREV_STATUS_TYPE_CODE
XNP_SV_SOA_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_REFERENCE
XNP_SV_SOA_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBSCRIPTION_TYPE
Columns
Name Datatype Length Mandatory Comments
SV_SOA_ID NUMBER
Yes SOA initiated subscription version identifier
OBJECT_REFERENCE VARCHAR2 (80) Yes Porting identifier
SUBSCRIPTION_TN VARCHAR2 (20) Yes Subscription version telephone number.
SUBSCRIPTION_TYPE VARCHAR2 (10) Yes Indicates the portability type of 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 for Number Portability , this is local service provider
STATUS_TYPE_CODE VARCHAR2 (20) Yes Status Code
PTO_FLAG VARCHAR2 (1) Yes Indicates if the porting is to the original service provider.
CREATED_BY_SP_ID NUMBER

Service provider who created the SOA subscription version. Applicable both for Number Registration Center and Service Bureau.
MEDIATOR_SP_ID NUMBER

For Equal Access , indicates local service provider and for Number Portability indicates Number Registration Center
CHANGED_BY_SP_ID NUMBER

Service provider identifier who last requested a change on the subscription version.
ROUTING_NUMBER_ID NUMBER

Routing number identifier for the subscription telephone number assigned 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 the subscription version status is updated
CNAM_ADDRESS VARCHAR2 (80)
Caller Naming network address for the subscription version
CNAM_SUBSYSTEM VARCHAR2 (80)
Caller Naming application subsystem for this subscription version
ISVM_ADDRESS VARCHAR2 (80)
Integrated Sevices Voice Mail network address for this subscription version
ISVM_SUBSYSTEM VARCHAR2 (80)
Integrated Sevices Voice Mail application subsystem for the 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 the subscription should be activated
NEW_SP_DUE_DATE DATE

Due date planned by the new service provider for transfer of service
OLD_SP_DUE_DATE DATE

Due date planned by the 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 when the number should be returned to the original service provider
DISCONNECT_DUE_DATE DATE

Date the customer's service should 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 receipient 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 should be retained
RETAIN_TN_FLAG VARCHAR2 (1)
Indicates if subscription should be retained
BLOCKED_FLAG VARCHAR2 (1)
Indicates if the subscription telephone number is blocked or not
LOCKED_FLAG VARCHAR2 (1)
Indicates if subscription is locked
CUSTOMER_CONTACT_REQ_FLAG VARCHAR2 (1)
Indicates 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 contact person
ADDRESS_LINE1 VARCHAR2 (400)
Street address of contact person
ADDRESS_LINE2 VARCHAR2 (400)
Street address of contact person
CITY VARCHAR2 (40)
City of the contact person.
STATE VARCHAR2 (40)
State of the contact person.
ZIP_CODE VARCHAR2 (20)
Zip code.
COUNTRY VARCHAR2 (40)
Country of contact person.
PHONE VARCHAR2 (20)
Phone number of contact person
MOBILE VARCHAR2 (20)
Cellular number of contact person
FAX VARCHAR2 (20)
Fax number of contact person
PAGER VARCHAR2 (20)
Pager number of the contact person
PAGER_PIN VARCHAR2 (80)
Pager pin number of contact person
EMAIL VARCHAR2 (80)
Email id of contact person
INTERNET_ADDRESS VARCHAR2 (40)
Web address of the customer.
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
COMMENTS VARCHAR2 (1996)
Comments for subscription version
NOTES VARCHAR2 (1996)
Notes for subscription version
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
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute Category
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexvfeld
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexvfeld
Query Text

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


SELECT SV_SOA_ID
,      OBJECT_REFERENCE
,      SUBSCRIPTION_TN
,      SUBSCRIPTION_TYPE
,      DONOR_SP_ID
,      RECIPIENT_SP_ID
,      STATUS_TYPE_CODE
,      PTO_FLAG
,      CREATED_BY_SP_ID
,      MEDIATOR_SP_ID
,      CHANGED_BY_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
,      COMMENTS
,      NOTES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM XNP.XNP_SV_SOA;

Dependencies

[top of page]

XNP.XNP_SV_SOA does not reference any database object

XNP.XNP_SV_SOA is referenced by following:

SchemaAPPS
TriggerXNP_SVA_ARD
TriggerXNP_SVA_ARI
TriggerXNP_SVA_ARU
SynonymXNP_SV_SOA