VIEW: AP.AP_TRANSMISSIONS_SETUP#

Source

View Text - Preformatted

select TRANSMISSION_ID TRANSMISSION_ID, TRANSMISSION_CODE TRANSMISSION_CODE, BANK_BRANCH_ID BANK_BRANCH_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TRANSMISSION_PROGRAM TRANSMISSION_PROGRAM, USERNAME USERNAME, PASSWORD PASSWORD, PROTOCOL PROTOCOL, PROTOCOL_ADDRESS PROTOCOL_ADDRESS, EXTERNAL_IDENTIFIER EXTERNAL_IDENTIFIER, TRANSMISSION_EMAIL TRANSMISSION_EMAIL, CONFIRMATION_EMAIL CONFIRMATION_EMAIL, STATEMENT_EMAIL STATEMENT_EMAIL, EXCEPTION_EMAIL EXCEPTION_EMAIL, LOCAL_PAY_DIRECTORY LOCAL_PAY_DIRECTORY, LOCAL_CONF_DIRECTORY LOCAL_CONF_DIRECTORY, LOCAL_STMT_DIRECTORY LOCAL_STMT_DIRECTORY, LOCAL_EXCEPTION_DIRECTORY LOCAL_EXCEPTION_DIRECTORY, BANK_PAY_DIRECTORY BANK_PAY_DIRECTORY, BANK_CONF_DIRECTORY BANK_CONF_DIRECTORY, BANK_STMT_DIRECTORY BANK_STMT_DIRECTORY, BANK_EXCEPTION_DIRECTORY BANK_EXCEPTION_DIRECTORY, PAY_FILE_EXT PAY_FILE_EXT, PAY_FILE_PREFIX PAY_FILE_PREFIX, PAY_FILE_SUFFIX PAY_FILE_SUFFIX, CONF_FILE_EXT CONF_FILE_EXT, CONF_FILE_PREFIX CONF_FILE_PREFIX, CONF_FILE_SUFFIX CONF_FILE_SUFFIX, STMT_FILE_EXT STMT_FILE_EXT, STMT_FILE_PREFIX STMT_FILE_PREFIX, STMT_FILE_SUFFIX STMT_FILE_SUFFIX, EXCEPTION_FILE_EXT EXCEPTION_FILE_EXT, EXCEPTION_FILE_PREFIX EXCEPTION_FILE_PREFIX, EXCEPTION_FILE_SUFFIX EXCEPTION_FILE_SUFFIX, INTRA_STATEMENT_EMAIL INTRA_STATEMENT_EMAIL, LOCAL_INTRA_DIRECTORY LOCAL_INTRA_DIRECTORY, BANK_INTRA_DIRECTORY BANK_INTRA_DIRECTORY, INTRA_FILE_EXT INTRA_FILE_EXT, INTRA_FILE_PREFIX INTRA_FILE_PREFIX, INTRA_FILE_SUFFIX INTRA_FILE_SUFFIX, XTR_TRANSMISSION_EMAIL XTR_TRANSMISSION_EMAIL, XTR_CONFIRMATION_EMAIL XTR_CONFIRMATION_EMAIL, XTR_LOCAL_PAY_DIR XTR_LOCAL_PAY_DIR, XTR_LOCAL_CONF_DIR XTR_LOCAL_CONF_DIR, XTR_BANK_PAY_DIR XTR_BANK_PAY_DIR, XTR_BANK_CONF_DIR XTR_BANK_CONF_DIR, XTR_PAY_FILE_EXT XTR_PAY_FILE_EXT, XTR_PAY_FILE_PREFIX XTR_PAY_FILE_PREFIX, XTR_PAY_FILE_SUFFIX XTR_PAY_FILE_SUFFIX, XTR_CONF_FILE_EXT XTR_CONF_FILE_EXT, XTR_CONF_FILE_PREFIX XTR_CONF_FILE_PREFIX, XTR_CONF_FILE_SUFFIX XTR_CONF_FILE_SUFFIX from "AP"."AP_TRANSMISSIONS_SETUP"

View Text - HTML Formatted

SELECT TRANSMISSION_ID TRANSMISSION_ID
, TRANSMISSION_CODE TRANSMISSION_CODE
, BANK_BRANCH_ID BANK_BRANCH_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TRANSMISSION_PROGRAM TRANSMISSION_PROGRAM
, USERNAME USERNAME
, PASSWORD PASSWORD
, PROTOCOL PROTOCOL
, PROTOCOL_ADDRESS PROTOCOL_ADDRESS
, EXTERNAL_IDENTIFIER EXTERNAL_IDENTIFIER
, TRANSMISSION_EMAIL TRANSMISSION_EMAIL
, CONFIRMATION_EMAIL CONFIRMATION_EMAIL
, STATEMENT_EMAIL STATEMENT_EMAIL
, EXCEPTION_EMAIL EXCEPTION_EMAIL
, LOCAL_PAY_DIRECTORY LOCAL_PAY_DIRECTORY
, LOCAL_CONF_DIRECTORY LOCAL_CONF_DIRECTORY
, LOCAL_STMT_DIRECTORY LOCAL_STMT_DIRECTORY
, LOCAL_EXCEPTION_DIRECTORY LOCAL_EXCEPTION_DIRECTORY
, BANK_PAY_DIRECTORY BANK_PAY_DIRECTORY
, BANK_CONF_DIRECTORY BANK_CONF_DIRECTORY
, BANK_STMT_DIRECTORY BANK_STMT_DIRECTORY
, BANK_EXCEPTION_DIRECTORY BANK_EXCEPTION_DIRECTORY
, PAY_FILE_EXT PAY_FILE_EXT
, PAY_FILE_PREFIX PAY_FILE_PREFIX
, PAY_FILE_SUFFIX PAY_FILE_SUFFIX
, CONF_FILE_EXT CONF_FILE_EXT
, CONF_FILE_PREFIX CONF_FILE_PREFIX
, CONF_FILE_SUFFIX CONF_FILE_SUFFIX
, STMT_FILE_EXT STMT_FILE_EXT
, STMT_FILE_PREFIX STMT_FILE_PREFIX
, STMT_FILE_SUFFIX STMT_FILE_SUFFIX
, EXCEPTION_FILE_EXT EXCEPTION_FILE_EXT
, EXCEPTION_FILE_PREFIX EXCEPTION_FILE_PREFIX
, EXCEPTION_FILE_SUFFIX EXCEPTION_FILE_SUFFIX
, INTRA_STATEMENT_EMAIL INTRA_STATEMENT_EMAIL
, LOCAL_INTRA_DIRECTORY LOCAL_INTRA_DIRECTORY
, BANK_INTRA_DIRECTORY BANK_INTRA_DIRECTORY
, INTRA_FILE_EXT INTRA_FILE_EXT
, INTRA_FILE_PREFIX INTRA_FILE_PREFIX
, INTRA_FILE_SUFFIX INTRA_FILE_SUFFIX
, XTR_TRANSMISSION_EMAIL XTR_TRANSMISSION_EMAIL
, XTR_CONFIRMATION_EMAIL XTR_CONFIRMATION_EMAIL
, XTR_LOCAL_PAY_DIR XTR_LOCAL_PAY_DIR
, XTR_LOCAL_CONF_DIR XTR_LOCAL_CONF_DIR
, XTR_BANK_PAY_DIR XTR_BANK_PAY_DIR
, XTR_BANK_CONF_DIR XTR_BANK_CONF_DIR
, XTR_PAY_FILE_EXT XTR_PAY_FILE_EXT
, XTR_PAY_FILE_PREFIX XTR_PAY_FILE_PREFIX
, XTR_PAY_FILE_SUFFIX XTR_PAY_FILE_SUFFIX
, XTR_CONF_FILE_EXT XTR_CONF_FILE_EXT
, XTR_CONF_FILE_PREFIX XTR_CONF_FILE_PREFIX
, XTR_CONF_FILE_SUFFIX XTR_CONF_FILE_SUFFIX
FROM "AP"."AP_TRANSMISSIONS_SETUP"