ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0D93869E053B46B63588994 SELECT PRODUCT_CODE || '+' || NVL(PRODUCT_DESCRIPTION, TRX_LINE_DESCRIPTION) || '+' || INTENDED_USE_DESC || '+' || TAX_TYPE_NAME || '+' || TO_CHAR(TAXABLE_AMT_TRX_CURR) GROUP_KEY, TRX_LINE_ID GROUP_LINE_ID, PRODUCT_CODE, NVL(PRODUCT_DESCRIPTION, TRX_LINE_DESCRIPTION) DESCRIPTION, INTENDED_USE_DESC, TAX_TYPE_NAME, NULL TAX_RATE_NAME, NULL TAX_INVOICE_NUMBER, NULL TAX_INVOICE_DATE, --Modified by Junjian for bug#19435450 begin DECODE(trx_type,'RETURN TO RECEIVING',-1,'RETURN TO VENDOR',-1,1 )*TAXABLE_AMT_TRX_CURR TAXABLE_AMT, DECODE(trx_type,'RETURN TO RECEIVING',-1,'RETURN TO VENDOR',-1,1 )*SUM(TAX_AMT_TRX_CURR) TAX_AMT, DECODE(trx_type,'RETURN TO RECEIVING',-1,'RETURN TO VENDOR',-1,1 )*SUM(REC_TAX_AMT_TRX_CURR) REC_TAX_AMT --Modified by Junjian for bug#19435450 end FROM JAI_REP_TRX_DETAIL_T WHERE TRX_ID = :TRX_ID AND REQUEST_ID = :P_REQUEST_ID AND NVL(TRX_TYPE, '###') = NVL(:TRX_TYPE, '###') AND --Added by Junjian for bug#19435450 REP_CONTEXT_ID = :REP_CONTEXT_ID AND -- added by zhiwei.xin for bug#19436697 'SUMMARY' = NVL(:P_REPT_LEVEL, 'SUMMARY') GROUP BY TRX_LINE_ID, PRODUCT_CODE, NVL(PRODUCT_DESCRIPTION, TRX_LINE_DESCRIPTION), INTENDED_USE, INTENDED_USE_DESC, TAX_TYPE_ID, TAX_TYPE_NAME, TRX_TYPE, --Added by Junjian for bug#19435450 TAXABLE_AMT_TRX_CURR UNION ALL SELECT PRODUCT_CODE || '+' || NVL(PRODUCT_DESCRIPTION, TRX_LINE_DESCRIPTION) || '+' || INTENDED_USE_DESC || '+' || TAX_TYPE_NAME || '+' || TAX_RATE_NAME || '+' || TAX_INVOICE_NUMBER || '+' || to_char(TAX_INVOICE_DATE, 'dd-Mon-yyyy') || '+' || TO_CHAR(TAXABLE_AMT_TRX_CURR) GROUP_KEY, TRX_LINE_ID GROUP_LINE_ID, PRODUCT_CODE, NVL(PRODUCT_DESCRIPTION, TRX_LINE_DESCRIPTION) DESCRIPTION, INTENDED_USE_DESC, TAX_TYPE_NAME, TAX_RATE_NAME, TAX_INVOICE_NUMBER, to_char(TAX_INVOICE_DATE, 'dd-Mon-yyyy') TAX_INVOICE_DATE, --Modified by Junjian for bug#19435450 begin DECODE(trx_type,'RETURN TO RECEIVING',-1,'RETURN TO VENDOR',-1,1 )*TAXABLE_AMT_TRX_CURR TAXABLE_AMT, DECODE(trx_type,'RETURN TO RECEIVING',-1,'RETURN TO VENDOR',-1,1 )*SUM(TAX_AMT_TRX_CURR) TAX_AMT, DECODE(trx_type,'RETURN TO RECEIVING',-1,'RETURN TO VENDOR',-1,1 )*SUM(REC_TAX_AMT_TRX_CURR) REC_TAX_AMT --Modified by Junjian for bug#19435450 end FROM JAI_REP_TRX_DETAIL_T WHERE TRX_ID = :TRX_ID AND REQUEST_ID = :P_REQUEST_ID AND NVL(TRX_TYPE, '###') = NVL(:TRX_TYPE, '###') AND --Added by Junjian for bug#19435450 REP_CONTEXT_ID = :REP_CONTEXT_ID AND -- added by zhiwei.xin for bug#19436697 'DETAIL' = NVL(:P_REPT_LEVEL, 'SUMMARY') GROUP BY TRX_LINE_ID, PRODUCT_CODE, NVL(PRODUCT_DESCRIPTION, TRX_LINE_DESCRIPTION), INTENDED_USE, INTENDED_USE_DESC, TAX_TYPE_ID, TAX_TYPE_NAME, TAX_RATE_ID, TAX_RATE_NAME, TAX_INVOICE_NUMBER, TAX_INVOICE_DATE, TRX_TYPE, --Added by Junjian for bug#19435450 TAXABLE_AMT_TRX_CURR Y JA JAINTREG_XML US JA India - Tax Register Report(XML Publisher) Application: Asia/Pacific Localizations Source: India - Tax Register Report(XML Publisher) Short Name: JAINTREG_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - 纳税登记报表 (XML Publisher) Application: 亚太地区本地化 Source: 印度 - 纳税登记报表 (XML Publisher) Short Name: JAINTREG_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_request_id :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 :rep_context_id :trx_id :trx_type 1 10 :p_org_id LOV Oracle JAI_MOAC_ORGANIZATIONS Y select organization_id id, name value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by name Y US Operating Unit ZHS 业务实体 2 20 :p_tax_regime_name LOV Oracle JAI_TAX_REGIMES Y select regime_id id, regime_name value, null description from jai_regimes where effective_from<=trunc(sysdate) and nvl(effective_to,trunc(sysdate)+1)>=trunc(sysdate) order by regime_name US Tax Regime Name ZHS 税制名称 3 30 :p_tax_reg_num LOV Oracle JAI_INV_ORG_TAX_REG_NUM Y select line.registration_number id, line.registration_number value, null description from jai_party_regs reg,jai_party_reg_lines line,org_organization_definitions ood,hr_locations loc where reg.party_reg_id=line.party_reg_id and line.regime_id=:$flex$.jai_tax_regimes and trunc(sysdate) between trunc(nvl(line.effective_from,sysdate-1)) and trunc(nvl(line.effective_to,sysdate+1)) and reg.party_id=ood.organization_id(+) and reg.party_site_id=loc.location_id(+) and reg.party_type_code='IO' and reg.org_id=:$flex$.jai_moac_organizations order by value,description US Tax Registration Number ZHS 纳税登记编号 4 40 :p_organization_id LOV Oracle JAI_TAX_REG_INV_ORGANIZATIONS Y select org.organization_id id, org.organization_name value, null description from org_organization_definitions org where exists (select 1 from jai_party_regs reg, jai_party_reg_lines line where org.organization_id=reg.party_id and reg.party_reg_id=line.party_reg_id and reg.org_id=:$flex$.jai_moac_organizations and reg.party_type_code='IO' and line.registration_number= :$flex$.jai_inv_org_tax_reg_num and line.regime_id=:$flex$.jai_tax_regimes) order by value,description US Inventory Organization ZHS 库存组织 5 50 :p_location_id LOV Oracle JAI_TAX_REG_LOCATIONS Y select loc.location_id id, loc.description value, null description from hr_locations loc where exists (select 1 from jai_party_regs reg, jai_party_reg_lines line where loc.inventory_organization_id=reg.party_id and loc.location_id=reg.party_site_id and reg.party_type_code='IO' and reg.party_reg_id=line.party_reg_id and reg.org_id=:$flex$.jai_moac_organizations and line.registration_number= :$flex$.jai_inv_org_tax_reg_num and line.regime_id=:$flex$.jai_tax_regimes and loc.inventory_organization_id=:$flex$.jai_tax_reg_inv_organizations) order by value,description US Location ZHS 地点 6 60 :p_product LOV Oracle JAI_REG_DOCUMENT_TYPE Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JAI_REPO_DOCUMENT_TYPE' and enabled_flag='Y' order by value,description US Document Type ZHS 单据类型 7 70 :p_trx_date_from Date US Document Date From ZHS 单据日期自 8 80 :p_trx_date_to Date US Document Date To ZHS 单据日期至 9 90 :p_party_type LOV Oracle JAI_PARTY_TYPE Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JAI_NEW_PARTY_TYPE' order by value,description US Party Type ZHS 交易方类型 10 100 :p_party_id LOV Oracle JAI_PARTY_NAME Y select tbl.id id, tbl.name value, null description from (select 'SUPPLIER' type,vendor_id id,vendor_name name from po_vendors union select 'CUSTOMER' type,cust.cust_account_id id,party.party_name name from hz_parties party,hz_cust_accounts cust where party.party_id=cust.party_id) tbl where tbl.type=:$flex$.jai_party_type order by name US Party Name ZHS 交易方名称 11 110 :p_party_site_id LOV Oracle JAI_PARTY_SITE_NAME Y select party_site_id id, party_site_name value, null description from jai_party_sites_v where party_id=:$flex$.jai_party_name and party_type=:$flex$.jai_party_type and org_id=:$flex$.jai_moac_organizations order by value,description US Party Site Name ZHS 交易方地点名称 12 120 :p_par_registration_status LOV Oracle JAI_PARTY_REG_STATUS Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JAI_PARTY_REG_STATUS' order by value,description US Party Registration Status ZHS 交易方登记状态 13 130 :p_inter_state_transaction LOV Oracle JAI_Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description US Inter-State Transaction ZHS 国家间的事务处理 14 140 :p_rept_level LOV Oracle JAI_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JAI_REPORTING_LEVEL' order by value,description US Reporting Level ZHS 申报级别 :$flex$.jai_inv_org_tax_reg_num Tax Registration Number Inventory Organization :$flex$.jai_inv_org_tax_reg_num Tax Registration Number Location :$flex$.jai_moac_organizations Operating Unit Inventory Organization :$flex$.jai_moac_organizations Operating Unit Location :$flex$.jai_moac_organizations Operating Unit Party Site Name :$flex$.jai_moac_organizations Operating Unit Tax Registration Number :$flex$.jai_party_name Party Name Party Site Name :$flex$.jai_party_type Party Type Party Name :$flex$.jai_party_type Party Type Party Site Name :$flex$.jai_tax_reg_inv_organizations Inventory Organization Location :$flex$.jai_tax_regimes Tax Regime Name Inventory Organization :$flex$.jai_tax_regimes Tax Regime Name Location :$flex$.jai_tax_regimes Tax Regime Name Tax Registration Number