IBY_EXT_FD_DOC_SUP_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

PAYMENT_ID PARTY_ID VENDOR_ID VENDOR_SITE_ID SUPPLIER_NUMBER PARTY_NUMBER PARTY_NAME ALTERNATE_NAME SITE_NAME ALTERNATE_SITE_NAME PARTY_TYPE PARTY_TYPE_MEANING TAX_REGISTRATION_NUMBER LE_REGISTRATION_NUMBER CUSTOMER_NUM PARTY_SITE_ID REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_EMAIL REMIT_ADVICE_FAX EMPLOYEE_PAYMENT_FLAG PAYMENT_LOCATION_ID PAYEE_ADDRESS1 PAYEE_ADDRESS2 PAYEE_ADDRESS3 PAYEE_ADDRESS4 PAYEE_CITY PAYEE_COUNTY PAYEE_STATE PAYEE_PROVINCE PAYEE_COUNTRY PAYEE_POSTAL_CODE PAYEE_ADDRESS_CONCAT DATE_OF_BIRTH COUNTRY_OF_BIRTH TOWN_OF_BIRTH THIRD_PARTY_DESCRIPTION

Query

SQL_Statement

SELECT pmt.payment_id payment_id, pmt.inv_payee_party_id party_id, pmt.inv_payee_supplier_id vendor_id, pmt.inv_supplier_site_id vendor_site_id, pmt.inv_payee_supplier_number supplier_number, pmt.inv_payee_party_number party_number, pmt.inv_payee_party_name party_name, pmt.inv_payee_alternate_name alternate_name, pmt.inv_payee_supplier_site_name site_name, NVL(pmt.inv_payee_spplr_site_alt_name, pmt.inv_payee_site_alt_name) alternate_site_name, NULL PARTY_TYPE, NULL PARTY_TYPE_MEANING, pmt.inv_payee_tax_reg_num tax_registration_number, pmt.inv_payee_le_reg_num le_registration_number, pmt.inv_payee_first_party_ref customer_num, pmt.inv_party_site_id party_site_id, ep.REMIT_ADVICE_DELIVERY_METHOD, ep.REMIT_ADVICE_EMAIL, ep.REMIT_ADVICE_FAX, pmt.employee_payment_flag employee_payment_flag, site.location_id payment_location_id, pmt.inv_payee_address1 payee_address1, pmt.inv_payee_address2 payee_address2, pmt.inv_payee_address3 payee_address3, pmt.inv_payee_address4 payee_address4, pmt.inv_payee_city payee_city, pmt.inv_payee_county payee_county, pmt.inv_payee_state payee_state, pmt.inv_payee_province payee_province, pmt.inv_payee_country payee_country, pmt.inv_payee_postal_code payee_postal_code, pmt.inv_payee_address_concat payee_address_concat, person.date_of_birth, person.country_of_birth, person.town_of_birth town_of_birth, null third_party_description FROM iby_payments_all pmt, IBY_EXTERNAL_PAYEES_ALL ep, hz_party_sites site, per_persons person WHERE pmt.INV_EXT_PAYEE_ID = ep.EXT_PAYEE_ID AND pmt.inv_party_site_id = site.party_site_id(+) AND pmt.employee_person_id = person.person_id(+)