PO New Vendor Letter

➜ Back to Library
Description
Categories: BI Publisher
Application: Purchasing
Source: New Vendor Letter Report (XML)
Short Name: POXVDRVL_XML
DB package: PO_POXVDRVL_XMLP_PKG
Run PO New Vendor Letter and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   pov.vendor_name        Vendor
,        pvs.vendor_site_code   Vendor_site
,        pvs.address_line1      Address
,        pvs.address_line2
,        pvs.address_line3
,        pvs.city
,        pvs.state
,        pvs.country
,        pvs.zip
FROM     po_vendor_sites        pvs
,        po_vendors             pov
WHERE    pov.vendor_id          = pvs.vendor_id
AND      pov.vendor_name        >= nvl(:P_vendor_from,pov.vendor_name)
AND      pov.vendor_name        <= nvl(:P_vendor_to,pov.vendor_name)
AND      pov.creation_date      BETWEEN nvl(:P_create_date_from, 
                                        pov.creation_date - 1) 
                                AND     nvl(:P_create_date_to,
                                        pov.creation_date + 1)
AND      nvl(pvs.purchasing_site_flag,'N')      = 
             decode(:P_site, 'PURCHASING', 'Y', 
                                'BOTH', 'Y',
                                 nvl(pvs.purchasing_site_flag, 'N'))
AND      nvl(pvs.pay_site_flag, 'N')            = 
             decode(:P_site, 'PAY','Y',
                                 'BOTH', 'Y',
                                 nvl(pvs.pay_site_flag, 'N'))
AND      nvl(pov.vendor_type_lookup_code, '-1') = 
         nvl(:P_vendor_type,nvl(pov.vendor_type_lookup_code,'-1'))
AND      (  (:P_active_inactive = 'ACTIVE' 
              AND      sysdate BETWEEN nvl(pov.start_date_active, sysdate-1) 
                               AND      nvl(pov.end_date_active, sysdate+1))
          OR       
            (:P_active_inactive = 'INACTIVE'
              AND     ( sysdate  <= nvl(pov.start_date_active, sysdate-1)
                     OR sysdate  >= nvl(pov.end_date_active, sysdate+1)))
          OR       
         nvl(:P_active_inactive,'BOTH') = 'BOTH')
ORDER BY &orderby_clause
Parameter Name SQL text Validation
Title 
 
 Char
Vendor Type 
 
 LOV Oracle
Vendors From 
 
 LOV Oracle
To 
 
 Date
To 
 
 LOV Oracle
Vendor Site 
 
 LOV Oracle
Creation Dates From 
 
 Date
Active/Inactive 
 
 LOV Oracle
Sort By 
 
 LOV Oracle
Download
 
Related Blitz Reports
PO Vendor Purchase Summary ECC Project Manufacturing, Exceptions and Overdues, SQL5 AP Invoice History Report- Not Supported: Reserved For Future Use CAC Shipping Networks Missing Interco OU Relationships AP Payment Schedule Report- Not Supported: Reserved For Future Use AP 1099 Supplier Exceptions Report- Not Supported: Reserved For Future Use CAC Intercompany Relationship Setup JA India - Creditors Ledger- Not Supported: Reserved For Future Use JA India - Outside Processing Challan - draft
Blitz Report™

Blitz Report™ provides multiple benefits: