ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704451A9E05362FB09050512Y SELECT d.detail_tax_line_id report_header_id ,d.detail_tax_line_id detail_tax_line_id ,d.rep_context_id rep_context_id ,d.entity_code entity_code ,d.request_id request_id ,d.tax_regime_id tax_regime_id ,d.tax_regime_code tax_regime_code ,d.tax_regime_name tax_regime_name ,d.first_party_primary_reg_num tax_registration_num ,d.applied_from_trx_date settlement_period_from ,d.applied_to_trx_date settlement_period_to ,d.trx_date settlement_date ,d.posted_date last_settlement_date ,d.party_id organization_id ,d.party_name organization_name ,d.party_site_id location_id ,d.party_site_name location_code ,d.tax_authority_id tax_authority_id ,d.tax_authority_name tax_authority_name ,d.tax_authority_site_id tax_authority_site_id ,d.tax_authority_site_name tax_authority_site_code ,d.matched_amount rounded_amount ,d.liability_amount payable_amount ,d.trx_amount settlement_amount ,e.detail_tax_line_ext_id detail_tax_line_ext_id ,e.numeric1 org_id ,e.numeric2 settlement_template_id ,e.attribute1 org_name ,e.attribute2 template_name FROM jai_rep_trx_detail_t d ,jai_rep_trx_jx_ext_t e WHERE d.detail_tax_line_id = e.detail_tax_line_id AND d.entity_code = 'SETTLEMENT_HEADER' AND d.request_id = :P_CONC_REQUEST_ID ORDER BY d.tax_line_number JA JAINGSTR_XML JA JA インド - 精算詳細レポート(XMLパブリッシャ) Imported from BI Publisher Application: Asia/Pacific Localizations Source: インド - 精算詳細レポート(XMLパブリッシャ) Short Name: JAINGSTR_XML DB package: JAI_EXTRACT_PKG KO JA 인도 - 결산 상세내역 보고서(XML Publisher) Imported from BI Publisher Application: Asia/Pacific Localizations Source: 인도 - 결산 상세내역 보고서(XML Publisher) Short Name: JAINGSTR_XML DB package: JAI_EXTRACT_PKG US JA India - Settlement Detail Report (XML Publisher) Imported from BI Publisher Application: Asia/Pacific Localizations Source: India - Settlement Detail Report (XML Publisher) Short Name: JAINGSTR_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - 结算明细报表 (XML Publisher) Imported from BI Publisher Application: 亚太地区本地化 Source: 印度 - 结算明细报表 (XML Publisher) Short Name: JAINGSTR_XML DB package: JAI_EXTRACT_PKG BI Publisher :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 1 -10 :p_tax_status_code Char STANDALONE JA 精算モード 精算モード KO 결산 모드 결산 모드 US Settlement Mode Settlement Mode ZHS 结算模式 结算模式 2 10 :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 JA 税制 税制ID KO 조세 제도 조세 제도 ID US Tax Regime Tax Regime ID ZHS 税收制度 税制标识 3 20 :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 JA 税登録番号 税登録番号 KO 사업자 등록 번호 사업자 등록 번호 US Tax Registration Number Tax Registration Number ZHS 纳税登记编号 纳税登记编号 4 30 :p_trx_date_from Date select fnd_date.date_to_chardate(TRUNC(SYSDATE, 'MON')) from DUAL Y JA 精算期間: 自 精算期間: 自 KO 결산 기간 시작 결산 기간 시작 US Settlement Period From Settlement Period From ZHS 结算期间自 结算期间自 5 40 :p_trx_date_to Date sysdate Y JA 精算期間: 至 精算期間: 至 KO 결산 기간 종료 결산 기간 종료 US Settlement Period To Settlement Period To ZHS 结算期间至 结算期间至