AP Invalid PO Supplier Notice- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Payables
- Source
- Invalid PO Supplier Notice (XML) - Not Supported: Reserved For Future Use
- Short Name
- APXVDLET_XML
- DB package
- AP_APXVDLET_XMLP_PKG
Imported from BI Publisher
Invalid PO Supplier Notice
Invalid PO Supplier Notice
SQL 33 lines
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 |
Parameters 7
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |