ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0D03869E053B46B63588994Y select c.rep_context_entity_name operating_unit2, d.first_party_primary_reg_num tax_registration_num2, c.rep_organization_name organization2, c.rep_location_name location2, d.document_type, d.trx_number document_number, d.tax_regime_id tax_regime_id2, d.tax_regime_name tax_regime_name2, d.tax_type_name tax_type_name2, d.tax_invoice_number, -- d.tax_invoice_date, -- commented out by zhiwei.xin for bug#19450172 to_char(d.tax_invoice_date, 'dd-Mon-yy') tax_invoice_date, -- added by zhiwei.xin for bug#19450172 d.party_name, d.party_site_name, null ecc_code, d.product_code, d.product_code, d.trx_line_amt transaction_amt, d.tax_amt_funcl_curr tax_amt, -- e.date1 recovered_date, -- commented out by zhiwei.xin for bug#19450172 to_char(e.date1, 'dd-Mon-yy') recovered_date, -- added by zhiwei.xin for bug#19450172 e.numeric1 recovered_amt, d.applied_to_trx_number receipt_number, d.item_classification_code item_class, d.intended_use, d.tax_reporting_type, d.tax_reporting_code, d.challan_number||decode(nvl(d.challan_number,'X'),d.challan_number,'/','X','')||d.challan_date remark2 from jai_rep_context_t c, jai_rep_trx_detail_t d, jai_rep_trx_jx_ext_t e where c.rep_context_id = d.rep_context_id and d.detail_tax_line_id = e.detail_tax_line_id and c.extract_summary_code = 'H' 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 d.tax_type_id in (select d.tax_type_id 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 ) and c.request_id = :p_conc_request_id --add by hongjun.wu for bug#21024088 begin-- AND (:cp_reg_reporting_context IS NULL OR nvl(decode(:cp_reg_reporting_context, 'INTENDED_USE', d.intended_use, 'ITEM_CLASS', d.item_classification_code, 'REPORTING_CODE', d.tax_reporting_code), '$$$') = nvl(:reporting_context_value, '$$$')) --add by hongjun.wu for bug#21024088 end-- order by d.tax_type_name,d.document_type,d.trx_number,e.date1 JA JAINRERG_XML US JA India - Tax Recovery Register Report(XML Publisher) Application: Asia/Pacific Localizations Source: India - Tax Recovery Register Report(XML Publisher) Short Name: JAINRERG_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - 退税登记报表 (XML Publisher) Application: 亚太地区本地化 Source: 印度 - 退税登记报表 (XML Publisher) Short Name: JAINRERG_XML DB package: JAI_EXTRACT_PKG BI Publisher :cp_reg_reporting_context :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 :reporting_context_value :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 申报环境