VIEW: APPS.IBY_EXT_FD_INVPAYEE_1_0_VD

Source

View Text - Preformatted

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 , NVL(pmt.INV_PAYEE_PARTY_NAME,pmt.PAYEE_PARTY_NAME) party_name, pmt.INV_PAYEE_ALTERNATE_NAME alternate_name , pmt.INV_PAYEE_SUPPLIER_SITE_NAME site_name , pmt.INV_PAYEE_SPPLR_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_PARTY_ATTR_CAT party_attr_cat, /*pmt.remit_to_location_id payment_location_id,*/ NULL payment_location_id, pmt.INV_PAYEE_FIRST_PARTY_REF customer_num, pmt.INV_PARTY_SITE_ID party_site_id, pmt.INV_PAYEE_SUPPLIER_ATTR_CAT payee_supplier_attr_category, pmt.INV_PAYEE_SPPLR_SITE_ATTR_CAT 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, iby_fd_extract_gen_pvt.get_rel_add_info(pmt.payee_party_id, pmt.supplier_site_id, pmt.inv_payee_party_id, pmt.inv_supplier_site_id) additional_information, pmt.payee_country payee_country, pmt.remit_to_location_id remit_to_location_id, pmt.party_site_id pmt_party_site_id, pmt.payee_party_id pmt_payee_party_id FROM iby_payments_all pmt, iby_external_payees_all ep WHERE pmt.ext_inv_payee_id = ep.ext_payee_id(+)

View Text - HTML Formatted

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
, NVL(PMT.INV_PAYEE_PARTY_NAME
, PMT.PAYEE_PARTY_NAME) PARTY_NAME
, PMT.INV_PAYEE_ALTERNATE_NAME ALTERNATE_NAME
, PMT.INV_PAYEE_SUPPLIER_SITE_NAME SITE_NAME
, PMT.INV_PAYEE_SPPLR_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_PARTY_ATTR_CAT PARTY_ATTR_CAT
, /*PMT.REMIT_TO_LOCATION_ID PAYMENT_LOCATION_ID
, */ NULL PAYMENT_LOCATION_ID
, PMT.INV_PAYEE_FIRST_PARTY_REF CUSTOMER_NUM
, PMT.INV_PARTY_SITE_ID PARTY_SITE_ID
, PMT.INV_PAYEE_SUPPLIER_ATTR_CAT PAYEE_SUPPLIER_ATTR_CATEGORY
, PMT.INV_PAYEE_SPPLR_SITE_ATTR_CAT 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
, IBY_FD_EXTRACT_GEN_PVT.GET_REL_ADD_INFO(PMT.PAYEE_PARTY_ID
, PMT.SUPPLIER_SITE_ID
, PMT.INV_PAYEE_PARTY_ID
, PMT.INV_SUPPLIER_SITE_ID) ADDITIONAL_INFORMATION
, PMT.PAYEE_COUNTRY PAYEE_COUNTRY
, PMT.REMIT_TO_LOCATION_ID REMIT_TO_LOCATION_ID
, PMT.PARTY_SITE_ID PMT_PARTY_SITE_ID
, PMT.PAYEE_PARTY_ID PMT_PAYEE_PARTY_ID
FROM IBY_PAYMENTS_ALL PMT
, IBY_EXTERNAL_PAYEES_ALL EP
WHERE PMT.EXT_INV_PAYEE_ID = EP.EXT_PAYEE_ID(+)