VIEW: APPS.IBY_PAYMENTS_SEC_V

Source

View Text - Preformatted

SELECT iby_pay.paper_document_number paper_document_number, iby_pay.bank_assigned_ref_code bank_assigned_ref_code, iby_pay.external_bank_account_id external_bank_account_id, iby_pay.document_sequence_id document_sequence_id, iby_pay.document_sequence_value document_sequence_value, iby_pay.document_category_code document_category_code, iby_pay.unique_remittance_identifier unique_remittance_identifier, iby_pay.uri_check_digit uri_check_digit, iby_pay.bank_instruction1_code bank_instruction1_code, iby_pay.bank_instruction2_code bank_instruction2_code, iby_pay.payment_text_message1 payment_text_message1, iby_pay.payment_text_message2 payment_text_message2, iby_pay.payment_text_message3 payment_text_message3, iby_pay.bill_payable_flag bill_payable_flag, iby_pay.maturity_date maturity_date, iby_pay.payment_due_date payment_due_date, iby_pay.stop_request_placed_flag stop_request_placed_flag, iby_pay.stop_request_reason stop_request_reason, iby_pay.stop_request_placed_by stop_request_placed_by, iby_pay.stop_request_date stop_request_date, iby_pay.stop_request_reference stop_request_reference, iby_pay.stop_released_flag stop_released_flag, iby_pay.stop_release_reason stop_release_reason, iby_pay.stop_released_by stop_released_by, iby_pay.stop_release_date stop_release_date, iby_pay.stop_release_reference stop_release_reference, iby_pay.stop_confirmed_flag stop_confirmed_flag, iby_pay.stop_confirm_reason stop_confirm_reason, iby_pay.stop_confirmed_by stop_confirmed_by, iby_pay.stop_confirm_date stop_confirm_date, iby_pay.stop_confirm_reference stop_confirm_reference, iby_pay.void_reason void_reason, iby_pay.voided_by voided_by, iby_pay.void_date void_date, iby_pay.remit_to_location_id, iby_pay.attribute_category attribute_category, iby_pay.attribute1 attribute1, iby_pay.attribute2 attribute2, iby_pay.attribute3 attribute3, iby_pay.attribute4 attribute4, iby_pay.attribute5 attribute5, iby_pay.attribute6 attribute6, iby_pay.attribute7 attribute7, iby_pay.attribute8 attribute8, iby_pay.attribute9 attribute9, iby_pay.attribute10 attribute10, iby_pay.attribute11 attribute11, iby_pay.attribute12 attribute12, iby_pay.attribute13 attribute13, iby_pay.attribute14 attribute14, iby_pay.attribute15 attribute15, iby_pay.payment_id payment_id, iby_pay.payment_method_code payment_method_code, iby_pay.payment_service_request_id payment_service_request_id, iby_pay.process_type process_type, iby_pay.payment_status payment_status, iby_pay.payments_complete_flag payments_complete_flag, iby_pay.payment_function payment_function, iby_pay.payment_amount payment_amount, iby_pay.payment_currency_code payment_currency_code, iby_pay.separate_remit_advice_req_flag separate_remit_advice_req_flag, iby_pay.internal_bank_account_id internal_bank_account_id, iby_pay.supplier_site_id supplier_site_id, iby_pay.payee_party_id payee_party_id, iby_pay.party_site_id party_site_id, iby_pay.declare_payment_flag declare_payment_flag, iby_pay.declaration_amount declaration_amount, iby_pay.declaration_currency_code declaration_currency_code, iby_pay.discount_amount_taken discount_amount_taken, iby_pay.payment_details payment_details, iby_pay.bank_charge_bearer bank_charge_bearer, iby_pay.bank_charge_amount bank_charge_amount, iby_pay.delivery_channel_code delivery_channel_code, iby_pay.settlement_priority settlement_priority, iby_pay.remittance_message1 remittance_message1, iby_pay.remittance_message2 remittance_message2, iby_pay.remittance_message3 remittance_message3, iby_pay.payment_reference_number payment_reference_number, iby_pay.org_type org_type, iby_pay.legal_entity_id legal_entity_id, iby_pay.ext_payee_id ext_payee_id, iby_pay.org_id org_id, iby_pay.pregrouped_payment_flag pregrouped_payment_flag, iby_pay.created_by created_by, iby_pay.creation_date creation_date, iby_pay.last_updated_by last_updated_by, iby_pay.last_update_date last_update_date, iby_pay.last_update_login last_update_login, iby_pay.object_version_number object_version_number, iby_pay.payment_profile_id payment_profile_id, iby_pay.payment_instruction_id payment_instruction_id, iby_pay.payment_reason_code payment_reason_code, iby_pay.payment_reason_comments payment_reason_comments, iby_pay.payment_date payment_date, iby_pay.anticipated_value_date anticipated_value_date, iby_pay.completed_pmts_group_id completed_pmts_group_id, iby_pay.ext_branch_number ext_branch_number, iby_pay.ext_bank_number ext_bank_number, iby_pay.ext_bank_account_name ext_bank_account_name, iby_pay.ext_bank_account_number ext_bank_account_number, iby_pay.ext_bank_account_type ext_bank_account_type, iby_pay.ext_bank_account_iban_number ext_bank_account_iban_number, iby_pay.payee_name payee_name, iby_pay.payee_address1 payee_address1, iby_pay.payee_address2 payee_address2, iby_pay.payee_address3 payee_address3, iby_pay.payee_address4 payee_address4, iby_pay.payee_city payee_city, iby_pay.payee_postal_code payee_postal_code, iby_pay.payee_state payee_state, iby_pay.payee_province payee_province, iby_pay.payee_county payee_county, iby_pay.payee_country payee_country, iby_pay.request_id request_id FROM IBY_PAYMENTS_ALL IBY_PAY WHERE (iby_pay.org_id = -1) OR ((iby_pay.org_id <> -1) and (iby_pay.org_id, iby_pay.org_type) IN (SELECT ce.organization_id, ce.organization_type FROM ce_security_profiles_v ce) AND iby_pay.payment_function IN (SELECT fu.payment_function FROM iby_user_pay_funs_sec_v fu))

View Text - HTML Formatted

SELECT IBY_PAY.PAPER_DOCUMENT_NUMBER PAPER_DOCUMENT_NUMBER
, IBY_PAY.BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, IBY_PAY.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ID
, IBY_PAY.DOCUMENT_SEQUENCE_VALUE DOCUMENT_SEQUENCE_VALUE
, IBY_PAY.DOCUMENT_CATEGORY_CODE DOCUMENT_CATEGORY_CODE
, IBY_PAY.UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER
, IBY_PAY.URI_CHECK_DIGIT URI_CHECK_DIGIT
, IBY_PAY.BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE
, IBY_PAY.BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE
, IBY_PAY.PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1
, IBY_PAY.PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2
, IBY_PAY.PAYMENT_TEXT_MESSAGE3 PAYMENT_TEXT_MESSAGE3
, IBY_PAY.BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, IBY_PAY.MATURITY_DATE MATURITY_DATE
, IBY_PAY.PAYMENT_DUE_DATE PAYMENT_DUE_DATE
, IBY_PAY.STOP_REQUEST_PLACED_FLAG STOP_REQUEST_PLACED_FLAG
, IBY_PAY.STOP_REQUEST_REASON STOP_REQUEST_REASON
, IBY_PAY.STOP_REQUEST_PLACED_BY STOP_REQUEST_PLACED_BY
, IBY_PAY.STOP_REQUEST_DATE STOP_REQUEST_DATE
, IBY_PAY.STOP_REQUEST_REFERENCE STOP_REQUEST_REFERENCE
, IBY_PAY.STOP_RELEASED_FLAG STOP_RELEASED_FLAG
, IBY_PAY.STOP_RELEASE_REASON STOP_RELEASE_REASON
, IBY_PAY.STOP_RELEASED_BY STOP_RELEASED_BY
, IBY_PAY.STOP_RELEASE_DATE STOP_RELEASE_DATE
, IBY_PAY.STOP_RELEASE_REFERENCE STOP_RELEASE_REFERENCE
, IBY_PAY.STOP_CONFIRMED_FLAG STOP_CONFIRMED_FLAG
, IBY_PAY.STOP_CONFIRM_REASON STOP_CONFIRM_REASON
, IBY_PAY.STOP_CONFIRMED_BY STOP_CONFIRMED_BY
, IBY_PAY.STOP_CONFIRM_DATE STOP_CONFIRM_DATE
, IBY_PAY.STOP_CONFIRM_REFERENCE STOP_CONFIRM_REFERENCE
, IBY_PAY.VOID_REASON VOID_REASON
, IBY_PAY.VOIDED_BY VOIDED_BY
, IBY_PAY.VOID_DATE VOID_DATE
, IBY_PAY.REMIT_TO_LOCATION_ID
, IBY_PAY.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IBY_PAY.ATTRIBUTE1 ATTRIBUTE1
, IBY_PAY.ATTRIBUTE2 ATTRIBUTE2
, IBY_PAY.ATTRIBUTE3 ATTRIBUTE3
, IBY_PAY.ATTRIBUTE4 ATTRIBUTE4
, IBY_PAY.ATTRIBUTE5 ATTRIBUTE5
, IBY_PAY.ATTRIBUTE6 ATTRIBUTE6
, IBY_PAY.ATTRIBUTE7 ATTRIBUTE7
, IBY_PAY.ATTRIBUTE8 ATTRIBUTE8
, IBY_PAY.ATTRIBUTE9 ATTRIBUTE9
, IBY_PAY.ATTRIBUTE10 ATTRIBUTE10
, IBY_PAY.ATTRIBUTE11 ATTRIBUTE11
, IBY_PAY.ATTRIBUTE12 ATTRIBUTE12
, IBY_PAY.ATTRIBUTE13 ATTRIBUTE13
, IBY_PAY.ATTRIBUTE14 ATTRIBUTE14
, IBY_PAY.ATTRIBUTE15 ATTRIBUTE15
, IBY_PAY.PAYMENT_ID PAYMENT_ID
, IBY_PAY.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, IBY_PAY.PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, IBY_PAY.PROCESS_TYPE PROCESS_TYPE
, IBY_PAY.PAYMENT_STATUS PAYMENT_STATUS
, IBY_PAY.PAYMENTS_COMPLETE_FLAG PAYMENTS_COMPLETE_FLAG
, IBY_PAY.PAYMENT_FUNCTION PAYMENT_FUNCTION
, IBY_PAY.PAYMENT_AMOUNT PAYMENT_AMOUNT
, IBY_PAY.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, IBY_PAY.SEPARATE_REMIT_ADVICE_REQ_FLAG SEPARATE_REMIT_ADVICE_REQ_FLAG
, IBY_PAY.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, IBY_PAY.PAYEE_PARTY_ID PAYEE_PARTY_ID
, IBY_PAY.PARTY_SITE_ID PARTY_SITE_ID
, IBY_PAY.DECLARE_PAYMENT_FLAG DECLARE_PAYMENT_FLAG
, IBY_PAY.DECLARATION_AMOUNT DECLARATION_AMOUNT
, IBY_PAY.DECLARATION_CURRENCY_CODE DECLARATION_CURRENCY_CODE
, IBY_PAY.DISCOUNT_AMOUNT_TAKEN DISCOUNT_AMOUNT_TAKEN
, IBY_PAY.PAYMENT_DETAILS PAYMENT_DETAILS
, IBY_PAY.BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, IBY_PAY.BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, IBY_PAY.DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, IBY_PAY.SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, IBY_PAY.REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, IBY_PAY.REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, IBY_PAY.REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, IBY_PAY.PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER
, IBY_PAY.ORG_TYPE ORG_TYPE
, IBY_PAY.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, IBY_PAY.EXT_PAYEE_ID EXT_PAYEE_ID
, IBY_PAY.ORG_ID ORG_ID
, IBY_PAY.PREGROUPED_PAYMENT_FLAG PREGROUPED_PAYMENT_FLAG
, IBY_PAY.CREATED_BY CREATED_BY
, IBY_PAY.CREATION_DATE CREATION_DATE
, IBY_PAY.LAST_UPDATED_BY LAST_UPDATED_BY
, IBY_PAY.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IBY_PAY.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IBY_PAY.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IBY_PAY.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, IBY_PAY.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, IBY_PAY.PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, IBY_PAY.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, IBY_PAY.PAYMENT_DATE PAYMENT_DATE
, IBY_PAY.ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE
, IBY_PAY.COMPLETED_PMTS_GROUP_ID COMPLETED_PMTS_GROUP_ID
, IBY_PAY.EXT_BRANCH_NUMBER EXT_BRANCH_NUMBER
, IBY_PAY.EXT_BANK_NUMBER EXT_BANK_NUMBER
, IBY_PAY.EXT_BANK_ACCOUNT_NAME EXT_BANK_ACCOUNT_NAME
, IBY_PAY.EXT_BANK_ACCOUNT_NUMBER EXT_BANK_ACCOUNT_NUMBER
, IBY_PAY.EXT_BANK_ACCOUNT_TYPE EXT_BANK_ACCOUNT_TYPE
, IBY_PAY.EXT_BANK_ACCOUNT_IBAN_NUMBER EXT_BANK_ACCOUNT_IBAN_NUMBER
, IBY_PAY.PAYEE_NAME PAYEE_NAME
, IBY_PAY.PAYEE_ADDRESS1 PAYEE_ADDRESS1
, IBY_PAY.PAYEE_ADDRESS2 PAYEE_ADDRESS2
, IBY_PAY.PAYEE_ADDRESS3 PAYEE_ADDRESS3
, IBY_PAY.PAYEE_ADDRESS4 PAYEE_ADDRESS4
, IBY_PAY.PAYEE_CITY PAYEE_CITY
, IBY_PAY.PAYEE_POSTAL_CODE PAYEE_POSTAL_CODE
, IBY_PAY.PAYEE_STATE PAYEE_STATE
, IBY_PAY.PAYEE_PROVINCE PAYEE_PROVINCE
, IBY_PAY.PAYEE_COUNTY PAYEE_COUNTY
, IBY_PAY.PAYEE_COUNTRY PAYEE_COUNTRY
, IBY_PAY.REQUEST_ID REQUEST_ID
FROM IBY_PAYMENTS_ALL IBY_PAY
WHERE (IBY_PAY.ORG_ID = -1) OR ((IBY_PAY.ORG_ID <> -1)
AND (IBY_PAY.ORG_ID
, IBY_PAY.ORG_TYPE) IN (SELECT CE.ORGANIZATION_ID
, CE.ORGANIZATION_TYPE
FROM CE_SECURITY_PROFILES_V CE)
AND IBY_PAY.PAYMENT_FUNCTION IN (SELECT FU.PAYMENT_FUNCTION
FROM IBY_USER_PAY_FUNS_SEC_V FU))