Reports2017-11-18T12:27:27+00:00

AP Tax Information Verification Letter - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Tax Information Verification Letter (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDTIN_XML
DB package: AP_APXVDTIN_XMLP_PKG
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
Ledger
 
Return By
 
Date
Return To/Attention
 
LOV Oracle
Title
 
Name of Sender
 
Include Only 1099 Suppliers
 
LOV Oracle
Suppliers Verified Prior To
 
Date
Exclude Suppliers with TINs
 
LOV Oracle
Exclude Inactive Suppliers
 
LOV Oracle
Exclude Corporations
 
LOV Oracle
Payer Name Source
 
LOV Oracle
Tax Reporting Entity
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept