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

➜ Back to Library
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
Download
Related Blitz Reports
AP Invoices and Lines AP 1099 Payments Report- Not Supported: Reserved For Future Use GL Account Analysis CAC Invoice Price Variance AP 1099 Invoice Exceptions Report- Not Supported: Reserved For Future Use (1) AP 1099 Invoice Exceptions Report- Not Supported: Reserved For Future Use JE Finnish Payables Account by Detail- Not Supported: Reserved For Future Use CST Miscellaneous Accrual Reconciliation CST AP and PO Accrual Reconciliation
Blitz Report™

Blitz Report™ provides multiple benefits: