[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XNP_SV_SOA# |
|---|---|
| Object Type: | VIEW |
| Owner: | XNP |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SV_SOA_ID | NUMBER | Yes | ||
| OBJECT_REFERENCE | VARCHAR2 | (80) | Yes | |
| SUBSCRIPTION_TN | VARCHAR2 | (20) | Yes | |
| SUBSCRIPTION_TYPE | VARCHAR2 | (10) | Yes | |
| DONOR_SP_ID | NUMBER | Yes | ||
| RECIPIENT_SP_ID | NUMBER | Yes | ||
| STATUS_TYPE_CODE | VARCHAR2 | (20) | Yes | |
| PTO_FLAG | VARCHAR2 | (1) | Yes | |
| CREATED_BY_SP_ID | NUMBER | |||
| MEDIATOR_SP_ID | NUMBER | |||
| CHANGED_BY_SP_ID | NUMBER | |||
| ROUTING_NUMBER_ID | NUMBER | |||
| PRE_SPLIT_SUBSCRIPTION_TN | VARCHAR2 | (20) | ||
| PREV_STATUS_TYPE_CODE | VARCHAR2 | (20) | ||
| 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) | ||
| ACTIVATION_DUE_DATE | DATE | |||
| NEW_SP_DUE_DATE | DATE | |||
| OLD_SP_DUE_DATE | DATE | |||
| OLD_SP_CUTOFF_DUE_DATE | DATE | |||
| EFFECTIVE_RELEASE_DUE_DATE | DATE | |||
| NUMBER_RETURNED_DUE_DATE | DATE | |||
| DISCONNECT_DUE_DATE | DATE | |||
| INVOICE_DUE_DATE | DATE | |||
| STATUS_CHANGE_DATE | DATE | |||
| CREATED_DATE | DATE | |||
| MODIFIED_DATE | DATE | |||
| CONCURRENCE_FLAG | VARCHAR2 | (1) | ||
| NEW_SP_AUTHORIZATION_FLAG | VARCHAR2 | (1) | ||
| OLD_SP_AUTHORIZATION_FLAG | VARCHAR2 | (1) | ||
| RETAIN_DIR_INFO_FLAG | VARCHAR2 | (1) | ||
| RETAIN_TN_FLAG | VARCHAR2 | (1) | ||
| BLOCKED_FLAG | VARCHAR2 | (1) | ||
| LOCKED_FLAG | VARCHAR2 | (1) | ||
| CUSTOMER_CONTACT_REQ_FLAG | VARCHAR2 | (1) | ||
| BILLING_ID | NUMBER | |||
| USER_LOCTN_VALUE | VARCHAR2 | (80) | ||
| USER_LOCTN_TYPE | VARCHAR2 | (20) | ||
| CHARGING_INFO | VARCHAR2 | (1996) | ||
| ORDER_PRIORITY | VARCHAR2 | (30) | ||
| STATUS_CHANGE_CAUSE_CODE | VARCHAR2 | (20) | ||
| PREORDER_AUTHORIZATION_CODE | VARCHAR2 | (20) | ||
| CUSTOMER_ID | VARCHAR2 | (80) | ||
| CUSTOMER_NAME | VARCHAR2 | (80) | ||
| CUSTOMER_TYPE | VARCHAR2 | (10) | ||
| CONTACT_NAME | VARCHAR2 | (80) | ||
| ADDRESS_LINE1 | VARCHAR2 | (400) | ||
| ADDRESS_LINE2 | VARCHAR2 | (400) | ||
| CITY | VARCHAR2 | (40) | ||
| STATE | VARCHAR2 | (40) | ||
| ZIP_CODE | VARCHAR2 | (20) | ||
| COUNTRY | VARCHAR2 | (40) | ||
| PHONE | VARCHAR2 | (20) | ||
| MOBILE | VARCHAR2 | (20) | ||
| FAX | VARCHAR2 | (20) | ||
| PAGER | VARCHAR2 | (20) | ||
| PAGER_PIN | VARCHAR2 | (80) | ||
| VARCHAR2 | (80) | |||
| INTERNET_ADDRESS | VARCHAR2 | (40) | ||
| PRICE_CODE | VARCHAR2 | (20) | ||
| PRICE_PER_CALL | NUMBER | (15) | ||
| PRICE_PER_MINUTE | NUMBER | (15) | ||
| COMMENTS | VARCHAR2 | (1996) | ||
| NOTES | VARCHAR2 | (1996) | ||
| 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 | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| ATTRIBUTE16 | VARCHAR2 | (240) | ||
| ATTRIBUTE17 | VARCHAR2 | (240) | ||
| ATTRIBUTE18 | VARCHAR2 | (240) | ||
| ATTRIBUTE19 | VARCHAR2 | (240) | ||
| ATTRIBUTE20 | VARCHAR2 | (240) |
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#;
XNP
XNP_SV_SOA
APPS
XNP_SVA_ARD
XNP_SVA_ARI
XNP_SVA_ARU
XNP_SV_SOA
|
|
|
|