IBY_SYS_PMT_PROFILES_VL

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_FORMAT_CODE 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 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 PI_REGISTER_FORMAT AUTOMATIC_PI_REG_SUBMIT 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 START_DATE END_DATE LOGICAL_GROUPING_MODE BATCH_BOOKING_FLAG SERVICE_LEVEL_CODE DELIVERY_CHANNEL_CODE AUTO_RECORD_PRINTED_PMTS_FLAG

Query

SQL_Statement

SELECT B.SYSTEM_PROFILE_CODE, T.SYSTEM_PROFILE_NAME, T.SYSTEM_PROFILE_DESCRIPTION, B.BEPID, B.SECURITY_PROTOCOL_CODE, B.TRANSMIT_PROTOCOL_CODE, B.PAYMENT_FORMAT_CODE, B.POSITIVE_PAY_FORMAT_CODE, B.PAY_FILE_LETTER_FORMAT_CODE, B.PRINT_INSTRUCTION_IMMED_FLAG, B.TRANSMIT_INSTR_IMMED_FLAG, B.DEFAULT_PRINTER, B.DEFAULT_PAYMENT_DOCUMENT_ID, B.PERIODIC_SEQUENCE_NAME_1, B.PERIODIC_SEQUENCE_NAME_2, B.PERIODIC_SEQUENCE_NAME_3, B.PROCESSING_TYPE, B.MARK_COMPLETE_EVENT, B.MANUAL_MARK_COMPLETE_FLAG, B.POSITIVE_PAY_DELIVERY_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.DECLARATION_OPTION, B.DCL_ONLY_FOREIGN_CURR_PMT_FLAG, B.DECLARATION_REPORT_FORMAT_CODE, B.DECLARATION_CURR_FX_RATE_TYPE, B.DECLARATION_CURRENCY_CODE, B.DECLARATION_THRESHOLD_AMOUNT, B.BANK_INSTRUCTION1_CODE, B.BANK_INSTRUCTION2_CODE, B.BANK_INSTRUCTION_DETAILS, B.PAYMENT_TEXT_MESSAGE1, B.PAYMENT_TEXT_MESSAGE2, B.INACTIVE_DATE, B.ACK_TRANSMIT_PROTOCOL_CODE, B.ACK_SECURITY_PROTOCOL_CODE, B.SEEDED_FLAG, B.SEND_TO_FILE_FLAG, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.PI_REGISTER_FORMAT, B.AUTOMATIC_PI_REG_SUBMIT, B.OUTBOUND_PMT_FILE_DIRECTORY, B.OUTBOUND_PMT_FILE_EXTENSION, B.OUTBOUND_PMT_FILE_PREFIX, B.POSITIVE_PAY_FILE_DIRECTORY, B.POSITIVE_PAY_FILE_EXTENSION, B.POSITIVE_PAY_FILE_PREFIX, B.ELECTRONIC_PROCESSING_CHANNEL, B.START_DATE, B.END_DATE, B.LOGICAL_GROUPING_MODE, B.BATCH_BOOKING_FLAG, B.SERVICE_LEVEL_CODE, B.DELIVERY_CHANNEL_CODE, B.AUTO_RECORD_PRINTED_PMTS_FLAG FROM IBY_SYS_PMT_PROFILES_TL T, IBY_SYS_PMT_PROFILES_B B WHERE B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE AND T.LANGUAGE = USERENV('LANG')