IBY_PAYMENT_PROFILES

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

SYSTEM_PROFILE_CODE SYSTEM_PROFILE_NAME SYSTEM_PROFILE_DESCRIPTION BEPID SECURITY_PROTOCOL_CODE TRANSMIT_PROTOCOL_CODE PAYMENT_FORMAT_CODE POSITIVE_PAY_FORMAT_CODE PAY_FILE_LETTER_FORMAT_CODE PRINT_INSTRUCTION_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG DEFAULT_PRINTER DEFAULT_PAYMENT_DOCUMENT_ID PERIODIC_SEQUENCE_NAME_1 PERIODIC_SEQUENCE_NAME_2 PERIODIC_SEQUENCE_NAME_3 PROCESSING_TYPE MARK_COMPLETE_EVENT MANUAL_MARK_COMPLETE_FLAG POSITIVE_PAY_DELIVERY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DECLARATION_OPTION DCL_ONLY_FOREIGN_CURR_PMT_FLAG DECLARATION_REPORT_NAME DECLARATION_CURR_FX_RATE_TYPE DECLARATION_CURRENCY_CODE DECLARATION_THRESHOLD_AMOUNT BANK_INSTRUCTION1_CODE BANK_INSTRUCTION2_CODE BANK_INSTRUCTION_DETAILS PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE2 INACTIVE_DATE START_DATE END_DATE ACK_TRANSMIT_PROTOCOL_CODE ACK_SECURITY_PROTOCOL_CODE SEEDED_FLAG SEND_TO_FILE_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 PAYMENT_PROFILE_ID PAYMENT_PROFILE_NAME BEP_ACCOUNT_ID SECURITY_CONFIGURATION_ID TRANSMIT_CONFIGURATION_ID RESET_VALUE_1 LAST_USED_NUMBER_1 RESET_REQUEST_1 RESET_VALUE_2 LAST_USED_NUMBER_2 RESET_REQUEST_2 RESET_VALUE_3 LAST_USED_NUMBER_3 RESET_REQUEST_3 ACK_SEC_CONFIG_ID ACK_TRANSMIT_CONFIG_ID OUTBOUND_PMT_FILE_DIRECTORY OUTBOUND_PMT_FILE_EXTENSION OUTBOUND_PMT_FILE_PREFIX POSITIVE_PAY_FILE_DIRECTORY POSITIVE_PAY_FILE_EXTENSION POSITIVE_PAY_FILE_PREFIX ELECTRONIC_PROCESSING_CHANNEL BATCH_BOOKING_FLAG SERVICE_LEVEL_CODE DELIVERY_CHANNEL_CODE

Query

SQL_Statement

SELECT s.SYSTEM_PROFILE_CODE, s.SYSTEM_PROFILE_NAME, s.SYSTEM_PROFILE_DESCRIPTION, s.BEPID, s.SECURITY_PROTOCOL_CODE, s.TRANSMIT_PROTOCOL_CODE, s.PAYMENT_FORMAT_CODE, s.POSITIVE_PAY_FORMAT_CODE, s.PAY_FILE_LETTER_FORMAT_CODE, s.PRINT_INSTRUCTION_IMMED_FLAG, s.TRANSMIT_INSTR_IMMED_FLAG, s.DEFAULT_PRINTER, s.DEFAULT_PAYMENT_DOCUMENT_ID, s.PERIODIC_SEQUENCE_NAME_1, s.PERIODIC_SEQUENCE_NAME_2, s.PERIODIC_SEQUENCE_NAME_3, s.PROCESSING_TYPE, s.MARK_COMPLETE_EVENT, s.MANUAL_MARK_COMPLETE_FLAG, s.POSITIVE_PAY_DELIVERY_FLAG, s.CREATED_BY, s.CREATION_DATE, s.LAST_UPDATED_BY, s.LAST_UPDATE_DATE, s.LAST_UPDATE_LOGIN, s.OBJECT_VERSION_NUMBER, s.DECLARATION_OPTION, s.DCL_ONLY_FOREIGN_CURR_PMT_FLAG, s.DECLARATION_REPORT_FORMAT_CODE DECLARATION_REPORT_NAME, s.DECLARATION_CURR_FX_RATE_TYPE, s.DECLARATION_CURRENCY_CODE, s.DECLARATION_THRESHOLD_AMOUNT, s.BANK_INSTRUCTION1_CODE, s.BANK_INSTRUCTION2_CODE, s.BANK_INSTRUCTION_DETAILS, s.PAYMENT_TEXT_MESSAGE1, s.PAYMENT_TEXT_MESSAGE2, s.INACTIVE_DATE, DECODE(SIGN(s.START_DATE - a.START_DATE), 1, s.START_DATE, a.START_DATE) START_DATE, DECODE(SIGN(s.END_DATE - a.END_DATE), 1, a.END_DATE, s.END_DATE) END_DATE, s.ACK_TRANSMIT_PROTOCOL_CODE, s.ACK_SECURITY_PROTOCOL_CODE, s.SEEDED_FLAG, s.SEND_TO_FILE_FLAG, s.ATTRIBUTE_CATEGORY, s.ATTRIBUTE1, s.ATTRIBUTE2, s.ATTRIBUTE3, s.ATTRIBUTE4, s.ATTRIBUTE5, s.ATTRIBUTE6, s.ATTRIBUTE7, s.ATTRIBUTE8, s.ATTRIBUTE9, s.ATTRIBUTE10, s.ATTRIBUTE11, s.ATTRIBUTE12, s.ATTRIBUTE13, s.ATTRIBUTE14, s.ATTRIBUTE15, a.PAYMENT_PROFILE_ID, a.PAYMENT_PROFILE_NAME, a.BEP_ACCOUNT_ID, a.SECURITY_CONFIGURATION_ID, a.TRANSMIT_CONFIGURATION_ID, a.RESET_VALUE_1, a.LAST_USED_NUMBER_1, a.RESET_REQUEST_1, a.RESET_VALUE_2, a.LAST_USED_NUMBER_2, a.RESET_REQUEST_2, a.RESET_VALUE_3, a.LAST_USED_NUMBER_3, a.RESET_REQUEST_3, a.ACK_SEC_CONFIG_ID, a.ACK_TRANSMIT_CONFIG_ID, s.OUTBOUND_PMT_FILE_DIRECTORY, s.OUTBOUND_PMT_FILE_EXTENSION, s.OUTBOUND_PMT_FILE_PREFIX, s.POSITIVE_PAY_FILE_DIRECTORY, s.POSITIVE_PAY_FILE_EXTENSION, s.POSITIVE_PAY_FILE_PREFIX, s.ELECTRONIC_PROCESSING_CHANNEL, s.BATCH_BOOKING_FLAG, s.SERVICE_LEVEL_CODE, s.DELIVERY_CHANNEL_CODE FROM IBY_SYS_PMT_PROFILES_VL s, IBY_ACCT_PMT_PROFILES_VL a WHERE s.SYSTEM_PROFILE_CODE = a.SYSTEM_PROFILE_CODE(+)