VIEW: XNP.XNP_SV_AUDITS#

Source

View Text - Preformatted

select SV_AUDIT_ID SV_AUDIT_ID, OBJECT_REFERENCE OBJECT_REFERENCE, SP_ID SP_ID, AUDIT_NAME AUDIT_NAME, AUDIT_TYPE AUDIT_TYPE, STATUS_CODE STATUS_CODE, STARTING_NUMBER STARTING_NUMBER, ENDING_NUMBER ENDING_NUMBER, FOR_SP_ID FOR_SP_ID, NUMBER_OF_TN_AUDITED NUMBER_OF_TN_AUDITED, ACTIVATION_START_DATE ACTIVATION_START_DATE, ACTIVATION_END_DATE ACTIVATION_END_DATE, NOTES NOTES, ROUTING_NUMBER_FLAG ROUTING_NUMBER_FLAG, CNAM_FLAG CNAM_FLAG, ISVM_FLAG ISVM_FLAG, LIDB_FLAG LIDB_FLAG, CLASS_FLAG CLASS_FLAG, WSMSC_FLAG WSMSC_FLAG, RN_FLAG RN_FLAG, 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_SV_AUDITS"

View Text - HTML Formatted

SELECT SV_AUDIT_ID SV_AUDIT_ID
, OBJECT_REFERENCE OBJECT_REFERENCE
, SP_ID SP_ID
, AUDIT_NAME AUDIT_NAME
, AUDIT_TYPE AUDIT_TYPE
, STATUS_CODE STATUS_CODE
, STARTING_NUMBER STARTING_NUMBER
, ENDING_NUMBER ENDING_NUMBER
, FOR_SP_ID FOR_SP_ID
, NUMBER_OF_TN_AUDITED NUMBER_OF_TN_AUDITED
, ACTIVATION_START_DATE ACTIVATION_START_DATE
, ACTIVATION_END_DATE ACTIVATION_END_DATE
, NOTES NOTES
, ROUTING_NUMBER_FLAG ROUTING_NUMBER_FLAG
, CNAM_FLAG CNAM_FLAG
, ISVM_FLAG ISVM_FLAG
, LIDB_FLAG LIDB_FLAG
, CLASS_FLAG CLASS_FLAG
, WSMSC_FLAG WSMSC_FLAG
, RN_FLAG RN_FLAG
, 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_SV_AUDITS"