VIEW: APPS.IBY_FD_PAYMENTS_V

Source

View Text - Preformatted

SELECT iby_pay.completed_pmts_group_id, iby_pay.payment_reason_comments, iby_pay.payment_date, iby_pay.anticipated_value_date, iby_pay.declaration_amount, iby_pay.declaration_currency_code, iby_pay.discount_amount_taken, iby_pay.bank_charge_amount, iby_pay.settlement_priority, iby_pay.payment_id, iby_pay.payment_method_code, iby_pay.payment_service_request_id, iby_pay.process_type, iby_pay.payment_status, iby_pay.payments_complete_flag, iby_pay.payment_function, iby_pay.payment_amount, iby_pay.payment_currency_code, iby_pay.stop_confirmed_by, iby_pay.stop_confirm_date, iby_pay.stop_confirm_reason, iby_pay.stop_confirm_reference, iby_pay.stop_released_by, iby_pay.stop_release_date, iby_pay.stop_release_reason, iby_pay.stop_release_reference, iby_pay.stop_request_date, iby_pay.stop_request_placed_by, iby_pay.stop_request_reason, iby_pay.stop_request_reference, iby_pay.voided_by, iby_pay.void_date, iby_pay.void_reason, iby_pay.attribute_category, iby_pay.attribute1, iby_pay.attribute2, iby_pay.attribute3, iby_pay.attribute4, iby_pay.attribute5, iby_pay.attribute6, iby_pay.attribute7, iby_pay.attribute8, iby_pay.attribute9, iby_pay.attribute10, iby_pay.attribute11, iby_pay.attribute12, iby_pay.attribute13, iby_pay.attribute14, iby_pay.attribute15, iby_pay.stop_confirmed_flag, iby_pay.stop_released_flag, iby_pay.stop_request_placed_flag, iby_pay.created_by, iby_pay.creation_date, iby_pay.last_updated_by, iby_pay.last_update_login, iby_pay.last_update_date, iby_pay.object_version_number, iby_pay.payee_party_id, iby_pay.party_site_id, iby_pay.supplier_site_id, iby_pay.payment_reason_code, iby_pay.remit_to_location_id, iby_pay.org_id, iby_pay.org_type, iby_pay.legal_entity_id, iby_pay.declare_payment_flag, iby_pay.delivery_channel_code, iby_pay.ext_payee_id, iby_pay.payment_instruction_id, iby_pay.payment_profile_id, iby_pay.pregrouped_payment_flag, iby_pay.remittance_message1, iby_pay.remittance_message2, iby_pay.payment_details, iby_pay.bank_charge_bearer, iby_pay.separate_remit_advice_req_flag, iby_pay.internal_bank_account_id, iby_pay.bill_payable_flag, iby_pay.exclusive_payment_flag, iby_pay.remittance_message3, iby_pay.payment_reference_number, iby_pay.paper_document_number, iby_pay.bank_assigned_ref_code, iby_pay.external_bank_account_id, iby_pay.unique_remittance_identifier, iby_pay.uri_check_digit, iby_pay.bank_instruction1_code, iby_pay.bank_instruction2_code, iby_pay.bank_instruction_details, iby_pay.payment_text_message1, iby_pay.payment_text_message2, iby_pay.payment_text_message3, iby_pay.maturity_date, iby_pay.payment_due_date, iby_pay.document_category_code, iby_pay.document_sequence_id, iby_pay.ext_branch_number, iby_pay.document_sequence_value, iby_pay.ext_bank_number, iby_pay.beneficiary_party, iby_pay.ext_bank_account_name, iby_pay.ext_bank_account_number, iby_pay.ext_bank_account_type, iby_pay.ext_bank_account_iban_number, iby_pay.payee_name, iby_pay.payee_address1, iby_pay.payee_address2, iby_pay.payee_address3, iby_pay.payee_address4, iby_pay.payee_city, iby_pay.payee_postal_code, iby_pay.payee_state, iby_pay.payee_province, iby_pay.payee_county, iby_pay.payee_country, i.payment_document_id, iby_pay.address_source, iby_pay.employee_address_code, iby_pay.employee_person_id, iby_pay.employee_payment_flag, iby_pay.employee_address_id, iby_pay.request_id, iby_pay.logical_group_reference, iby_pay.ext_inv_payee_id, iby_pay.inv_payee_party_id, iby_pay.inv_party_site_id, iby_pay.inv_supplier_site_id, iby_pay.inv_beneficiary_party, iby_pay.inv_payee_name, iby_pay.inv_payee_address1, iby_pay.inv_payee_address2, iby_pay.inv_payee_address3, iby_pay.inv_payee_address4, iby_pay.inv_payee_city, iby_pay.inv_payee_postal_code, iby_pay.inv_payee_state, iby_pay.inv_payee_province, iby_pay.inv_payee_county, iby_pay.inv_payee_country, CASE WHEN (iby_pay.payee_party_id <> iby_pay.inv_payee_party_id) AND (iby_pay.supplier_site_id <> iby_pay.inv_supplier_site_id) THEN iby_fd_extract_gen_pvt.get_relship_id(iby_pay.payee_party_id, iby_pay.supplier_site_id, iby_pay.inv_payee_party_id, iby_pay.inv_supplier_site_id) ELSE NULL END relationship_id FROM IBY_PAYMENTS_ALL IBY_PAY,IBY_PAY_INSTRUCTIONS_ALL I WHERE iby_pay.payment_instruction_id = i.payment_instruction_id(+)

View Text - HTML Formatted

SELECT IBY_PAY.COMPLETED_PMTS_GROUP_ID
, IBY_PAY.PAYMENT_REASON_COMMENTS
, IBY_PAY.PAYMENT_DATE
, IBY_PAY.ANTICIPATED_VALUE_DATE
, IBY_PAY.DECLARATION_AMOUNT
, IBY_PAY.DECLARATION_CURRENCY_CODE
, IBY_PAY.DISCOUNT_AMOUNT_TAKEN
, IBY_PAY.BANK_CHARGE_AMOUNT
, IBY_PAY.SETTLEMENT_PRIORITY
, IBY_PAY.PAYMENT_ID
, IBY_PAY.PAYMENT_METHOD_CODE
, IBY_PAY.PAYMENT_SERVICE_REQUEST_ID
, IBY_PAY.PROCESS_TYPE
, IBY_PAY.PAYMENT_STATUS
, IBY_PAY.PAYMENTS_COMPLETE_FLAG
, IBY_PAY.PAYMENT_FUNCTION
, IBY_PAY.PAYMENT_AMOUNT
, IBY_PAY.PAYMENT_CURRENCY_CODE
, IBY_PAY.STOP_CONFIRMED_BY
, IBY_PAY.STOP_CONFIRM_DATE
, IBY_PAY.STOP_CONFIRM_REASON
, IBY_PAY.STOP_CONFIRM_REFERENCE
, IBY_PAY.STOP_RELEASED_BY
, IBY_PAY.STOP_RELEASE_DATE
, IBY_PAY.STOP_RELEASE_REASON
, IBY_PAY.STOP_RELEASE_REFERENCE
, IBY_PAY.STOP_REQUEST_DATE
, IBY_PAY.STOP_REQUEST_PLACED_BY
, IBY_PAY.STOP_REQUEST_REASON
, IBY_PAY.STOP_REQUEST_REFERENCE
, IBY_PAY.VOIDED_BY
, IBY_PAY.VOID_DATE
, IBY_PAY.VOID_REASON
, IBY_PAY.ATTRIBUTE_CATEGORY
, IBY_PAY.ATTRIBUTE1
, IBY_PAY.ATTRIBUTE2
, IBY_PAY.ATTRIBUTE3
, IBY_PAY.ATTRIBUTE4
, IBY_PAY.ATTRIBUTE5
, IBY_PAY.ATTRIBUTE6
, IBY_PAY.ATTRIBUTE7
, IBY_PAY.ATTRIBUTE8
, IBY_PAY.ATTRIBUTE9
, IBY_PAY.ATTRIBUTE10
, IBY_PAY.ATTRIBUTE11
, IBY_PAY.ATTRIBUTE12
, IBY_PAY.ATTRIBUTE13
, IBY_PAY.ATTRIBUTE14
, IBY_PAY.ATTRIBUTE15
, IBY_PAY.STOP_CONFIRMED_FLAG
, IBY_PAY.STOP_RELEASED_FLAG
, IBY_PAY.STOP_REQUEST_PLACED_FLAG
, IBY_PAY.CREATED_BY
, IBY_PAY.CREATION_DATE
, IBY_PAY.LAST_UPDATED_BY
, IBY_PAY.LAST_UPDATE_LOGIN
, IBY_PAY.LAST_UPDATE_DATE
, IBY_PAY.OBJECT_VERSION_NUMBER
, IBY_PAY.PAYEE_PARTY_ID
, IBY_PAY.PARTY_SITE_ID
, IBY_PAY.SUPPLIER_SITE_ID
, IBY_PAY.PAYMENT_REASON_CODE
, IBY_PAY.REMIT_TO_LOCATION_ID
, IBY_PAY.ORG_ID
, IBY_PAY.ORG_TYPE
, IBY_PAY.LEGAL_ENTITY_ID
, IBY_PAY.DECLARE_PAYMENT_FLAG
, IBY_PAY.DELIVERY_CHANNEL_CODE
, IBY_PAY.EXT_PAYEE_ID
, IBY_PAY.PAYMENT_INSTRUCTION_ID
, IBY_PAY.PAYMENT_PROFILE_ID
, IBY_PAY.PREGROUPED_PAYMENT_FLAG
, IBY_PAY.REMITTANCE_MESSAGE1
, IBY_PAY.REMITTANCE_MESSAGE2
, IBY_PAY.PAYMENT_DETAILS
, IBY_PAY.BANK_CHARGE_BEARER
, IBY_PAY.SEPARATE_REMIT_ADVICE_REQ_FLAG
, IBY_PAY.INTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.BILL_PAYABLE_FLAG
, IBY_PAY.EXCLUSIVE_PAYMENT_FLAG
, IBY_PAY.REMITTANCE_MESSAGE3
, IBY_PAY.PAYMENT_REFERENCE_NUMBER
, IBY_PAY.PAPER_DOCUMENT_NUMBER
, IBY_PAY.BANK_ASSIGNED_REF_CODE
, IBY_PAY.EXTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.UNIQUE_REMITTANCE_IDENTIFIER
, IBY_PAY.URI_CHECK_DIGIT
, IBY_PAY.BANK_INSTRUCTION1_CODE
, IBY_PAY.BANK_INSTRUCTION2_CODE
, IBY_PAY.BANK_INSTRUCTION_DETAILS
, IBY_PAY.PAYMENT_TEXT_MESSAGE1
, IBY_PAY.PAYMENT_TEXT_MESSAGE2
, IBY_PAY.PAYMENT_TEXT_MESSAGE3
, IBY_PAY.MATURITY_DATE
, IBY_PAY.PAYMENT_DUE_DATE
, IBY_PAY.DOCUMENT_CATEGORY_CODE
, IBY_PAY.DOCUMENT_SEQUENCE_ID
, IBY_PAY.EXT_BRANCH_NUMBER
, IBY_PAY.DOCUMENT_SEQUENCE_VALUE
, IBY_PAY.EXT_BANK_NUMBER
, IBY_PAY.BENEFICIARY_PARTY
, IBY_PAY.EXT_BANK_ACCOUNT_NAME
, IBY_PAY.EXT_BANK_ACCOUNT_NUMBER
, IBY_PAY.EXT_BANK_ACCOUNT_TYPE
, IBY_PAY.EXT_BANK_ACCOUNT_IBAN_NUMBER
, IBY_PAY.PAYEE_NAME
, IBY_PAY.PAYEE_ADDRESS1
, IBY_PAY.PAYEE_ADDRESS2
, IBY_PAY.PAYEE_ADDRESS3
, IBY_PAY.PAYEE_ADDRESS4
, IBY_PAY.PAYEE_CITY
, IBY_PAY.PAYEE_POSTAL_CODE
, IBY_PAY.PAYEE_STATE
, IBY_PAY.PAYEE_PROVINCE
, IBY_PAY.PAYEE_COUNTY
, IBY_PAY.PAYEE_COUNTRY
, I.PAYMENT_DOCUMENT_ID
, IBY_PAY.ADDRESS_SOURCE
, IBY_PAY.EMPLOYEE_ADDRESS_CODE
, IBY_PAY.EMPLOYEE_PERSON_ID
, IBY_PAY.EMPLOYEE_PAYMENT_FLAG
, IBY_PAY.EMPLOYEE_ADDRESS_ID
, IBY_PAY.REQUEST_ID
, IBY_PAY.LOGICAL_GROUP_REFERENCE
, IBY_PAY.EXT_INV_PAYEE_ID
, IBY_PAY.INV_PAYEE_PARTY_ID
, IBY_PAY.INV_PARTY_SITE_ID
, IBY_PAY.INV_SUPPLIER_SITE_ID
, IBY_PAY.INV_BENEFICIARY_PARTY
, IBY_PAY.INV_PAYEE_NAME
, IBY_PAY.INV_PAYEE_ADDRESS1
, IBY_PAY.INV_PAYEE_ADDRESS2
, IBY_PAY.INV_PAYEE_ADDRESS3
, IBY_PAY.INV_PAYEE_ADDRESS4
, IBY_PAY.INV_PAYEE_CITY
, IBY_PAY.INV_PAYEE_POSTAL_CODE
, IBY_PAY.INV_PAYEE_STATE
, IBY_PAY.INV_PAYEE_PROVINCE
, IBY_PAY.INV_PAYEE_COUNTY
, IBY_PAY.INV_PAYEE_COUNTRY
, CASE WHEN (IBY_PAY.PAYEE_PARTY_ID <> IBY_PAY.INV_PAYEE_PARTY_ID)
AND (IBY_PAY.SUPPLIER_SITE_ID <> IBY_PAY.INV_SUPPLIER_SITE_ID) THEN IBY_FD_EXTRACT_GEN_PVT.GET_RELSHIP_ID(IBY_PAY.PAYEE_PARTY_ID
, IBY_PAY.SUPPLIER_SITE_ID
, IBY_PAY.INV_PAYEE_PARTY_ID
, IBY_PAY.INV_SUPPLIER_SITE_ID) ELSE NULL END RELATIONSHIP_ID
FROM IBY_PAYMENTS_ALL IBY_PAY
, IBY_PAY_INSTRUCTIONS_ALL I
WHERE IBY_PAY.PAYMENT_INSTRUCTION_ID = I.PAYMENT_INSTRUCTION_ID(+)