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

TABLE: XNP.XNP_SV_SOA_JN

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


XNP_SV_SOA_JN is a journalling table for the XNP_SV_SOA table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
JN_OPERATION VARCHAR2 (3) Yes Action taken on table XNP_SV_SOA
JN_ORACLE_USER VARCHAR2 (30) Yes User which take action on table XNP_SV_SOA
JN_DATETIME DATE
Yes Timestamp when action was taken on table XNP_SV_SOA
JN_NOTES VARCHAR2 (240)
Notes for action which was taken on table XNP_SV_SOA
JN_APPLN VARCHAR2 (30)
Application which was used to take action on table XNP_SV_SOA
JN_SESSION NUMBER (38)
Session which was used to take action on table XNP_SV_SOA
SV_SOA_ID NUMBER
Yes SOA initiated subscription version identifier
OBJECT_REFERENCE VARCHAR2 (80)
Porting Identifier
SUBSCRIPTION_TN VARCHAR2 (20)
Subscription Telephone Number
SUBSCRIPTION_TYPE VARCHAR2 (10)
Indicates the portability type which is either Equal Access or Number Portability.
DONOR_SP_ID NUMBER

For Equal Access , this is long distance service provider and for Number Portability, this is local Service Provider
RECIPIENT_SP_ID NUMBER

For Equal Access , this is long distance service provider. For NP, this is local service provider
STATUS_TYPE_CODE VARCHAR2 (20)
Status Code
PTO_FLAG VARCHAR2 (1)
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
MEDIATOR_SP_ID NUMBER

For Equal Access, it indicates local Service Provider and for Number Portability indicates Number Registration Centre
CHANGED_BY_SP_ID NUMBER

Applicable to NRC when aaceptance 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
ROUTING_NUMBER_ID NUMBER

Routing number identifier for the subscription telephone number given by the receipient 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 Mai 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 application subsystem for this 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 on which the number is to be returned to the original Service provider
DISCONNECT_DUE_DATE DATE

Date that 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)
Indicates 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 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 contact person
ADDRESS_LINE2 VARCHAR2 (400)
Street address of the 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 the contact person
PHONE VARCHAR2 (20)
Phone number of the contact person
MOBILE VARCHAR2 (20)
Cellular number of the contact person
FAX VARCHAR2 (20)
Fax number of the contact person
PAGER VARCHAR2 (20)
Pager number of the contact person
PAGER_PIN VARCHAR2 (80)
Pager pin number of the contact person
EMAIL VARCHAR2 (80)
Email address of the contact person
INTERNET_ADDRESS VARCHAR2 (40)
Web address of the 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)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

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 JN_OPERATION
,      JN_ORACLE_USER
,      JN_DATETIME
,      JN_NOTES
,      JN_APPLN
,      JN_SESSION
,      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
,      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_JN;

Dependencies

[top of page]

XNP.XNP_SV_SOA_JN does not reference any database object

XNP.XNP_SV_SOA_JN is referenced by following:

SchemaXNP
ViewXNP_SV_SOA_JN#