ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4B93869E053B46B63588994 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('No Tax Authority Info ', 'No Tax Authority Info ', 'No Tax Authority Info ', 'No Tax Authority Info ', 'No Tax Authority Info ', 'No Tax Authority Info ') 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_item.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 , ap_invoice_distributions d_item , ap_checks ac --bug 20014337 , ap_invoice_payments aip --bug 20014337 &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 aip.invoice_payment_id(+) = d.awt_invoice_payment_id --bug 20014337 and ac.check_id(+) = aip.check_id --bug 20014337 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 (+) --bug16758675 &P_Tax_Authority_Joins and d.line_type_lookup_code = 'AWT' and d_item.invoice_id = i.invoice_id and d_item.invoice_distribution_id = d.awt_related_id and d_item.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 Y SQLAP APXWTINV_XML AR AP تقرير الضرائب المستقطعة حسب الفاتورة (بتنسيق XML) Application: المدفوعات Source: تقرير الضرائب المستقطعة حسب الفاتورة (بتنسيق XML) Short Name: APXWTINV_XML DB package: AP_APXWTGNR_XMLP_PKG D AP Steuereinbehaltung nach Rechnung Application: Kreditoren Source: Steuereinbehaltung nach Rechnung (XML) Short Name: APXWTINV_XML DB package: AP_APXWTGNR_XMLP_PKG F AP Etat des retenues fiscales, par facture Application: Payables Source: Etat des retenues fiscales, par facture (XML) Short Name: APXWTINV_XML DB package: AP_APXWTGNR_XMLP_PKG US AP Withholding Tax by Invoice Application: Payables Source: Withholding Tax by Invoice Report (XML) Short Name: APXWTINV_XML DB package: AP_APXWTGNR_XMLP_PKG ZHS AP 按发票列出预扣税报表 Application: 应付帐款 Source: 按发票列出预扣税报表 (XML) Short Name: APXWTINV_XML DB package: AP_APXWTGNR_XMLP_PKG BI Publisher &p_cert_expiration_range &p_date_filter &p_gl_posted_status &p_order_by &p_restrict_certificates &p_restrict_to_checkrun_name &p_restrict_to_paid_dists &p_select_tax_authority &p_selected_suppliers &p_supplier_birthdate &p_supplier_dob &p_supplier_fcc &p_supplier_fcr &p_supplier_fifc &p_supplier_first_name &p_supplier_sex &p_supplier_surname &p_supplier_tob &p_ta_address_line1 &p_ta_address_line2 &p_ta_address_line3 &p_ta_city &p_ta_country &p_ta_province &p_ta_state &p_ta_zip &p_tax_authority_joins &p_tax_authority_name &p_tax_authority_site_code &p_tax_authority_tables :ap_withholding_template_report :c_base_currency_code :c_base_currency_name :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :operating_unit :p_awt_report :p_cert_expiration_range :p_cert_expire_from :p_cert_expire_to :p_checkrun_name :p_conc_request_id :p_date_criteria :p_date_filter :p_date_from :p_date_range_cert :p_date_to :p_debug_switch :p_fiscal_year :p_flexdata :p_gl_posted_status :p_invoice_classes :p_log_to_pipe :p_min_precision :p_order_by :p_pipe_size :p_posted_status :p_report_currency :p_report_currency_v :p_restrict_certificates :p_restrict_to_checkrun_name :p_restrict_to_paid_dists :p_select_tax_authority :p_selected_suppliers :p_set_of_books_id :p_supp_num_from :p_supp_num_from_v :p_supp_num_to :p_supp_num_to_v :p_supplier_birthdate :p_supplier_dob :p_supplier_fcc :p_supplier_fcr :p_supplier_fifc :p_supplier_first_name :p_supplier_from :p_supplier_from_v :p_supplier_id :p_supplier_sex :p_supplier_surname :p_supplier_to :p_supplier_to_v :p_supplier_tob :p_system_acct_method :p_ta_address_line1 :p_ta_address_line2 :p_ta_address_line3 :p_ta_city :p_ta_country :p_ta_province :p_ta_state :p_ta_zip :p_tax_auth_site_id :p_tax_authority_id :p_tax_authority_joins :p_tax_authority_name :p_tax_authority_site_code :p_tax_authority_tables :p_tax_name :p_tax_name_filter :p_trace_switch :s0_actual_tax_amount :s1_discount_amount :s1_payment_amount :sandro_1995 1 10 :p_tax_authority_id LOV Oracle AP_SRS_AWT_TAX_AUTH Y Y select vendor_id id, vendor_name value, null description from po_vendors where vendor_type_lookup_code='TAX AUTHORITY' order by value,description AR اسم مصلحة الضرائب D Steuerbehörde F Nom de l'administration fiscale US Tax Authority Name ZHS 税务机关名称 2 20 :p_tax_auth_site_id LOV Oracle AP_SRS_AWT_TAX_AUTH_SITE Y select vendor_site_id id, vendor_site_code value, null description from po_vendor_sites where vendor_id=:$flex$.ap_srs_awt_tax_auth order by value,description AR موقع مصلحة الضرائب D Adresse der Steuerbehörde F Site de l'administration fiscale US Tax Authority Site ZHS 税务机关地点 3 30 :p_tax_name LOV Oracle AP_SRS_AWT_TAX Y select name id, name value, null description from ap_tax_codes where nvl(inactive_date,sysdate+1)>sysdate and tax_type='AWT' and nvl(awt_vendor_id,-1) =nvl(:$flex$.ap_srs_awt_tax_auth:null, nvl(awt_vendor_id,-1)) and nvl(awt_vendor_site_id,-1) =nvl(:$flex$.ap_srs_awt_tax_auth_site:null, nvl(awt_vendor_site_id,-1)) order by value,description AR اسم الضريبة المستقطعة D Steuereinbehaltung F Code retenue fiscale US Withholding Tax Name ZHS 预扣税名称 4 40 :p_date_from Date Y AR من D Von F Du US From ZHS 自 5 50 :p_date_to Date Y AR إلى D Bis F Au US To ZHS 至 6 60 :p_supplier_id LOV Oracle AP_SRS_VENDOR_NAME_NUM Y Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد D Lieferantenname F Nom du fournisseur US Supplier Name ZHS 供应商名称 7 70 :p_supplier_from LOV Oracle AP_SRS_VENDOR_NAME_NUM Y Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR مدى اسم المورد من D Von Lieferant F Fourchette noms fournisseurs - De US Supplier Name Range From ZHS 供应商名称范围自 8 80 :p_supplier_to LOV Oracle AP_SRS_VENDOR_NAME_NUM Y Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR مدى اسم المورد إلى D Bis Lieferant F Fourchette noms fournisseurs - A US Supplier Name Range To ZHS 供应商名称范围至 9 90 :p_supp_num_from LOV Oracle AP_SRS_VENDOR_NUM_NAME Y Y select vendor_id id, segment1 value, null description from po_vendors order by value,description AR مدى رقم المورد من D Von Lieferantennummer F Fourchette numéros fournisseurs - De US Supplier Number Range From ZHS 供应商编号范围自 10 100 :p_supp_num_to LOV Oracle AP_SRS_VENDOR_NUM_NAME Y Y select vendor_id id, segment1 value, null description from po_vendors order by value,description AR مدى رقم المورد إلى D Bis Lieferantennummer F Fourchette numéros fournisseurs - A US Supplier Number Range To ZHS 供应商编号范围至 11 110 :p_report_currency LOV Oracle AP_SRS_REPORT_CURRENCY Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='SRS REPORT CURRENCY' and sysdate<nvl(inactive_date,sysdate+1) order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'SRS REPORT CURRENCY' and lookup_code = 'ORIGINAL' AR العملة D Währung F Devise US Currency ZHS 币种 12 120 :p_date_criteria LOV Oracle AP_SRS_AWT_TAX_DATE_CRITERIA Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='WITHHOLDING TAX DATE CRITERIA' and sysdate<nvl(inactive_date,sysdate+1) order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'WITHHOLDING TAX DATE CRITERIA' and lookup_code = 'ACCOUNTING DATE' Y AR أساس تاريخ الاستقطاع D Basis Einbehaltungsdatum F Base de date de la retenue US Withholding Date Basis ZHS 预扣日期基准 :$flex$.ap_srs_awt_tax_auth Tax Authority Name Tax Authority Site