ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0C53869E053B46B63588994Y select c.rep_context_entity_name operating_unit1, d.first_party_primary_reg_num tax_registration_num1, c.rep_organization_id organization_id1, c.rep_organization_name organization_name1, c.rep_location_id location_id1, c.rep_location_name location_name1, d.tax_regime_id tax_regime_id1, d.tax_regime_name tax_regime_name1, d.tax_type_id tax_type_id1, d.tax_type_name tax_type_name1, d.tax_opening_balance opening_balance_amt, sum(nvl(d.liability_amount,0)) liability_amt, sum(nvl(d.credit_utilized_amount,0)) recovery_offset_amt1, sum(nvl(d.amount_applied,0)) cash_payment_amt1, (nvl(d.tax_opening_balance,0) + sum(nvl(d.liability_amount,0)) - sum(nvl(d.credit_utilized_amount,0)) - sum(nvl(d.amount_applied,0))) closing_balance_amt, (select count(1) from jai_rep_context_t c1, jai_rep_trx_detail_t d1 where c1.rep_context_id = d1.rep_context_id and c1.extract_summary_code = 'L' and d1.first_party_primary_reg_num = :tax_registration_num4 and c1.rep_organization_id = :organization_id4 and c1.rep_location_id = :location_id4 and d1.tax_regime_id = :tax_regime_id4 and (d1.trx_id, d1.trx_line_id) in ( select d2.trx_id , d2.trx_line_id from jai_rep_context_t c2, jai_rep_trx_detail_t d2 where c2.rep_context_id = d2.rep_context_id and c2.extract_summary_code = 'S' and d2.first_party_primary_reg_num = :tax_registration_num4 and c2.rep_organization_id = :organization_id4 and c2.rep_location_id = :location_id4 and d2.tax_regime_id = :tax_regime_id4 and d2.tax_type_id = d.tax_type_id and c2.request_id = :p_conc_request_id ) and c1.request_id = :p_conc_request_id) offset_sum_count, d.self_assessed_flag self_assessed_flag, decode(d.self_assessed_flag,'Y',1,0) rev_num, d.remark remark from jai_rep_context_t c, jai_rep_trx_detail_t d where c.rep_context_id = d.rep_context_id and c.extract_summary_code = 'S' and d.first_party_primary_reg_num = :tax_registration_num4 and c.rep_organization_id = :organization_id4 and c.rep_location_id = :location_id4 and d.tax_regime_id = :tax_regime_id4 and c.request_id = :p_conc_request_id group by c.rep_context_entity_name , d.first_party_primary_reg_num , c.rep_organization_id , c.rep_organization_name , c.rep_location_id , c.rep_location_name , d.tax_regime_id , d.tax_regime_name , d.tax_type_id , d.tax_type_name , d.tax_opening_balance , d.self_assessed_flag, d.remark order by rev_num,d.tax_type_name JA JAINLARG_XML US JA India - Tax Liability Register Report(XML Publisher) Application: Asia/Pacific Localizations Source: India - Tax Liability Register Report(XML Publisher) Short Name: JAINLARG_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - 应纳税额登记报表 (XML Publisher) Application: 亚太地区本地化 Source: 印度 - 应纳税额登记报表 (XML Publisher) Short Name: JAINLARG_XML DB package: JAI_EXTRACT_PKG BI Publisher :location_id4 :organization_id4 :p_accounting_status :p_all_item_stock :p_ar_exemption_status :p_balancing_segment_high :p_balancing_segment_low :p_conc_request_id :p_currency_code_high :p_currency_code_low :p_document_type :p_exemption_flag :p_exemption_number :p_exemption_type :p_form_tracking_flag :p_form_type :p_gl_date_high :p_gl_date_low :p_gl_period_name_high :p_gl_period_name_low :p_inter_state_transaction :p_item_class :p_item_id :p_item_only_flag :p_ledger_id :p_legal_entity_id :p_location_id :p_match_status :p_mtl_tran_check_flag :p_org_id :p_organization_id :p_par_registration_status :p_party_id :p_party_name :p_party_site_id :p_party_type :p_posting_status :p_product :p_proof_received_status :p_reg_reporting_context :p_register_type :p_report_name :p_reporting_context :p_reporting_level :p_repository_flag :p_rept_level :p_statistics_beginning_flag :p_statistics_so_flag :p_summary_block_type :p_summary_level :p_suppl_invoice_type_code :p_suppl_process_date_from :p_suppl_process_date_to :p_suppl_show_unraised_flag :p_suppl_trx_date_from :p_suppl_trx_date_to :p_suppl_trx_number :p_tax_account_high :p_tax_account_low :p_tax_category_id :p_tax_invoice_date_high :p_tax_invoice_date_low :p_tax_rate_code_high :p_tax_rate_code_low :p_tax_rate_id :p_tax_reg_num :p_tax_regime_code :p_tax_regime_id :p_tax_status_code :p_tax_type_code_high :p_tax_type_code_low :p_tax_type_id :p_third_party_rep_level :p_trading_flag :p_trx_date_from :p_trx_date_period_name_high :p_trx_date_period_name_low :p_trx_date_to :p_trx_id :p_trx_number_high :p_trx_number_low :p_use_parallel_hint :tax_regime_id4 :tax_registration_num4 1 10 :p_org_id LOV Oracle JA_IN_REP_ORG_ID Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description Y US Operating Unit ZHS 业务实体 2 20 :p_tax_regime_id LOV Oracle JA_IN_REP_REGIME Y select regime_id id, regime_name value, null description from jai_regimes order by regime_code Y US Tax Regime ZHS 税收制度 3 30 :p_tax_reg_num LOV Oracle JA_IN_REP_REG_NUM Y select reg_line.registration_number id, reg_line.registration_number value, null description from jai_party_regs_v reg,jai_party_reg_lines_v reg_line where reg.party_reg_id=reg_line.party_reg_id and reg.reg_class_code='FIRST_PARTY' and reg_line.regime_id=:$flex$.ja_in_rep_regime order by reg_line.registration_number Y US Tax Registration Number ZHS 纳税登记编号 4 40 :p_organization_id LOV Oracle JA_IN_REP_ORGANIZATION Y select organization_id id, name value, null description from hr_all_organization_units where exists (select 'X' from jai_party_regs reg,jai_party_reg_lines reg_line where reg.party_type_code='IO' and reg.party_id=organization_id and reg_line.party_reg_id=reg.party_reg_id and reg_line.registration_number=:$flex$.ja_in_rep_reg_num) order by value,description US Inventory Organization ZHS 库存组织 5 50 :p_location_id LOV Oracle JA_IN_REP_LOCATION Y select hla.location_id id, hla.location_code value, null description from hr_locations_all hla where exists (select 'X' from jai_party_regs reg where reg.party_type_code='IO' and reg.party_id=:$flex$.ja_in_rep_organization and reg.party_site_id=hla.location_id) order by value,description US Location ZHS 地点 6 60 :p_trx_date_from Date US Date From ZHS 日期自 7 70 :p_trx_date_to Date US Date To ZHS 日期至 8 80 :p_tax_type_id LOV Oracle JA_IN_REP_TAX_TYPE Y select tax_type_id id, tax_type_name value, null description from jai_tax_types where regime_id=:$flex$.ja_in_rep_regime order by tax_type_name US Tax Type ZHS 税种 9 90 :p_reg_reporting_context LOV Oracle JAI_IN_REPORT_CONTEXT Y select ja.lookup_code id, ja.lookup_code value, ja.meaning description from ja_lookups ja where lookup_type='JAI_REPT_CONTEXT' and nvl(enabled_flag, 'N')='Y' and trunc(sysdate) between trunc(start_date_active) and trunc(nvl(end_date_active, sysdate)) order by value,description US Reporting Context ZHS 申报环境