ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0D83869E053B46B63588994Y select d.party_number, d.party_name, d.party_site_name, d.document_type, d.trx_number doc_number, d.trx_date doc_date, e.attribute1 delivery_num, e.date1 delivery_date, d.tax_invoice_number, d.tax_invoice_date, e.numeric1 exempted_amt, d.exemption_type, d.exemption_num||decode(nvl(to_char(d.exemption_date,'DD-Mon-YYYY'),'X'),'X','','/')||to_char(d.exemption_date,'DD-Mon-YYYY') exemption_ref, d.proof_of_export_num||decode(nvl(to_char(d.proof_received_date,'DD-Mon-YYYY'),'X'),'X','','/')||to_char(d.proof_received_date,'DD-Mon-YYYY') proof_ref 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 = 'L' and d.first_party_primary_reg_num = :tax_registration_num1 and c.rep_organization_id = :organization_id1 and c.rep_location_id = :location_id1 and c.request_id = :p_conc_request_id --edit by hongjun.wu for bug#19477875 begin-- --order by d.tax_type_name order by d.tax_type_name, d.party_number, d.trx_number, d.trx_date, e.attribute1, e.date1 --edit by hongjun.wu for bug#19477875 end-- JA JAINTAEM_XML US JA India - Tax Exemptions Report(XML Publisher) Application: Asia/Pacific Localizations Source: India - Tax Exemptions Report(XML Publisher) Short Name: JAINTAEM_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - 免税报表 (XML Publisher) Application: 亚太地区本地化 Source: 印度 - 免税报表 (XML Publisher) Short Name: JAINTAEM_XML DB package: JAI_EXTRACT_PKG BI Publisher :location_id1 :organization_id1 :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_registration_num1 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_reg_num LOV Oracle JA_IN_REP_EXEMP_REG_NUM Y select reg_line.registration_number id, reg_line.registration_number value, null description from jai_party_regs reg,jai_party_reg_lines reg_line where reg.party_reg_id=reg_line.party_reg_id and reg.party_type_code='IO' order by reg_line.registration_number Y US Tax Registration Number ZHS 纳税登记编号 3 30 :p_organization_id LOV Oracle JA_IN_REP_EXEMP_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_exemp_reg_num) order by value,description US Inventory Organization ZHS 库存组织 4 40 :p_location_id LOV Oracle JA_IN_REP_EXEMP_LOCATION Y select hla.location_id id, hla.description value, null description from hr_locations_all hla where exists (select 'X' from jai_party_regs reg where reg.party_id=:$flex$.ja_in_rep_exemp_organization and reg.party_site_id=hla.location_id) order by value,description US Location ZHS 地点 5 50 :p_exemption_type LOV Oracle JA_IN_REP_EXEMPTION_TYPE Y select lookup_code id, lookup_code value, meaning description from ja_lookups where lookup_type='JAI_EXEMPTION_TYPE' and enabled_flag='Y' and trunc(sysdate) between trunc(nvl(start_date_active,sysdate-1)) and trunc(nvl(end_date_active,sysdate+1)) order by value,description US Exemption Type ZHS 免税类型 6 60 :p_exemption_num LOV Oracle JA_IN_REP_EXEMPTION_NUM Y select exemption_num id, exemption_num value, null description from jai_tax_lines where org_id=:$flex$.ja_in_rep_exemp_organization and first_party_primary_reg_num=:$flex$.ja_in_rep_exemp_reg_num order by exemption_num US Exemption Number ZHS 免税编号 7 70 :p_party_id LOV Oracle JA_IN_REP_CUST_NAME Y select cust.cust_account_id id, party.party_name value, null description from hz_parties party,hz_cust_accounts cust where party.party_id=cust.party_id order by value,description US Customer Name ZHS 客户名称 8 80 :p_party_site_id LOV Oracle JA_IN_REP_CUST_SITE Y select party_site_id id, party_site_name value, null description from jai_party_sites_v where party_id=:$flex$.ja_in_rep_cust_name and party_type='CUSTOMER' and org_id=:$flex$.ja_in_rep_org_id order by value,description US Customer Site ZHS 客户地点 9 90 :p_trx_date_from Date US Date From ZHS 日期自 10 100 :p_trx_date_to Date US Date To ZHS 日期至 11 110 :p_proof_received_status 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 Proof Received Status ZHS 证明已接收状态