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
Run AP Invalid PO Supplier Notice- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
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 AP Advances in Selected Currency CAC Invoice Price Variance AP Receiving Hold Requestor Notice- Not Supported: Reserved For Future Use AP Prepayment Balance Report - Functional Currency (CZech) AP Prepayment Balance Report - Entered Currency (CZech) AP Payables Open Interface Import- Not Supported: Reserved For Future Use PO Matching Holds Report by Buyer AP Prepayment Balance
Blitz Report™

Blitz Report™ provides multiple benefits: