eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	XNP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_SV_SOA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SV_SOA_ID
XNP_SV_SOA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTING_NUMBER_ID
XNP_SV_SOA_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBSCRIPTION_TN
XNP_SV_SOA_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DONOR_SP_ID
XNP_SV_SOA_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECIPIENT_SP_ID
XNP_SV_SOA_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGED_BY_SP_ID
XNP_SV_SOA_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEDIATOR_SP_ID
XNP_SV_SOA_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_TYPE_CODE
XNP_SV_SOA_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREV_STATUS_TYPE_CODE
XNP_SV_SOA_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_REFERENCE
XNP_SV_SOA_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBSCRIPTION_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:

XNP: XNP_SV_SOA#