AP Withholding Tax by Tax Authority - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: Withholding Tax by Tax Authority Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXWTTXA_XML
DB package: AP_APXWTGNR_XMLP_PKG
Run AP Withholding Tax by Tax Authority - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
select
       &P_Tax_Authority_Name              Tax_Authority_Name
,      &P_Tax_Authority_Site_Code         Tax_Authority_Site_Code
,      &P_TA_Address_Line1                TA_Address_Line1
,      &P_TA_Address_Line2                TA_Address_Line2
,      &P_TA_Address_Line3                TA_Address_Line3
,      &P_TA_City                         TA_City
,      &P_TA_State                        TA_State
,      &P_TA_Zip                          TA_Zip
,      &P_TA_Province                     TA_Province
,      &P_TA_Country                      TA_Country
,      decode(:P_AWT_Report
             ,'AWT4'
             ,t.tax_name
             ,null
             )                            Withholding_Tax_Name
,      decode(:P_AWT_Report
             ,'AWT4'
             ,n.description
             ,null
             )                            Withholding_Tax_Description
,      decode(:P_AWT_Report
             ,'AWT4'
             ,t.tax_rate
             ,null
             )                            Withholding_Tax_Rate
,      supplier.vendor_id                 Supplier_Id
,      supplier.vendor_name               Supplier_Name
,      supplier.segment1                  Supplier_Number
,      supplier.vat_registration_num      Supplier_Tax_File_Number
,      supplier.vat_registration_num      Supplier_Fiscal_Code
,      supplier.num_1099                  Supplier_NIF
,      &P_Supplier_Surname                Supplier_Surname
,      &P_Supplier_First_Name             Supplier_First_Name
,      &P_Supplier_Birthdate              Supplier_Birthdate
,      &P_Supplier_TOB                    Supplier_TOB
,      &P_Supplier_DOB                    Supplier_DOB
,      &P_Supplier_Sex                    Supplier_Sex
,      &P_Supplier_FCC                    Supplier_FCC
,      &P_Supplier_FCR                    Supplier_FCR
,      &P_Supplier_FIFC                   Supplier_FIFC
,      supplier_site.vendor_site_id       Site_Id
,      supplier_site.vendor_site_code     Site_Code
,      supplier_site.vat_registration_num Site_Fiscal_Code
,      supplier_site.address_line1        Site_Address_Line1
,      supplier_site.address_line2        Site_Address_Line2
,      supplier_site.address_line3        Site_Address_Line3
,      supplier_site.city                 Site_City
,      supplier_site.state                Site_State
,      supplier_site.zip                  Site_Zip
,      supplier_site.province             Site_Province
,      supplier_site.country              Site_Country
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.certificate_type
             ,null
             )                            Certificate_Type
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.certificate_number
             ,null
             )                            Certificate_Number
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.tax_rate
             ,null
             )                            Certificate_Tax_Rate
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.rate_type
             ,null
             )                            Certificate_Rate_Type_Test
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.start_date
             ,null
             )                            Certificate_Start_Date
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.end_date
             ,null
             )                            Certificate_End_Date
,      decode(:P_AWT_Report
             ,'AWT6'
             ,t.priority
             ,null
             )                            Certificate_Priority
,      decode(:P_REPORT_CURRENCY_V
             ,'ORIGINAL'
             ,i.invoice_currency_code
             ,:C_BASE_CURRENCY_CODE
             )                            Actual_Currency_Code
,      decode(:P_AWT_Report
             ,'AWT5'
             ,t.tax_name
             ,null
             )                            Inv_Tax_Name
,      decode(:P_AWT_Report
             ,'AWT5'
             ,n.description
             ,null
             )                            Inv_Tax_Description
,      i.invoice_date                     Invoice_Date
,      i.invoice_id                       Invoice_Id
,      i.invoice_type_lookup_code         Invoice_Type
,      i.invoice_currency_code            Invoice_Currency_Code
,      i.exchange_rate                    Invoice_Exchange_Rate
,      c.name                             Invoice_Currency_Name
,      i.invoice_num                      Invoice_Number
,      i.invoice_amount                   Invoice_Amount
,      i.base_amount                      Invoice_Base_Amount
,      i.description                      Invoice_Description
,      s.name                             Invoice_Doc_Sequence_Name
,      i.doc_sequence_value               Invoice_Doc_Sequence_Value
,      d.awt_invoice_payment_id           Break_AWT_Payment_Id
,      d.accrual_posted_flag              Accrual_Posted_Flag
,      d.cash_posted_flag                 Cash_Posted_Flag
,      d.accounting_date                  Accounting_Date
,     nvl(d.awt_gross_amount, i.invoice_amount)   Amount_Subject_To_Tax
,      d.amount                           Tax_Amount
,      d.base_amount                      Tax_Base_Amount
,      d.description                      Line_Description
,      d.awt_flag                         AWT_Flag
,      d.awt_invoice_payment_id           AWT_Invoice_Payment_Id
,      n.name                               Dist_Tax_Name
,      t.tax_rate                         Dist_Tax_Rate
,      t.rate_type                        Dist_Rate_Type
,      t.certificate_number               Dist_Certificate_Number
,      t.certificate_type                 Dist_Certificate_Type
,      t.start_date                       Dist_Cert_Start_Date
,      t.end_date                         Dist_Cert_End_Date
,      t.priority                         Dist_Cert_Priority,
	AP_APXWTGNR_XMLP_PKG.ctaaddress(&P_TA_City, &P_TA_State, &P_TA_Zip , &P_TA_Address_Line1 , &P_TA_Address_Line2 ,&P_TA_Address_Line3) C_TA_Address,
	AP_APXWTGNR_XMLP_PKG.coriginalinvtotal(:S1_Payment_Amount, :S1_Discount_Amount, :S0_Actual_Tax_Amount) C_Original_Inv_Total,
	AP_APXWTGNR_XMLP_PKG.csiteaddress(supplier_site.city, supplier_site.state, supplier_site.zip, supplier_site.address_line1, supplier_site.address_line2, supplier_site.address_line3) C_Site_Address,
	AP_APXWTGNR_XMLP_PKG.cinvoiceclass(d.awt_flag, i.invoice_date) C_Invoice_Class,
	AP_APXWTGNR_XMLP_PKG.cactualcurrencyname(c.name, :C_BASE_CURRENCY_NAME) C_Actual_Currency_Name,
	AP_APXWTGNR_XMLP_PKG.cinvoicefirstacctdate(i.invoice_id) C_Invoice_First_Acct_Date,
	AP_APXWTGNR_XMLP_PKG.cinvoiceactualamount(i.invoice_amount, i.invoice_currency_code, i.base_amount) C_Invoice_Actual_Amount,
	AP_APXWTGNR_XMLP_PKG.cinvoiceamountexempt(i.invoice_id, i.invoice_currency_code) C_Invoice_Amount_Exempt,
	AP_APXWTGNR_XMLP_PKG.cpaymentamount(i.invoice_id, d.awt_invoice_payment_id, decode ( :P_REPORT_CURRENCY_V , 'ORIGINAL' , i.invoice_currency_code , :C_BASE_CURRENCY_CODE ), i.invoice_currency_code) C_Payment_Amount,
	AP_APXWTGNR_XMLP_PKG.cdiscountamount(i.invoice_id, d.awt_invoice_payment_id, i.invoice_currency_code, i.exchange_rate) C_Discount_Amount,
	AP_APXWTGNR_XMLP_PKG.clastpaymentdoc(i.invoice_id, d.awt_invoice_payment_id) C_Last_Payment_Doc,
	AP_APXWTGNR_XMLP_PKG.clastpaymentdate(i.invoice_id, d.awt_invoice_payment_id) C_Last_Payment_Date,
	AP_APXWTGNR_XMLP_PKG.cgldistpostedstatus(d.accrual_posted_flag, d.cash_posted_flag) C_GL_Dist_Posted_Status,
	AP_APXWTGNR_XMLP_PKG.cactualamountsubject(nvl ( d.awt_gross_amount , i.invoice_amount ), decode ( :P_REPORT_CURRENCY_V , 'ORIGINAL' , i.invoice_currency_code , :C_BASE_CURRENCY_CODE ), i.invoice_currency_code, i.exchange_rate) C_Actual_Amount_Subject,
	AP_APXWTGNR_XMLP_PKG.cactualtaxamount(d.amount, decode ( :P_REPORT_CURRENCY_V , 'ORIGINAL' , i.invoice_currency_code , :C_BASE_CURRENCY_CODE ), i.invoice_currency_code, d.base_amount) C_Actual_Tax_Amount
from
       ap_invoice_distributions d
,      ap_invoices              i
,      fnd_currencies_vl           c
,      fnd_document_sequences   s
,      po_vendors               supplier
,      po_vendor_sites          supplier_site
,      ap_awt_tax_rates         t
,      ap_tax_codes             n
&P_Tax_Authority_Tables
where
       d.invoice_id            = i.invoice_id
and    i.vendor_id             = supplier_site.vendor_id
and    i.vendor_site_id        = supplier_site.vendor_site_id
and    i.vendor_id             = supplier.vendor_id
and    i.doc_sequence_id       = s.doc_sequence_id (+)
and    i.invoice_currency_code = c.currency_code
and    d.awt_tax_rate_id       = t.tax_rate_id (+)
and    d.withholding_tax_code_id          = n.tax_id
&P_Tax_Authority_Joins
and    d.line_type_lookup_code = 'AWT'
and    d.set_of_books_id       = :P_SET_OF_BOOKS_ID
&P_DATE_FILTER
&P_Select_Tax_Authority
&P_Restrict_To_Checkrun_Name
&P_Restrict_To_Paid_Dists
&P_Selected_Suppliers
&P_GL_Posted_Status
&P_Cert_Expiration_Range
&P_Restrict_Certificates
&P_Order_By
Parameter Name SQL text Validation
Tax Authority Name 
 
 LOV Oracle
Tax Authority Site 
 
 LOV Oracle
Withholding Tax Name 
 
 LOV Oracle
From 
 
 Date
To 
 
 Date
Supplier Name 
 
 LOV Oracle
Vendor Name Range From 
 
 LOV Oracle
Vendor Name Range To 
 
 LOV Oracle
Vendor Number Range From 
 
 LOV Oracle
Vendor Number Range To 
 
 LOV Oracle
Currency 
 
 LOV Oracle
Download
Related Blitz Reports
AP Withholding Tax by Payment Report- Not Supported: Reserved For Future Use AP Withholding Tax by Invoice AP Withholding Tax by Supplier - draft GL Account Analysis JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use JE Israeli Withholding Annual Certificate To Vendors GL Account Analysis (Distributions) 11g GL Account Analysis (Distributions) AP Invoices and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: