VIEW: APPS.IBY_PAYMENT_PROFILES

Source

View Text - Preformatted

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.logical_grouping_mode, s.batch_booking_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 , 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 , DECODE(s.inactive_date, null, a.inactive_date, (DECODE(a.inactive_date, null, s.inactive_date, DECODE(SIGN(s.inactive_date-a.inactive_date), 1, a.inactive_date, s.inactive_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.disallow_save_print_flag FROM IBY_SYS_PMT_PROFILES_VL S,IBY_ACCT_PMT_PROFILES_VL A WHERE s.system_profile_code = a.system_profile_code(+)

View Text - HTML Formatted

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.LOGICAL_GROUPING_MODE
, S.BATCH_BOOKING_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
, 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
, DECODE(S.INACTIVE_DATE
, NULL
, A.INACTIVE_DATE
, (DECODE(A.INACTIVE_DATE
, NULL
, S.INACTIVE_DATE
, DECODE(SIGN(S.INACTIVE_DATE-A.INACTIVE_DATE)
, 1
, A.INACTIVE_DATE
, S.INACTIVE_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.DISALLOW_SAVE_PRINT_FLAG
FROM IBY_SYS_PMT_PROFILES_VL S
, IBY_ACCT_PMT_PROFILES_VL A
WHERE S.SYSTEM_PROFILE_CODE = A.SYSTEM_PROFILE_CODE(+)