ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BB897876B80AEDE06362FB0905B41B select distinct haouv.name, decode(haouv.location_id,null,haouv.internal_address_line,loc.address_line_1 ||','|| loc.address_line_2 ||','|| loc.address_line_3 ||','||loc.town_or_city||','||loc.postal_code||','|| loc.country ) address, jap.org_tan_num tan_no, jrg.attribute_value pan_no, aps0.vendor_name, aps0.vendor_id tds_id, afrm.tds_tax_section tds_section, aps.vendor_name vendor_name2, assa.address_line1 ||','|| assa.address_line2 ||','|| assa.address_line3 ||','|| assa.city||','||assa.zip||','||assa.state||','||assa.country site_address, aps.vat_registration_num, afrm.from_date, afrm.to_date, afrm.certificate_num certificate_id, upper(afrm.print_flag) print_flag1, afrm.org_id org_id, aps.vendor_id ven_id, ja_jainitcr_xmlp_pkg.cf_ven_pan_noformula(aps.vendor_id) vendor_pan_no, ja_jainitcr_xmlp_pkg.cf_3formula(frmd.tds_invoice_amt) total_tax, api2.invoice_date, frmd.tds_invoice_amt, frmd.tds_tax_rate, apip.accounting_date, frmd.invoice_payment_id, api1.invoice_id, apc.bank_account_name , jatp.check_number chq , jatp.check_deposit_date "Check_Deposit_Date", jatp.bank_name "Check_Deposit_Bank", jatp.challan_no "Check_Challan_No", apc.bank_account_id, frmd.invoice_amount invoice_amt, frmd.tds_invoice_id, ja_jainitcr_xmlp_pkg.bank_branchformula(jatp.challan_no, frmd.tds_invoice_id, aps0.vendor_id) bank_branch_name, ja_jainitcr_xmlp_pkg.cf_check_dep_dateformula(jatp.check_number) cf_check_dep_date, ja_jainitcr_xmlp_pkg.cf_tds_amtformula(frmd.tds_invoice_id, frmd.tds_invoice_amt) cf_tds_amt, ja_jainitcr_xmlp_pkg.cf_bsr_codeformula(apc.bank_account_id) bank_branch_code, ja_jainitcr_xmlp_pkg.cp_cess_amt_p cp_cess_amt, ja_jainitcr_xmlp_pkg.cp_surcharge_amt_p cp_surcharge_amt, ja_jainitcr_xmlp_pkg.cp_sh_cess_amt_p cp_sh_cess_amt from hr_all_organization_units_vl haouv, hr_locations loc, ap_suppliers aps, ap_supplier_sites_all assa, jai_ap_tds_f16_hdrs_all afrm, ap_suppliers aps0, jai_ap_tds_org_tan_v jap, jai_rgm_org_regns_v jrg, jai_ap_tds_cert_nums jatcn, ( select invoice_id, certificate_num, fin_yr, tax_authority_id, line_num, org_id, max(org_tan_num) org_tan_num, max(tds_invoice_id) tds_invoice_id, max(tds_inv_date) tds_inv_date, max(tds_tax_rate) tds_tax_rate, max(invoice_payment_id) invoice_payment_id, sum(taxable_basis) invoice_amount, sum(tds_invoice_amt) tds_invoice_amt from jai_ap_tds_f16_dtls_v frmd group by tax_authority_id, fin_yr, certificate_num, line_num, invoice_id,org_id ) frmd, ap_invoices_all api1, ap_invoices_all api2, ap_invoice_payments_all apip, ap_checks_all apc, jai_ap_tds_payments jatp where 2=2 and haouv.organization_id(+)=afrm.org_id and haouv.location_id=loc.location_id(+) and jap.organization_id=afrm.org_id and jrg.organization_id=afrm.org_id and jatcn.organization_id=afrm.org_id and jrg.regime_code='TDS' and jrg.registration_type='OTHERS' and jrg.attribute_type_code='OTHERS' and jrg.attribute_code='PAN NO' and aps.vendor_id=afrm.vendor_id and aps0.vendor_id=afrm.tax_authority_id and assa.vendor_site_id=afrm.vendor_site_id AND api1.invoice_id=frmd.invoice_id and apip.invoice_payment_id = frmd.invoice_payment_id and api2.invoice_id=frmd.tds_invoice_id and apc.check_id(+)=apip.check_id and apc.check_id =jatp.check_id and frmd.tds_inv_date=api2.invoice_date and frmd.fin_yr=afrm.fin_yr and frmd.org_tan_num=afrm.org_tan_num and frmd.tds_invoice_amt>0 and frmd.certificate_num=afrm.certificate_num order by afrm.certificate_num, api2.invoice_date, api1.invoice_id, frmd.invoice_amount, apc.bank_account_name , frmd.tds_invoice_amt, apc.bank_account_id, frmd.tds_invoice_id, jatp.check_number Replaced tab characters with spaces JA JAINITCR_XML US JA India - TDS Certificates Imported from BI Publisher Description: Form 16A report Application: Asia/Pacific Localizations Source: India - TDS Certificates (XML) Short Name: JAINITCR_XML DB package: JA_JAINITCR_XMLP_PKG ZHS JA 印度 - TDS 证明 (1) Imported from BI Publisher Description: 生成 16A 报表 Application: 亚太地区本地化 Source: 印度 - TDS 证明 (XML) Short Name: JAINITCR_XML DB package: JA_JAINITCR_XMLP_PKG Enginatics 2=2 :cp_1 :cp_cess_amt :cp_sh_cess_amt :cp_surcharge_amt :p_ack_num_for_quart_four :p_ack_num_for_quart_one :p_ack_num_for_quart_three :p_ack_num_for_quart_two :p_certificate_end_no :p_certificate_start_no :p_conc_request_id :p_designation :p_fin_year :p_from_date :p_name :p_org_tan_num :p_organization_id :p_place :p_selected_cert_date :p_selected_cert_id :p_selected_vendor :p_to_date :p_vendor_id 1 10 2=2 afrm.org_tan_num=:p_org_tan_num LOV Oracle JA_IN_TDS_TAN_NUMBER Y select org_tan_num id, org_tan_num value, null description from jai_ap_tds_cert_nums where rowid in (select max(rowid) from jai_ap_tds_cert_nums group by org_tan_num) order by value,description Y US TAN Number TAN Number ZHS TAN 编号 TAN 编号 2 20 2=2 frmd.org_id=:p_organization_id LOV Oracle ORGANIZATION_ITAR11i Y select organization_id id, name value, null description from hr_organization_units hou where hou.organization_id in (select organization_id from hr_organization_information where org_information_context like 'Operating%' or org_information_context like 'Legal%') order by hou.name Y US Organization Organization ZHS 组织 组织 3 30 2=2 afrm.fin_yr=:p_fin_year LOV Oracle VS_CERT_FIN_YEAR Y select jty.fin_year || hou.organization_id id, jty.fin_year value, null description from jai_ap_tds_years jty,hr_organization_units hou where jty.legal_entity_id=hou.organization_id and jty.tan_no=:$flex$.ja_in_tds_tan_number order by jty.fin_year Y US Financial Year Financial Year for TDS Certificates ZHS 财政年度 TDS 证明的财政年度 4 40 2=2 afrm.vendor_id=:p_vendor_id LOV custom Y select aps.vendor_id id, aps.vendor_name value, aps.segment1 description from ap_suppliers aps US Vendor 5 50 2=2 afrm.certificate_num>=:p_certificate_start_no LOV Oracle ITCR_CERTIFICATE_START_NO Y select jtf.certificate_num id, jtf.certificate_num value, null description from jai_ap_tds_f16_hdrs_all jtf,hr_organization_units hou where jtf.org_tan_num=:$flex$.ja_in_tds_tan_number and jtf.fin_yr=substr(:$flex$.vs_cert_fin_year,1,4) and jtf.org_id=hou.organization_id order by jtf.certificate_num US Certificate Nos. From CERTIFICATE_START_NO ZHS 证明编号自 CERTIFICATE_START_NO 6 60 2=2 afrm.certificate_num<=:p_certificate_end_no LOV Oracle ITCR_CERTIFICATE_END_NO Y select jtf.certificate_num id, jtf.certificate_num value, null description from jai_ap_tds_f16_hdrs_all jtf,hr_organization_units hou where jtf.org_tan_num=:$flex$.ja_in_tds_tan_number and jtf.fin_yr=substr(:$flex$.vs_cert_fin_year,1,4) and jtf.org_id=hou.organization_id order by jtf.certificate_num US Certificate Nos. To CERTIFICATE_END_NO ZHS 证明编号至 CERTIFICATE_END_NO 7 70 2=2 afrm.certificate_date between :p_from_date and nvl(:p_to_date,sysdate) Date US Certificate Date From 8 80 2=2 afrm.certificate_date between :p_from_date and nvl(:p_to_date,sysdate) Date US Certificate Date To :$flex$.ja_in_tds_tan_number TAN Number Certificate Nos. From :$flex$.ja_in_tds_tan_number TAN Number Certificate Nos. To :$flex$.ja_in_tds_tan_number TAN Number Financial Year :$flex$.vs_cert_fin_year Financial Year Certificate Nos. From :$flex$.vs_cert_fin_year Financial Year Certificate Nos. To