VIEW: APPS.IBY_UPG_PPP_VL

Source

View Text - Preformatted

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.logical_grouping_mode, b.batch_booking_flag, b.inst_group_by_payment_method, 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, b.inactive_date 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')

View Text - HTML Formatted

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.LOGICAL_GROUPING_MODE
, B.BATCH_BOOKING_FLAG
, B.INST_GROUP_BY_PAYMENT_METHOD
, 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
, B.INACTIVE_DATE
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')