ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BF84BD8D9D0AE9E06362FB09053934 SELECT 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 , frmd.certificate_num certificate_id2 ,jatp.check_number CHQ1 , 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(:C_CHQ, frmd.tds_invoice_id, :TDS_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) CF_BSR_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, 'X' dummy FROM ( 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 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 = :P_FIN_YEAR AND frmd.Org_tan_num = :P_ORG_TAN_NUM AND frmd.org_id = nvl(:p_organization_id, frmd.org_id ) AND frmd.tds_invoice_amt > 0 and frmd.certificate_num=:certificate_id ORDER BY 1 ASC,6 ASC,8 ASC,15 ASC,7 ASC,2 ASC,14 ASC,16 ASC,9 ASC , api1.invoice_id JA JAINITCR_XML Y US JA India - TDS Certificates (1) 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 证明 (2) Imported from BI Publisher Description: 生成 16A 报表 Application: 亚太地区本地化 Source: 印度 - TDS 证明 (XML) Short Name: JAINITCR_XML DB package: JA_JAINITCR_XMLP_PKG BI Publisher 1=1 :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 :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 :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 :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 :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 5 50 :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 :$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