AP Tax Information Verification Letter- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Tax Identification Number Letter
Application: Payables
Source: Tax Information Verification Letter (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDTIN_XML
DB package: AP_APXVDTIN_XMLP_PKG
Run AP Tax Information Verification Letter- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT p.vendor_id,
       SUBSTR(p.vendor_name,1,30) vendor_name
FROM   po_vendors P,
       po_lookup_codes lc,
       ap_invoices I,
       gl_code_combinations CC,
       ap_invoice_distributions ID,
       ap_reporting_entity_lines REL,
       ap_reporting_entities RE
WHERE  P.organization_type_lookup_code =
                  lc.lookup_code (+)
  AND I.invoice_id=ID.invoice_id
  AND P.vendor_id=I.vendor_id
  AND ID.dist_code_combination_id =
                  CC.code_combination_id
  AND RE.tax_entity_id = :P_tax_entity_id
  AND RE.tax_entity_id = REL.tax_entity_id
  AND CC.chart_of_accounts_id =
                :C_CHART_ACCTS_ID
&C_DYNAMIC_SQL
AND DECODE(:P_null_TIN_only,'N','Include non-null TINs',
                          DECODE(decode(replace(replace(p.num_1099,'-',''),' ',''),'000000000','',p.num_1099),'','Include null')) IS NOT NULL
AND UPPER (nvl(vendor_type_lookup_code, 'x')) !=
                'EMPLOYEE'
AND UPPER (NVL(p.organization_type_lookup_code,
    'FAKE')) != DECODE (:P_exclude_corp, 'Y',
    'CORPORATION', 'Cant match me')
AND to_char(NVL(p.end_date_active, sysdate),
    'YYYY') >= DECODE (:P_exclude_inactive, 'Y',
    to_char(sysdate, 'YYYY'),'1950')
AND UPPER (NVL(p.type_1099, 'FAKE'))   !=  DECODE (:P_include_1099, 'Y', 'FAKE', 'Cant match me')
AND :P_cutoff_date >
      nvl(p.tax_verification_date,sysdate-9999)
GROUP BY p.vendor_id, p.vendor_name
ORDER BY upper(P.vendor_name)
Parameter Name SQL text Validation
Operating Unit
 
LOV
Tax Reporting Entity
 
LOV Oracle
Payer Name Source
 
LOV Oracle
Exclude Corporations
 
LOV Oracle
Exclude Inactive Suppliers
 
LOV Oracle
Exclude Suppliers with TINs
 
LOV Oracle
Suppliers Verified Prior To
 
Date
Include Only 1099 Suppliers
 
LOV Oracle
Name of Sender
 
Char
Title
 
Char
Return To/Attention
 
LOV Oracle
Return By
 
Date
Blitz Report™