VIEW: APPS.IBY_SYS_PMT_PROFILES_VL

Source

View Text - Preformatted

SELECT b.rowid , 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.logical_grouping_mode, b.batch_booking_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.disallow_save_print_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')

View Text - HTML Formatted

SELECT B.ROWID
, 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.LOGICAL_GROUPING_MODE
, B.BATCH_BOOKING_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.DISALLOW_SAVE_PRINT_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')