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, null, 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, pmt.payee_supplier_attr_category, pmt.payee_spplr_site_attr_category, ep.REMIT_ADVICE_DELIVERY_METHOD, ep.REMIT_ADVICE_EMAIL, ep.REMIT_ADVICE_FAX 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
, NULL
, 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
, PMT.PAYEE_SUPPLIER_ATTR_CATEGORY
, PMT.PAYEE_SPPLR_SITE_ATTR_CATEGORY
, EP.REMIT_ADVICE_DELIVERY_METHOD
, EP.REMIT_ADVICE_EMAIL
, EP.REMIT_ADVICE_FAX
FROM IBY_PAYMENTS_ALL PMT
, IBY_EXTERNAL_PAYEES_ALL EP
WHERE PMT.EXT_PAYEE_ID = EP.EXT_PAYEE_ID