ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 32D6F8E657878D05E06362FB09052536 Select jrtr1.organization_id org_id1, jrtr1.invoice_id invoice_id, jrtr1.reference_id service_ref_id, jrtr1.taxable_basis service_basis, jrtr1.trx_tax_amount service_trx_amount, jrtr1.tax_amount service_tax_amount, jrtr1.recoverable_ptg service_rec_percent, jrtr1.recoverable_amount service_rec_amount, jrtr1.recovered_amount service_payable_amount, jrtr2.reference_id cess_ref_id, jrtr2.taxable_basis cess_basis, jrtr2.trx_tax_amount cess_trx_amount, jrtr2.tax_amount cess_tax_amount, jrtr2.recoverable_ptg cess_rec_percent, jrtr2.recoverable_amount cess_rec_amount, jrtr2.recovered_amount cess_payable_amount, JA_JAINSTR_XMLP_PKG.cf_receipt_amountformula(jrtr1.invoice_id) CF_RECEIPT_AMOUNT, JA_JAINSTR_XMLP_PKG.cf_1formula(jrtr1.invoice_id, jrtr1.organization_id, jrtr1.taxable_basis, jrtr1.recoverable_amount, jrtr2.recoverable_amount, jrtr1.recovered_amount, jrtr2.recovered_amount) CF_INVOICE_NUMBER, JA_JAINSTR_XMLP_PKG.cf_service_typeformula(jrtr1.reference_id) CF_Service_Type, JA_JAINSTR_XMLP_PKG.CP_GROSS_INVOICE_AMOUNT_p CP_GROSS_INVOICE_AMOUNT, JA_JAINSTR_XMLP_PKG.CP_TAXABLE_BASIS_p CP_TAXABLE_BASIS, JA_JAINSTR_XMLP_PKG.CP_SERVICE_TAX_AMOUNT_p CP_SERVICE_TAX_AMOUNT, JA_JAINSTR_XMLP_PKG.CP_CESS_AMOUNT_p CP_CESS_AMOUNT, JA_JAINSTR_XMLP_PKG.CP_SERVICE_TAX_PAY_p CP_SERVICE_TAX_PAY, JA_JAINSTR_XMLP_PKG.CP_sh_cess_amount_p CP_sh_cess_amount, 'X' dummy from jai_rgm_trx_refs jrtr1, jai_rgm_trx_refs jrtr2 where jrtr1.source='AR' and trunc(jrtr1.creation_date) between trunc(:p_from_date) and trunc(:p_to_date) and jrtr1.invoice_id = jrtr2.invoice_id(+) and jrtr1.tax_type ='Service' and jrtr2.tax_type = 'SERVICE_EDUCATION_CESS' and jrtr1.reference_id in (select reference_id from jai_rgm_Trx_records where source ='AR' and source_table_name ='AR_RECEIVABLE_APPLICATIONS_ALL' and source_trx_type ='RECEIPT_APPLICATION' and regime_code ='SERVICE' and tax_type='Service' ) and jrtr1.organization_id=:Org_id order by jrtr1.creation_Date Y JA JAINSTR_XML US JA India - Service Tax Report Imported from BI Publisher Description: SERVICE TAX REPORT Application: Asia/Pacific Localizations Source: India - Service Tax Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINSTR_XML DB package: JA_JAINSTR_XMLP_PKG ZHS JA 印度 - 服务税报表- 不支持：已保留供将来使用 (1) Imported from BI Publisher Description: SERVICE TAX REPORT Application: 亚太地区本地化 Source: 印度 - 服务税报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINSTR_XML DB package: JA_JAINSTR_XMLP_PKG India Localization 1=1 :cp_cess_amount :cp_gross_invoice_amount :cp_service_tax_amount :cp_service_tax_pay :cp_sh_cess_amount :cp_taxable_basis :lp_from_date :lp_to_date :p_conc_request_id :p_debug_flag :p_from_date :p_location_id :p_org_id :p_primary_regno :p_to_date 1 -10 :debugflag Char N US DebugFlag DebugFlag ZHS 调试标志 调试标志 2 10 :p_from_date Date US Start Date START_DATE ZHS 起始日期 START_DATE 3 20 :p_to_date Date US End Date END_DATE ZHS 终止日期 END_DATE 4 30 :p_primary_regno LOV Oracle JAI_RGM_PRIM_REGNO Y select attribute_value id, attribute_value value, attribute_value description from jai_rgm_org_regns_v where registration_type='OTHERS' and attribute_type_code='PRIMARY' and (regime_org_id,attribute_value) in (select min(bb.regime_org_id),bb.attribute_value from jai_rgm_org_regns_v bb where registration_type='OTHERS' and attribute_type_code='PRIMARY' and regime_code='SERVICE' group by bb.attribute_value ) order by value,description Y US Registration Number Registration Number ZHS 登记编号 登记编号 5 40 :p_org_id LOV Oracle ORG_ID_VAL Y select organization_id id, organization_name value, null description from org_organization_definitions ood where exists (select 'X' from jai_rgm_organizations_v jrov where ood.organization_id=jrov.organization_id and jrov.regime_code='SERVICE' and jrov.attribute_value=:$flex$.jai_rgm_prim_regno ) order by value,description US Organization Name ORGANIZATION_ID ZHS 组织名 ORGANIZATION_ID 6 50 :p_location_id LOV Oracle LOC_ID_VAL Y select location_id id, location_code value, null description from hr_locations rhl where exists (select 'X' from jai_ar_trxs jrct where rhl.location_id=jrct.location_id and jrct.organization_id=:$flex$.org_id_val) order by value,description US Location Code LOCATION_ID ZHS 地点代码 LOCATION_ID