AP Invalid PO Supplier Notice - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Invalid PO Supplier Notice (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDLET_XML
DB package: AP_APXVDLET_XMLP_PKG
SELECT distinct
       pv.vendor_id               C_VENDOR_ID,
       pv.vendor_name             C_VENDOR_NAME ,
      upper(pv.vendor_name)  C_UPP_VENDOR_NAME ,
       pvs.vendor_site_id         C_VENDOR_SITE_ID,
       pvs.address_line1          C_ADDR1,
       pvs.address_line2          C_ADDR2,
       pvs.address_line3          C_ADDR3,
       substr(decode(pvs.city||
               pvs.state||pvs.zip,null,null,
               decode (pvs.zip,null,
               decode (pvs.state,null,pvs.city,
               pvs.city||', '||pvs.state),
               pvs.city||', '                                   
               ||pvs.state||'   '                           
               ||pvs.zip)),1,35)  C_CSZ,                               
       substr(decode(pvs.country,'U.S.A.',null,
               decode(pvs.country,'USA',null,
               pvs.country)),1,35)   C_COUNTRY
FROM po_vendor_sites pvs,
     ap_invoices inv,
     po_vendors pv,
     ap_holds h
WHERE inv.vendor_site_id = pvs.vendor_site_id 
and   inv.payment_status_flag in ('N', 'P')
and   pv.vendor_id = pvs.vendor_id
and   h.invoice_id = inv.invoice_id
and   h.hold_lookup_code = 'INVALID PO'
and   h.release_lookup_code is null
&LP_LANGUAGE_WHERE
ORDER BY upper(pv.vendor_name), pv.vendor_id, 
         pvs.vendor_site_id
Parameter NameSQL textValidation
Ledger
 
Phone of sender
 
Title of sender
 
Name of sender
 
Location of organization
 
LOV Oracle
Name of organization
 
Attention to:
 
LOV Oracle