VIEW: APPS.IBY_EXT_FD_PAYEE_1_0_VD

Source

View Text - Preformatted

SELECT pmt.payment_id payment_id , pmt.payee_party_id party_id , pmt.payee_supplier_id vendor_id , pmt.supplier_site_id vendor_site_id , pmt.payee_supplier_number supplier_number , pmt.payee_party_number party_number , pmt.payee_name party_name , pmt.payee_alternate_name alternate_name , pmt.payee_supplier_site_name site_name , pmt.payee_site_alternate_name alternate_site_name , NULL PARTY_TYPE, NULL PARTY_TYPE_MEANING, pmt.payee_tax_registration_num tax_registration_number, pmt.payee_le_registration_num le_registration_number , pmt.payee_party_attr_category party_attr_cat , pmt.remit_to_location_id payment_location_id , pmt.payee_first_party_reference customer_num , pmt.party_site_id PARTY_SITE_ID, pmt.payee_supplier_attr_category PAYEE_SUPPLIER_ATTR_CATEGORY, pmt.payee_spplr_site_attr_category PAYEE_SPPLR_SITE_ATTR_CATEGORY, ep.REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_DELIVERY_METHOD, ep.REMIT_ADVICE_EMAIL REMIT_ADVICE_EMAIL, ep.REMIT_ADVICE_FAX REMIT_ADVICE_FAX, pmt.payee_addressee PAYEE_ADDRESSEE, pmt.employee_payment_flag employee_payment_flag, pmt.employee_address_id employee_address_id, pmt.payee_address1 payee_address1, pmt.payee_address2 payee_address2, pmt.payee_address3 payee_address3, pmt.payee_address4 payee_address4, pmt.payee_city payee_city, pmt.payee_county payee_county, pmt.payee_state payee_state, pmt.payee_province payee_province, pmt.payee_country payee_country, pmt.payee_postal_code payee_postal_code, pmt.payee_address_concat payee_address_concat, pmt.payee_party_site_name address_name FROM iby_payments_all pmt, IBY_EXTERNAL_PAYEES_ALL ep WHERE pmt.EXT_PAYEE_ID = ep.EXT_PAYEE_ID

View Text - HTML Formatted

SELECT PMT.PAYMENT_ID PAYMENT_ID
, PMT.PAYEE_PARTY_ID PARTY_ID
, PMT.PAYEE_SUPPLIER_ID VENDOR_ID
, PMT.SUPPLIER_SITE_ID VENDOR_SITE_ID
, PMT.PAYEE_SUPPLIER_NUMBER SUPPLIER_NUMBER
, PMT.PAYEE_PARTY_NUMBER PARTY_NUMBER
, PMT.PAYEE_NAME PARTY_NAME
, PMT.PAYEE_ALTERNATE_NAME ALTERNATE_NAME
, PMT.PAYEE_SUPPLIER_SITE_NAME SITE_NAME
, PMT.PAYEE_SITE_ALTERNATE_NAME ALTERNATE_SITE_NAME
, NULL PARTY_TYPE
, NULL PARTY_TYPE_MEANING
, PMT.PAYEE_TAX_REGISTRATION_NUM TAX_REGISTRATION_NUMBER
, PMT.PAYEE_LE_REGISTRATION_NUM LE_REGISTRATION_NUMBER
, PMT.PAYEE_PARTY_ATTR_CATEGORY PARTY_ATTR_CAT
, PMT.REMIT_TO_LOCATION_ID PAYMENT_LOCATION_ID
, PMT.PAYEE_FIRST_PARTY_REFERENCE CUSTOMER_NUM
, PMT.PARTY_SITE_ID PARTY_SITE_ID
, PMT.PAYEE_SUPPLIER_ATTR_CATEGORY PAYEE_SUPPLIER_ATTR_CATEGORY
, PMT.PAYEE_SPPLR_SITE_ATTR_CATEGORY PAYEE_SPPLR_SITE_ATTR_CATEGORY
, EP.REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_DELIVERY_METHOD
, EP.REMIT_ADVICE_EMAIL REMIT_ADVICE_EMAIL
, EP.REMIT_ADVICE_FAX REMIT_ADVICE_FAX
, PMT.PAYEE_ADDRESSEE PAYEE_ADDRESSEE
, PMT.EMPLOYEE_PAYMENT_FLAG EMPLOYEE_PAYMENT_FLAG
, PMT.EMPLOYEE_ADDRESS_ID EMPLOYEE_ADDRESS_ID
, PMT.PAYEE_ADDRESS1 PAYEE_ADDRESS1
, PMT.PAYEE_ADDRESS2 PAYEE_ADDRESS2
, PMT.PAYEE_ADDRESS3 PAYEE_ADDRESS3
, PMT.PAYEE_ADDRESS4 PAYEE_ADDRESS4
, PMT.PAYEE_CITY PAYEE_CITY
, PMT.PAYEE_COUNTY PAYEE_COUNTY
, PMT.PAYEE_STATE PAYEE_STATE
, PMT.PAYEE_PROVINCE PAYEE_PROVINCE
, PMT.PAYEE_COUNTRY PAYEE_COUNTRY
, PMT.PAYEE_POSTAL_CODE PAYEE_POSTAL_CODE
, PMT.PAYEE_ADDRESS_CONCAT PAYEE_ADDRESS_CONCAT
, PMT.PAYEE_PARTY_SITE_NAME ADDRESS_NAME
FROM IBY_PAYMENTS_ALL PMT
, IBY_EXTERNAL_PAYEES_ALL EP
WHERE PMT.EXT_PAYEE_ID = EP.EXT_PAYEE_ID