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

VIEW: XNP.XNP_SV_SMS#

Object Details
Object Name: XNP_SV_SMS#
Object Type: VIEW
Owner: XNP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SV_SMS_ID NUMBER
Yes
OBJECT_REFERENCE VARCHAR2 (80) Yes
ROUTING_NUMBER_ID NUMBER
Yes
SUBSCRIPTION_TN VARCHAR2 (20) Yes
SUBSCRIPTION_TYPE VARCHAR2 (10) Yes
MEDIATOR_SP_ID NUMBER

PROVISION_SENT_DATE DATE

PROVISION_DONE_DATE DATE

CNAM_ADDRESS VARCHAR2 (80)
CNAM_SUBSYSTEM VARCHAR2 (80)
ISVM_ADDRESS VARCHAR2 (80)
ISVM_SUBSYSTEM VARCHAR2 (80)
LIDB_ADDRESS VARCHAR2 (80)
LIDB_SUBSYSTEM VARCHAR2 (80)
CLASS_ADDRESS VARCHAR2 (80)
CLASS_SUBSYSTEM VARCHAR2 (80)
WSMSC_ADDRESS VARCHAR2 (80)
WSMSC_SUBSYSTEM VARCHAR2 (80)
RN_ADDRESS VARCHAR2 (80)
RN_SUBSYSTEM VARCHAR2 (80)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT SV_SMS_ID
,      OBJECT_REFERENCE
,      ROUTING_NUMBER_ID
,      SUBSCRIPTION_TN
,      SUBSCRIPTION_TYPE
,      MEDIATOR_SP_ID
,      PROVISION_SENT_DATE
,      PROVISION_DONE_DATE
,      CNAM_ADDRESS
,      CNAM_SUBSYSTEM
,      ISVM_ADDRESS
,      ISVM_SUBSYSTEM
,      LIDB_ADDRESS
,      LIDB_SUBSYSTEM
,      CLASS_ADDRESS
,      CLASS_SUBSYSTEM
,      WSMSC_ADDRESS
,      WSMSC_SUBSYSTEM
,      RN_ADDRESS
,      RN_SUBSYSTEM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_SV_SMS#;

Dependencies

[top of page]

XNP.XNP_SV_SMS# references the following:

SchemaXNP
TableXNP_SV_SMS
XNP.XNP_SV_SMS# is referenced by following:

SchemaAPPS
SynonymXNP_SV_SMS