ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0A03869E053B46B63588994 select max(a.transaction_date) transaction_date , min(a.receipt_ref) receipt_id, min(a.division_no) division_no, min(a.range_no) range_no, sum(nvl(a.cr_basic_ed,0)) cr_basic_ed, sum(nvl(a.cr_additional_ed,0)) cr_additional_ed, sum(nvl(a.cr_other_ed,0)) cr_other_ed, sum(nvl(a.cr_additional_ed,0)) + sum(nvl(a.cr_other_ed,0)) cr_addl_n_oth_ed, a.excise_invoice_no excise_invoice_no, a.excise_invoice_date excise_invoice_date, sum(nvl(a.dr_basic_ed,0)) dr_basic_ed, sum(nvl(a.dr_additional_ed,0)) dr_additional_ed, sum(nvl(a.dr_other_ed,0)) dr_other_ed, sum(nvl(a.dr_additional_ed,0)) + sum(nvl(a.dr_other_ed,0)) dr_addl_n_oth_ed, sum(nvl(a.other_tax_credit,0)) other_tax_credit, sum(nvl(a.other_tax_debit,0)) other_tax_debit, SUM(NVL(a.cr_additional_cvd, 0)) cr_additional_cvd, SUM(NVL(a.dr_additional_cvd, 0)) dr_additional_cvd, a.vendor_id vendor_id, a.vendor_site_id vendor_site_id, a.customer_id customer_id, a.customer_site_id customer_site_id, a.transaction_source_num transaction_id, JA_JAIN23P2_XMLP_PKG.cf_register_idformula(min ( a.receipt_ref )) CF_register_id, JA_JAIN23P2_XMLP_PKG.cf_division_noformula(a.vendor_id, a.vendor_site_id, min ( a.receipt_ref ), min ( a.division_no )) CF_Division_No, JA_JAIN23P2_XMLP_PKG.cf_range_noformula(a.vendor_id, a.vendor_site_id, min ( a.receipt_ref ), min ( a.range_no )) CF_Range_No, JA_JAIN23P2_XMLP_PKG.cf_ec_code_suppformula(a.vendor_id, a.vendor_site_id, sum ( nvl ( a.cr_basic_ed , 0 ) ), sum ( nvl ( a.cr_additional_ed , 0 ) ), SUM ( NVL ( a.cr_additional_cvd , 0 ) ), sum ( nvl ( a.cr_other_ed , 0 ) ), min ( a.receipt_ref )) CF_EC_Code_Supp, JA_JAIN23P2_XMLP_PKG.cf_ec_code_custformula(a.customer_id, a.customer_site_id, sum ( nvl ( a.dr_basic_ed , 0 ) ), sum ( nvl ( a.dr_additional_ed , 0 ) ), sum ( nvl ( a.dr_other_ed , 0 ) )) CF_EC_Code_Cust, JA_JAIN23P2_XMLP_PKG.cf_folio_part_iformula(a.excise_invoice_no, a.excise_invoice_date) CF_folio_part_i, JA_JAIN23P2_XMLP_PKG.CF_SEQUENCE_NOFORMULA CF_Sequence_No, JA_JAIN23P2_XMLP_PKG.cf_rounding_amountformula(a.transaction_source_num, a.excise_invoice_no, a.excise_invoice_date, min ( a.receipt_ref )) CF_Rounding_Amount, JA_JAIN23P2_XMLP_PKG.cf_cr_basic_edformula(sum ( nvl ( a.cr_basic_ed , 0 ) ), JA_JAIN23P2_XMLP_PKG.cf_rounding_amountformula(a.transaction_source_num, a.excise_invoice_no, a.excise_invoice_date, min ( a.receipt_ref ))) CF_Cr_Basic_ed, JA_JAIN23P2_XMLP_PKG.cf_receipt_numformula(a.excise_invoice_no, a.excise_invoice_date, min ( a.receipt_ref ), a.transaction_source_num) CF_Receipt_Num, JA_JAIN23P2_XMLP_PKG.cf_cr_cvdformula(a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, a.vendor_site_id, a.customer_id, a.customer_site_id) CF_CR_CVD, JA_JAIN23P2_XMLP_PKG.cf_cr_exciseformula(a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, a.vendor_site_id, a.customer_id, a.customer_site_id) CF_CR_EXCISE, JA_JAIN23P2_XMLP_PKG.cf_cr_sh_cvdformula(a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, a.vendor_site_id, a.customer_id, a.customer_site_id, a.transaction_source_num) CF_CR_SH_CVD, JA_JAIN23P2_XMLP_PKG.cf_cr_sh_exciseformula(a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, a.vendor_site_id, a.customer_id, a.customer_site_id, a.transaction_source_num) CF_CR_SH_EXCISE, JA_JAIN23P2_XMLP_PKG.cf_dr_exciseformula(sum ( nvl ( a.other_tax_debit , 0 ) )) CF_DR_EXCISE, JA_JAIN23P2_XMLP_PKG.cf_dr_cvdformula() CF_DR_CVD, JA_JAIN23P2_XMLP_PKG.cf_dr_sh_exciseformula(a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, a.vendor_site_id, a.customer_id, a.customer_site_id, a.transaction_source_num) CF_DR_SH_EXCISE, JA_JAIN23P2_XMLP_PKG.cf_dr_sh_cvdformula(a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, a.vendor_site_id, a.customer_id, a.customer_site_id, a.transaction_source_num) CF_DR_SH_CVD, JA_JAIN23P2_XMLP_PKG.cf_additional_amountformula(sum ( nvl ( a.cr_additional_ed , 0 ) )) CF_additional_amount, JA_JAIN23P2_XMLP_PKG.cf_additionalcvd_amountformula(SUM ( NVL ( a.cr_additional_cvd , 0 ) )) CF_additionalcvd_amount, JA_JAIN23P2_XMLP_PKG.cf_other_amountformula(sum ( nvl ( a.cr_other_ed , 0 ) )) CF_Other_Amount, JA_JAIN23P2_XMLP_PKG.cf_dr_addl_n_oth_edformula(sum ( nvl ( a.dr_additional_ed , 0 ) ) + sum ( nvl ( a.dr_other_ed , 0 ) )) cf_dr_addl_n_oth_ed, JA_JAIN23P2_XMLP_PKG.cf_dr_addl_cvdformula(SUM ( NVL ( a.dr_additional_cvd , 0 ) )) cf_dr_addl_cvd, JA_JAIN23P2_XMLP_PKG.cf_dr_basic_edformula(sum ( nvl ( a.dr_basic_ed , 0 ) )) cf_dr_basic_ed, JA_JAIN23P2_XMLP_PKG.CP_additional_rounding_p CP_additional_rounding, JA_JAIN23P2_XMLP_PKG.CP_additionalcvd_rounding_p CP_additionalcvd_rounding, JA_JAIN23P2_XMLP_PKG.CP_other_rounding_p CP_other_rounding, JA_JAIN23P2_XMLP_PKG.cp_rounded_excise_cess_p cp_rounded_excise_cess, JA_JAIN23P2_XMLP_PKG.CP_ROUNDED_SH_EXCISE_CESS_p CP_ROUNDED_SH_EXCISE_CESS, JA_JAIN23P2_XMLP_PKG.cp_rounded_cvd_cess_p cp_rounded_cvd_cess, JA_JAIN23P2_XMLP_PKG.CP_rounded_sh_cvd_cess_p CP_rounded_sh_cvd_cess, JA_JAIN23P2_XMLP_PKG.CP_rnd_dr_basic_ed_p CP_rnd_dr_basic_ed, JA_JAIN23P2_XMLP_PKG.cp_rnd_dr_addl_ed_p cp_rnd_dr_addl_ed, JA_JAIN23P2_XMLP_PKG.cp_rnd_dr_addl_cvd_p cp_rnd_dr_addl_cvd, JA_JAIN23P2_XMLP_PKG.cp_rnd_dr_other_ed_p cp_rnd_dr_other_ed, JA_JAIN23P2_XMLP_PKG.cp_rnd_dr_exc_edu_cess_p cp_rnd_dr_exc_edu_cess, JA_JAIN23P2_XMLP_PKG.CP_RND_DR_SH_CVD_EDU_CESS_p CP_RND_DR_SH_CVD_EDU_CESS, JA_JAIN23P2_XMLP_PKG.cp_rnd_dr_cvd_edu_cess_p cp_rnd_dr_cvd_edu_cess, JA_JAIN23P2_XMLP_PKG.CP_RND_DR_SH_EXC_EDU_CESS_p CP_RND_DR_SH_EXC_EDU_CESS from JAI_CMN_RG_23AC_II_TRXS a where a.organization_id = :p_organization_id and a.location_id = :p_location_id and register_type = :p_register_type and a.Inventory_Item_id <> 0 &P_QUERY_CONCAT Group By a.excise_invoice_no , a.excise_invoice_date, a.vendor_id , a.vendor_site_id, a.customer_id, a.customer_site_id, a.transaction_source_num ORDER BY 1 JA JAI23A_2_XML US JA India - RG23 Part II Report - draft - draft Application: Asia/Pacific Localizations Source: India - RG23 Part II Report (XML) - Not Supported: Reserved For Future Use - Not Supported: Reserved For Future Use Short Name: JAI23A_2_XML DB package: JA_JAIN23P2_XMLP_PKG ZHS JA 印度 - RG23 报表第二部分- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - RG23 报表第二部分 (XML) - 不支持：已保留供将来使用 Short Name: JAI23A_2_XML DB package: JA_JAIN23P2_XMLP_PKG BI Publisher &p_query_concat :c_address_line_1 :c_address_line_2 :c_address_line_3 :c_description :c_ec_code :c_excisecircle :c_excisecomm :c_excisedivision :c_exciserange :c_name :cp_1 :cp_additional_rounding :cp_additionalcvd_rounding :cp_other_rounding :cp_report_title :cp_rnd_dr_addl_cvd :cp_rnd_dr_addl_ed :cp_rnd_dr_basic_ed :cp_rnd_dr_cvd_edu_cess :cp_rnd_dr_exc_edu_cess :cp_rnd_dr_other_ed :cp_rnd_dr_sh_cvd_edu_cess :cp_rnd_dr_sh_exc_edu_cess :cp_rounded_cvd_cess :cp_rounded_excise_cess :cp_rounded_sh_cvd_cess :cp_rounded_sh_excise_cess :p_close_bal :p_conc_request_id :p_cvd_edu_cess_op_bal :p_cvd_edu_sh_cess_op_bal :p_exc_edu_cess_op_bal :p_exc_edu_sh_cess_op_bal :p_first_rec :p_location_id :p_open_bal :p_open_bal_oth :p_organization_id :p_prev_close_bal :p_query_concat :p_register_type :p_report_seq_no :p_selected_register_type :p_start_page_no :p_trn_from_date :p_trn_to_date :v_last_page 1 10 :p_organization_id LOV Oracle ORGANIZATION_23A2 Y select a.organization_id id, a.organization_name value, null description from org_organization_definitions a where exists (select 'X' from jai_cmn_rg_23ac_ii_trxs b where b.organization_id=a.organization_id) order by a.organization_name Y US Organization ZHS 组织 2 20 :p_location_id LOV Oracle LOCATION_23A2 Y select a.location_id id, a.description value, null description from hr_locations a where exists (select 'X' from jai_cmn_rg_23ac_ii_trxs b where b.organization_id=:$flex$.organization_23a2 and b.location_id=a.location_id) order by a.description Y US Location ZHS 地点 3 30 :p_register_type LOV Oracle JA_IN_RG_REGISTER_TYPES Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021176 order by ffvv.flex_value A Y US Register Type ZHS 登记表类型 4 40 :p_trn_from_date Date Y US Transaction From Date ZHS 事务处理起始日期 5 50 :p_trn_to_date Date Y US Transaction To Date ZHS 事务处理终止日期 :$flex$.organization_23a2 Organization Location