ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0BE3869E053B46B63588994 SELECT * FROM ( SELECT dtl.party_id party_id ,dtl.party_number party_number ,dtl.party_name party_name ,dtl.party_site_id party_site_id ,dtl.party_site_name party_site_name ,dtl.trx_id trx_id ,dtl.trx_number trx_number ,to_char(dtl.trx_date, 'DD-MON-YYYY') trx_date ,dtl.trx_amount trx_amount ,dtl.trx_line_amt trx_line_amount ,dtl.tax_regime_id tax_regime_id ,dtl.tax_regime_code tax_regime_code ,dtl.tax_regime_code tax_regime_name ,dtl.tax_type_id tax_type_id ,dtl.tax_type_name tax_type_name ,dtl.tax_rate_id tax_rate_id ,dtl.tax_rate_code tax_rate_code ,dtl.tax_amt_trx_curr tax_amt_trx_curr ,to_char(ext.date1, 'DD-MON-YYYY') suppl_process_date ,ext.attribute1 suppl_process_status ,DECODE(ext.attribute1 ,'Y' ,'Raised Supplementary Invoices' ,'Unraised Supplementary Invoices') suppl_process_status_dsp ,ext.attribute2 suppl_invoice_type ,DECODE(ext.attribute2 ,'INV' ,'Invoice' ,'CM' ,'Credit Memo' ,'DM' ,'Debit Memo' ,'Wrong Invoice Type') suppl_invoice_type_dsp ,ext.numeric1 suppl_trx_id ,ext.attribute3 suppl_trx_number ,to_char(ext.date2, 'DD-MON-YYYY') suppl_trx_date ,ext.numeric2 suppl_trx_type_id ,ext.attribute4 suppl_trx_type_name FROM jai_rep_trx_detail_t dtl ,jai_rep_trx_jx_ext_t ext ,jai_rep_context_t hdr WHERE dtl.detail_tax_line_id = ext.detail_tax_line_id AND dtl.rep_context_id = hdr.rep_context_id AND hdr.request_id = :P_CONC_REQUEST_ID ) d Y JA JAINFRMT_XML Y US JA India - ST Forms Report(XML Publisher) Application: Asia/Pacific Localizations Source: India - ST Forms Report(XML Publisher) Short Name: JAINFRMT_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - ST 表单报表 (XML Publisher) Application: 亚太地区本地化 Source: 印度 - ST 表单报表 (XML Publisher) Short Name: JAINFRMT_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_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_id LOV Oracle JAI_CONS_TAX_REGIMES Y select regime_id id, regime_name value, null description from jai_regimes regime where exists(select 1 from jai_tax_rates rate, jai_tax_rate_details dtl where rate.org_id=:$flex$.jai_moac_organizations and rate.regime_id=regime.regime_id and dtl.tax_rate_id=rate.tax_rate_id and dtl.tax_rate_detail_code='TAX_EXCEPTION' and dtl.tax_rate_classification='CONCESSIONAL_RATE') order by value,description Y US Tax Regime ZHS 税收制度 3 30 :p_tax_reg_num LOV Oracle JAI_INV_ORG_CONS_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_cons_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 Y US Registration Number ZHS 登记编号 4 40 :p_organization_id LOV Oracle JAI_CONS_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_cons_tax_reg_num and line.regime_id=:$flex$.jai_cons_tax_regimes) order by value,description US Inventory Organization ZHS 库存组织 5 50 :p_location_id LOV Oracle JAI_CONS_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_cons_tax_reg_num and line.regime_id=:$flex$.jai_cons_tax_regimes and loc.inventory_organization_id=:$flex$.jai_cons_tax_reg_inv_organizations) order by value,description US Location ZHS 地点 6 60 :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 Y US Party Type ZHS 交易方类型 7 70 :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 交易方名称 8 80 :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 ZHS 交易方地点 9 90 :p_form_type LOV Oracle JAI_FORM_TYPES Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JAI_FORM_TYPES' and nvl(enabled_flag,'N')='Y' and (trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate+1))) order by meaning asc US Form Type ZHS 表单类型 10 100 :p_trx_date_from Date US Date From ZHS 日期自 11 110 :p_trx_date_to Date US Date To ZHS 日期至 12 120 :p_match_status LOV Oracle JAI_FORM_MATCHING_STATUS Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JAI_FORMS_MATCHING_STATUS' and nvl(enabled_flag,'N')='Y' and (trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate+1))) order by meaning asc US Matching Status ZHS 匹配状态 :$flex$.jai_cons_tax_reg_inv_organizations Inventory Organization Location :$flex$.jai_cons_tax_regimes Tax Regime Inventory Organization :$flex$.jai_cons_tax_regimes Tax Regime Location :$flex$.jai_cons_tax_regimes Tax Regime Registration Number :$flex$.jai_inv_org_cons_tax_reg_num Registration Number Inventory Organization :$flex$.jai_inv_org_cons_tax_reg_num 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 :$flex$.jai_moac_organizations Operating Unit Registration Number :$flex$.jai_moac_organizations Operating Unit Tax Regime :$flex$.jai_party_name Party Name Party Site :$flex$.jai_party_type Party Type Party Name :$flex$.jai_party_type Party Type Party Site