AP Invalid PO Supplier Notice- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Invalid PO Supplier Notice
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
Operating Unit
 
LOV
Attention to:
 
LOV Oracle
Name of organization
 
Char
Location of organization
 
LOV Oracle
Name of sender
 
Char
Title of sender
 
Char
Phone of sender
 
Char
Download
Related Blitz Reports
ZX Use Tax Liability Report- Not Supported: Reserved For Future Use MDS TEST AP Supplier Upload COPY OF: AP Supplier Upload AP Supplier Upload AP Invoice on Hold 11i AP Invoices and Lines 11i AP Prepayment Balance (3) AP Prepayment Balance AP Advances in Selected Currency
Blitz Report™