[Home] [Help] [Dependency Information]
Object Name: | XNP_SV_SOA_JN# |
---|---|
Object Type: | VIEW |
Owner: | XNP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JN_OPERATION | VARCHAR2 | (3) | Yes | |
JN_ORACLE_USER | VARCHAR2 | (30) | Yes | |
JN_DATETIME | DATE | Yes | ||
JN_NOTES | VARCHAR2 | (240) | ||
JN_APPLN | VARCHAR2 | (30) | ||
JN_SESSION | NUMBER | (38) | ||
SV_SOA_ID | NUMBER | Yes | ||
OBJECT_REFERENCE | VARCHAR2 | (80) | ||
SUBSCRIPTION_TN | VARCHAR2 | (20) | ||
SUBSCRIPTION_TYPE | VARCHAR2 | (10) | ||
DONOR_SP_ID | NUMBER | |||
RECIPIENT_SP_ID | NUMBER | |||
STATUS_TYPE_CODE | VARCHAR2 | (20) | ||
PTO_FLAG | VARCHAR2 | (1) | ||
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) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
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 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#;
|
|
|