AP Invalid PO Supplier Notice- Not Supported: Reserved For Future Use
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
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 |