ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0C83869E053B46B63588994 SELECT rg23.organization_id , rg23.location_id , rg23.excise_invoice_no , trunc(rg23.excise_invoice_date) excise_invoice_date , sum( nvl(rg23.cr_basic_ed,0) - nvl(rg23.dr_basic_ed,0) ) cenvat , sum( nvl(rg23.cr_other_ed,0) - nvl(rg23.dr_other_ed,0) ) sed , sum( nvl(rg23.cr_additional_ed,0) - nvl(rg23.dr_additional_ed,0) ) additional_duty , sum( nvl(rg23.cr_additional_cvd,0) - nvl(rg23.dr_additional_cvd,0) ) additional_cvd , max( nvl(rg23.cr_basic_ed,0) + nvl(rg23.cr_other_ed,0) + nvl(rg23.cr_additional_ed,0) + nvl(rg23.cr_additional_cvd,0) ) max_transaction_amount , 'AED(TTA)' , 'AED(GSI)' , 'OTHER', max(transaction_source_num) transaction_id, JA_JAINMCEN_XMLP_PKG.cf_rounded_cenvat_amtformula(rg23.excise_invoice_no, rg23.excise_invoice_date, sum ( nvl ( rg23.cr_basic_ed , 0 ) - nvl ( rg23.dr_basic_ed , 0 ) )) CF_rounded_cenvat_amt, JA_JAINMCEN_XMLP_PKG.cf_sedformula(sum ( nvl ( rg23.cr_other_ed , 0 ) - nvl ( rg23.dr_other_ed , 0 ) )) CF_sed, JA_JAINMCEN_XMLP_PKG.cf_addlcvdformula(sum ( nvl ( rg23.cr_additional_cvd , 0 ) - nvl ( rg23.dr_additional_cvd , 0 ) )) CF_addlcvd, JA_JAINMCEN_XMLP_PKG.cf_addlformula(sum ( nvl ( rg23.cr_additional_ed , 0 ) - nvl ( rg23.dr_additional_ed , 0 ) )) CF_addl, JA_JAINMCEN_XMLP_PKG.CF_POP_COUNTFORMULA CF_pop_count, JA_JAINMCEN_XMLP_PKG.CP_sh_edu_p CP_sh_edu, JA_JAINMCEN_XMLP_PKG.CP_edu_p CP_edu, JA_JAINMCEN_XMLP_PKG.CP_addlcvd_p CP_addlcvd, JA_JAINMCEN_XMLP_PKG.CP_addl_p CP_addl, JA_JAINMCEN_XMLP_PKG.CP_sed_p CP_sed FROM JAI_CMN_RG_23AC_II_TRXS rg23 WHERE rg23.register_type = :p_register_type AND (rg23.opening_balance <= rg23.closing_balance OR exists (select 1 from rcv_transactions aa where (aa.transaction_id = rg23.receipt_ref OR to_char(aa.transaction_id) = rg23.reference_num) and ( aa.transaction_type IN ('RECEIVE' , 'DELIVER', 'RETURN TO RECEIVING') OR (aa.transaction_type ='CORRECT' and exists (select 1 from rcv_transactions where transaction_id = aa.parent_transaction_id and transaction_type IN ('RECEIVE' , 'DELIVER', 'RETURN TO RECEIVING')) ) ) ) ) AND rg23.organization_id = :p_organization_id AND rg23.location_id = :p_location_id AND to_date(trunc(rg23.creation_date),'DD-MON-YY') BETWEEN nvl(:p_trn_from_date,to_date(trunc(rg23.creation_date),'DD-MON-YY')) AND nvl(:p_trn_to_date , to_date(trunc(sysdate),'DD-MON-YY')) AND inventory_item_id <> 0 AND nvl(rounding_id,9999) <> -1 GROUP BY rg23.organization_id , rg23.location_id , rg23.excise_invoice_no , rg23.excise_invoice_date , 'AED(TTA)' , 'AED(GSI)' , 'OTHER' ORDER BY rg23.excise_invoice_no , rg23.excise_invoice_date Y JA JAINMCEN_XML US JA India - Cenvat Monthly Returns - draft Application: Asia/Pacific Localizations Source: India - Cenvat Monthly Returns (XML) - Not Supported: Reserved For Future Use Short Name: JAINMCEN_XML DB package: JA_JAINMCEN_XMLP_PKG ZHS JA 印度 - CENVAT 月报税单- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - CENVAT 月报税单 (XML) - 不支持：已保留供将来使用 Short Name: JAINMCEN_XML DB package: JA_JAINMCEN_XMLP_PKG BI Publisher :cp_addl :cp_addlcvd :cp_edu :cp_query_count :cp_report_title :cp_sed :cp_sh_edu :p_address_line_1 :p_address_line_2 :p_address_line_3 :p_circle :p_collect :p_conc_request_id :p_description :p_division :p_ec_code :p_location_id :p_organization_id :p_organization_name :p_range :p_register_type :p_trn_from_date :p_trn_to_date 1 10 :p_organization_id LOV Oracle JA_IN_MFG_ORGANIZATION_NAME Y select hru.organization_id id, hru.name value, null description from hr_all_organization_units hru where exists ( select '1' from jai_cmn_inventory_orgs jhru where jhru.organization_id=hru.organization_id and nvl(jhru.manufacturing,'N')='Y' ) order by hru.name Y US Organization Name ZHS 组织名 2 20 :p_location_id LOV Oracle JA_IN_MFG_LOCATION_NAME Y select hrl.location_id id, hrl.description value, null description from hr_locations hrl where exists ( select '1' from jai_cmn_inventory_orgs jhru where jhru.organization_id=:$flex$.ja_in_mfg_organization_name and jhru.location_id=hrl.location_id and nvl(jhru.manufacturing,'N')='Y' ) order by hrl.description Y US Location Name ZHS 地点名称 3 30 :p_trn_from_date Date US Start Date ZHS 起始日期 4 40 :p_trn_to_date Date US End Date ZHS 终止日期 5 50 :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 Y US Register_type