VIEW: XNP.XNP_SV_SOA_JN#

Source

View Text - Preformatted

select JN_OPERATION JN_OPERATION, JN_ORACLE_USER JN_ORACLE_USER, JN_DATETIME JN_DATETIME, JN_NOTES JN_NOTES, JN_APPLN JN_APPLN, JN_SESSION JN_SESSION, SV_SOA_ID SV_SOA_ID, OBJECT_REFERENCE OBJECT_REFERENCE, SUBSCRIPTION_TN SUBSCRIPTION_TN, SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE, DONOR_SP_ID DONOR_SP_ID, RECIPIENT_SP_ID RECIPIENT_SP_ID, STATUS_TYPE_CODE STATUS_TYPE_CODE, PTO_FLAG PTO_FLAG, CREATED_BY_SP_ID CREATED_BY_SP_ID, MEDIATOR_SP_ID MEDIATOR_SP_ID, CHANGED_BY_SP_ID CHANGED_BY_SP_ID, ROUTING_NUMBER_ID ROUTING_NUMBER_ID, PRE_SPLIT_SUBSCRIPTION_TN PRE_SPLIT_SUBSCRIPTION_TN, PREV_STATUS_TYPE_CODE PREV_STATUS_TYPE_CODE, CNAM_ADDRESS CNAM_ADDRESS, CNAM_SUBSYSTEM CNAM_SUBSYSTEM, ISVM_ADDRESS ISVM_ADDRESS, ISVM_SUBSYSTEM ISVM_SUBSYSTEM, LIDB_ADDRESS LIDB_ADDRESS, LIDB_SUBSYSTEM LIDB_SUBSYSTEM, CLASS_ADDRESS CLASS_ADDRESS, CLASS_SUBSYSTEM CLASS_SUBSYSTEM, WSMSC_ADDRESS WSMSC_ADDRESS, WSMSC_SUBSYSTEM WSMSC_SUBSYSTEM, RN_ADDRESS RN_ADDRESS, RN_SUBSYSTEM RN_SUBSYSTEM, ACTIVATION_DUE_DATE ACTIVATION_DUE_DATE, NEW_SP_DUE_DATE NEW_SP_DUE_DATE, OLD_SP_DUE_DATE OLD_SP_DUE_DATE, OLD_SP_CUTOFF_DUE_DATE OLD_SP_CUTOFF_DUE_DATE, EFFECTIVE_RELEASE_DUE_DATE EFFECTIVE_RELEASE_DUE_DATE, NUMBER_RETURNED_DUE_DATE NUMBER_RETURNED_DUE_DATE, DISCONNECT_DUE_DATE DISCONNECT_DUE_DATE, INVOICE_DUE_DATE INVOICE_DUE_DATE, STATUS_CHANGE_DATE STATUS_CHANGE_DATE, CREATED_DATE CREATED_DATE, MODIFIED_DATE MODIFIED_DATE, CONCURRENCE_FLAG CONCURRENCE_FLAG, NEW_SP_AUTHORIZATION_FLAG NEW_SP_AUTHORIZATION_FLAG, OLD_SP_AUTHORIZATION_FLAG OLD_SP_AUTHORIZATION_FLAG, RETAIN_DIR_INFO_FLAG RETAIN_DIR_INFO_FLAG, RETAIN_TN_FLAG RETAIN_TN_FLAG, BLOCKED_FLAG BLOCKED_FLAG, LOCKED_FLAG LOCKED_FLAG, CUSTOMER_CONTACT_REQ_FLAG CUSTOMER_CONTACT_REQ_FLAG, BILLING_ID BILLING_ID, USER_LOCTN_VALUE USER_LOCTN_VALUE, USER_LOCTN_TYPE USER_LOCTN_TYPE, CHARGING_INFO CHARGING_INFO, ORDER_PRIORITY ORDER_PRIORITY, STATUS_CHANGE_CAUSE_CODE STATUS_CHANGE_CAUSE_CODE, PREORDER_AUTHORIZATION_CODE PREORDER_AUTHORIZATION_CODE, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_TYPE CUSTOMER_TYPE, CONTACT_NAME CONTACT_NAME, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, CITY CITY, STATE STATE, ZIP_CODE ZIP_CODE, COUNTRY COUNTRY, PHONE PHONE, MOBILE MOBILE, FAX FAX, PAGER PAGER, PAGER_PIN PAGER_PIN, EMAIL EMAIL, INTERNET_ADDRESS INTERNET_ADDRESS, PRICE_CODE PRICE_CODE, PRICE_PER_CALL PRICE_PER_CALL, PRICE_PER_MINUTE PRICE_PER_MINUTE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20 from "XNP"."XNP_SV_SOA_JN"

View Text - HTML Formatted

SELECT JN_OPERATION JN_OPERATION
, JN_ORACLE_USER JN_ORACLE_USER
, JN_DATETIME JN_DATETIME
, JN_NOTES JN_NOTES
, JN_APPLN JN_APPLN
, JN_SESSION JN_SESSION
, SV_SOA_ID SV_SOA_ID
, OBJECT_REFERENCE OBJECT_REFERENCE
, SUBSCRIPTION_TN SUBSCRIPTION_TN
, SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE
, DONOR_SP_ID DONOR_SP_ID
, RECIPIENT_SP_ID RECIPIENT_SP_ID
, STATUS_TYPE_CODE STATUS_TYPE_CODE
, PTO_FLAG PTO_FLAG
, CREATED_BY_SP_ID CREATED_BY_SP_ID
, MEDIATOR_SP_ID MEDIATOR_SP_ID
, CHANGED_BY_SP_ID CHANGED_BY_SP_ID
, ROUTING_NUMBER_ID ROUTING_NUMBER_ID
, PRE_SPLIT_SUBSCRIPTION_TN PRE_SPLIT_SUBSCRIPTION_TN
, PREV_STATUS_TYPE_CODE PREV_STATUS_TYPE_CODE
, CNAM_ADDRESS CNAM_ADDRESS
, CNAM_SUBSYSTEM CNAM_SUBSYSTEM
, ISVM_ADDRESS ISVM_ADDRESS
, ISVM_SUBSYSTEM ISVM_SUBSYSTEM
, LIDB_ADDRESS LIDB_ADDRESS
, LIDB_SUBSYSTEM LIDB_SUBSYSTEM
, CLASS_ADDRESS CLASS_ADDRESS
, CLASS_SUBSYSTEM CLASS_SUBSYSTEM
, WSMSC_ADDRESS WSMSC_ADDRESS
, WSMSC_SUBSYSTEM WSMSC_SUBSYSTEM
, RN_ADDRESS RN_ADDRESS
, RN_SUBSYSTEM RN_SUBSYSTEM
, ACTIVATION_DUE_DATE ACTIVATION_DUE_DATE
, NEW_SP_DUE_DATE NEW_SP_DUE_DATE
, OLD_SP_DUE_DATE OLD_SP_DUE_DATE
, OLD_SP_CUTOFF_DUE_DATE OLD_SP_CUTOFF_DUE_DATE
, EFFECTIVE_RELEASE_DUE_DATE EFFECTIVE_RELEASE_DUE_DATE
, NUMBER_RETURNED_DUE_DATE NUMBER_RETURNED_DUE_DATE
, DISCONNECT_DUE_DATE DISCONNECT_DUE_DATE
, INVOICE_DUE_DATE INVOICE_DUE_DATE
, STATUS_CHANGE_DATE STATUS_CHANGE_DATE
, CREATED_DATE CREATED_DATE
, MODIFIED_DATE MODIFIED_DATE
, CONCURRENCE_FLAG CONCURRENCE_FLAG
, NEW_SP_AUTHORIZATION_FLAG NEW_SP_AUTHORIZATION_FLAG
, OLD_SP_AUTHORIZATION_FLAG OLD_SP_AUTHORIZATION_FLAG
, RETAIN_DIR_INFO_FLAG RETAIN_DIR_INFO_FLAG
, RETAIN_TN_FLAG RETAIN_TN_FLAG
, BLOCKED_FLAG BLOCKED_FLAG
, LOCKED_FLAG LOCKED_FLAG
, CUSTOMER_CONTACT_REQ_FLAG CUSTOMER_CONTACT_REQ_FLAG
, BILLING_ID BILLING_ID
, USER_LOCTN_VALUE USER_LOCTN_VALUE
, USER_LOCTN_TYPE USER_LOCTN_TYPE
, CHARGING_INFO CHARGING_INFO
, ORDER_PRIORITY ORDER_PRIORITY
, STATUS_CHANGE_CAUSE_CODE STATUS_CHANGE_CAUSE_CODE
, PREORDER_AUTHORIZATION_CODE PREORDER_AUTHORIZATION_CODE
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_TYPE CUSTOMER_TYPE
, CONTACT_NAME CONTACT_NAME
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, CITY CITY
, STATE STATE
, ZIP_CODE ZIP_CODE
, COUNTRY COUNTRY
, PHONE PHONE
, MOBILE MOBILE
, FAX FAX
, PAGER PAGER
, PAGER_PIN PAGER_PIN
, EMAIL EMAIL
, INTERNET_ADDRESS INTERNET_ADDRESS
, PRICE_CODE PRICE_CODE
, PRICE_PER_CALL PRICE_PER_CALL
, PRICE_PER_MINUTE PRICE_PER_MINUTE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
FROM "XNP"."XNP_SV_SOA_JN"