eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: XNP.XNP_AUDIT_DISCREPANCIES#

Source

View Text - Preformatted


select AUDIT_DISCREPANCY_ID AUDIT_DISCREPANCY_ID, AUDIT_ID AUDIT_ID, SP_ID SP_ID, SUBSCRIPTION_TN SUBSCRIPTION_TN, ERROR_CODE ERROR_CODE, ROUTING_NUMBER ROUTING_NUMBER, 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, EXT_ROUTING_NUMBER EXT_ROUTING_NUMBER, EXT_CNAM_ADDRESS EXT_CNAM_ADDRESS, EXT_CNAM_SUBSYSTEM EXT_CNAM_SUBSYSTEM, EXT_ISVM_ADDRESS EXT_ISVM_ADDRESS, EXT_ISVM_SUBSYSTEM EXT_ISVM_SUBSYSTEM, EXT_LIDB_ADDRESS EXT_LIDB_ADDRESS, EXT_LIDB_SUBSYSTEM EXT_LIDB_SUBSYSTEM, EXT_CLASS_ADDRESS EXT_CLASS_ADDRESS, EXT_CLASS_SUBSYSTEM EXT_CLASS_SUBSYSTEM, EXT_WSMSC_ADDRESS EXT_WSMSC_ADDRESS, EXT_WSMSC_SUBSYSTEM EXT_WSMSC_SUBSYSTEM, EXT_RN_ADDRESS EXT_RN_ADDRESS, EXT_RN_SUBSYSTEM EXT_RN_SUBSYSTEM, 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 from "XNP"."XNP_AUDIT_DISCREPANCIES"

View Text - HTML Formatted

SELECT AUDIT_DISCREPANCY_ID AUDIT_DISCREPANCY_ID
, AUDIT_ID AUDIT_ID
, SP_ID SP_ID
, SUBSCRIPTION_TN SUBSCRIPTION_TN
, ERROR_CODE ERROR_CODE
, ROUTING_NUMBER ROUTING_NUMBER
, 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
, EXT_ROUTING_NUMBER EXT_ROUTING_NUMBER
, EXT_CNAM_ADDRESS EXT_CNAM_ADDRESS
, EXT_CNAM_SUBSYSTEM EXT_CNAM_SUBSYSTEM
, EXT_ISVM_ADDRESS EXT_ISVM_ADDRESS
, EXT_ISVM_SUBSYSTEM EXT_ISVM_SUBSYSTEM
, EXT_LIDB_ADDRESS EXT_LIDB_ADDRESS
, EXT_LIDB_SUBSYSTEM EXT_LIDB_SUBSYSTEM
, EXT_CLASS_ADDRESS EXT_CLASS_ADDRESS
, EXT_CLASS_SUBSYSTEM EXT_CLASS_SUBSYSTEM
, EXT_WSMSC_ADDRESS EXT_WSMSC_ADDRESS
, EXT_WSMSC_SUBSYSTEM EXT_WSMSC_SUBSYSTEM
, EXT_RN_ADDRESS EXT_RN_ADDRESS
, EXT_RN_SUBSYSTEM EXT_RN_SUBSYSTEM
, 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
FROM "XNP"."XNP_AUDIT_DISCREPANCIES"