IBY_UPG_PPP_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

SYSTEM_PROFILE_CODE BEP_SUFFIX SECURITY_PROTOCOL_CODE TRANSMIT_PROTOCOL_CODE PAYMENT_FORMAT_CODE POSITIVE_PAY_FORMAT_CODE PAY_FILE_LETTER_FORMAT_CODE PRINT_INSTRUCTION_IMMED_FLAG 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 TRANSMIT_INSTR_IMMED_FLAG AUTOMATIC_PI_REG_SUBMIT 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 ACK_TRANSMIT_PROTOCOL_CODE ACK_SECURITY_PROTOCOL_CODE SEND_TO_FILE_FLAG PI_REGISTER_FORMAT BEP_ACCOUNT_ID APPLICABLE_PMT_METHOD APPLICABLE_CURRENCY APPLICABLE_PAYER_ORG APPLICABLE_INT_BANK_ACCOUNT PMT_GROUP_BY_PAYMENT_DETAILS PMT_GROUP_BY_BANK_CHARGE_BEAR PMT_GROUP_BY_DELIVERY_CHANNEL PMT_GROUP_BY_REMITTANCE_MES PMT_GROUP_BY_MAX_DOCUMENTS PMT_GROUP_BY_UNIQUE_REMIT_ID PMT_GROUP_BY_SETTLE_PRIORITY PMT_GROUP_BY_PAYMENT_REASON PMT_GROUP_BY_DUE_DATE_FLAG PMT_MAX_DOCUMENTS_PER_PAYMENT PMT_PAYMENT_DETAILS_LENGTH_LIM PMT_PAYMENT_DETAILS_FORMULA INST_GROUP_BY_PAYMENT_DATE INST_GROUP_BY_PAYMENT_CURRENCY INST_GROUP_BY_INT_BANK_ACCT INST_GROUP_BY_MAX_PAYMENTS INST_GROUP_BY_PAY_SERVICE_REQ INST_GROUP_BY_LEGAL_ENTITY INST_GROUP_BY_BILL_PAYABLE INST_GROUP_BY_MAX_INSTRUCTION INST_GROUP_BY_ORGANIZATION INST_GROUP_BY_PAYMENT_FUNCTION INST_GROUP_BY_PAYMENT_REASON INST_GROUP_BY_RFC INST_MAX_PAYMENTS_PER_INSTR INST_MAX_AMOUNT_PER_INSTR_VAL INST_MAX_AMOUNT_PER_INSTR_CURR INST_MAX_AMOUNT_FX_RATE_TYPE INST_SORT_OPTION_1 INST_SORT_ORDER_1 INST_SORT_OPTION_2 INST_SORT_ORDER_2 INST_SORT_OPTION_3 INST_SORT_ORDER_3 REMIT_DOCUMENT_COUNT_LIMIT REMIT_ALLOW_MULTIPLE_COPY_FLAG REMIT_PMT_DETAILS_LENGTH_LIM REMIT_REMITTANCE_ADVICE_FORMAT REMIT_SRA_OVERRIDE_PAYEE_FLAG REMIT_ADVICE_DELIVERY_METHOD REMIT_AUTOMATIC_SRA_SUBMIT SYSTEM_PROFILE_NAME SYSTEM_PROFILE_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ELECTRONIC_PROCESSING_CHANNEL

Query

SQL_Statement

SELECT b.system_profile_code, b.bep_suffix, 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.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.transmit_instr_immed_flag, b.automatic_pi_reg_submit, 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.ack_transmit_protocol_code, b.ack_security_protocol_code, b.send_to_file_flag, b.pi_register_format, b.bep_account_id, b.applicable_pmt_method, b.applicable_currency, b.applicable_payer_org, b.applicable_int_bank_account, b.pmt_group_by_payment_details, b.pmt_group_by_bank_charge_bear, b.pmt_group_by_delivery_channel, b.pmt_group_by_remittance_mes, b.pmt_group_by_max_documents, b.pmt_group_by_unique_remit_id, b.pmt_group_by_settle_priority, b.pmt_group_by_payment_reason, b.pmt_group_by_due_date_flag, b.pmt_max_documents_per_payment, b.pmt_payment_details_length_lim, b.pmt_payment_details_formula, b.inst_group_by_payment_date, b.inst_group_by_payment_currency, b.inst_group_by_int_bank_acct, b.inst_group_by_max_payments, b.inst_group_by_pay_service_req, b.inst_group_by_legal_entity, b.inst_group_by_bill_payable, b.inst_group_by_max_instruction, b.inst_group_by_organization, b.inst_group_by_payment_function, b.inst_group_by_payment_reason, b.inst_group_by_rfc, b.inst_max_payments_per_instr, b.inst_max_amount_per_instr_val, b.inst_max_amount_per_instr_curr, b.inst_max_amount_fx_rate_type, b.inst_sort_option_1, b.inst_sort_order_1, b.inst_sort_option_2, b.inst_sort_order_2, b.inst_sort_option_3, b.inst_sort_order_3, b.remit_document_count_limit, b.remit_allow_multiple_copy_flag, b.remit_pmt_details_length_lim, b.remit_remittance_advice_format, b.remit_sra_override_payee_flag, b.remit_advice_delivery_method, b.remit_automatic_sra_submit, t.system_profile_name, t.system_profile_description, b.created_by, b.creation_date, b.last_update_date, b.last_updated_by, b.last_update_login, b.object_version_number, b.electronic_processing_channel FROM IBY_UPG_PPP_B B,IBY_UPG_PPP_TL T where t.system_profile_code = b.system_profile_code and T.LANGUAGE = userenv('LANG')