ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704751A9E05362FB09050512 SELECT vendor_id, vendor_site_id, invoice_id, invoice_num, invoice_date, invoice_currency_code, voucher_num, exchange_rate, po_number, po_header_id, po_release_num, po_creation_date, receipt_number, receipt_date, round(sum(line_amount), :p_rnd_fact) line_amount, round(sum(excise), :p_rnd_fact) excise, round(sum(customs), :p_rnd_fact) customs, round(sum(cvd), :p_rnd_fact) cvd, round(sum(additional_cvd), :p_rnd_fact) addcvd, round(sum(cst), :p_rnd_fact) cst, round(sum(lst), :p_rnd_fact) lst, round(sum(freight), :p_rnd_fact) freight, round(sum(octroi), :p_rnd_fact) octroi, round(sum(others), :p_rnd_fact) others, round( sum(NVL(vat,0) ), :p_rnd_fact ) vat , round(sum(nvl(service_tax,0)), :p_rnd_fact) service_tax, round(sum(line_amount)*exchange_rate, :p_rnd_fact) inr_line_amount, round(sum(excise)*exchange_rate, :p_rnd_fact) inr_excise, round(sum(customs)*exchange_rate, :p_rnd_fact) inr_customs, round(sum(cvd)*exchange_rate, :p_rnd_fact) inr_cvd, round(sum(additional_cvd)*exchange_rate, :p_rnd_fact) inr_addcvd, round(sum(cst)*exchange_rate, :p_rnd_fact) inr_cst, round(sum(lst)*exchange_rate, :p_rnd_fact) inr_lst, round(sum(freight)*exchange_rate, :p_rnd_fact) inr_freight, round(sum(octroi)*exchange_rate, :p_rnd_fact) inr_octroi, round(sum(others)*exchange_rate, :p_rnd_fact) inr_others, round( sum(NVL(vat,0)) * exchange_rate , :p_rnd_fact) inr_tot_vat , round(sum(nvl(service_tax,0))*exchange_rate, :p_rnd_fact) inr_service, round( sum( line_amount + excise + customs + cvd + additional_cvd + cst + lst + freight + octroi + others + vat + service_tax ), :p_rnd_fact) total_amount, round( sum( line_amount + excise + customs + cvd + additional_cvd + cst + lst + freight + octroi + others + vat + service_tax )*exchange_rate, :p_rnd_fact) inr_total_amount, JA_JAINPRRG_XMLP_PKG.cf_total_amountformula(:cs_line_amount, :cs_excise, :cs_cvd, :cs_addcvd, :cs_customs, :cs_cst, :cs_lst, :cs_freight, :cs_octroi, :cs_others) cf_total_amount, JA_JAINPRRG_XMLP_PKG.cf_vendor_nameformula(vendor_id) cf_vendor_name, JA_JAINPRRG_XMLP_PKG.cf_vendor_site_codeformula(vendor_site_id) cf_vendor_site_code, JA_JAINPRRG_XMLP_PKG.cf_po_num_n_releaseformula(po_number, po_release_num) cf_po_num_n_release, JA_JAINPRRG_XMLP_PKG.cp_serial_p cp_serial --,JA_JAINPRRG_XMLP_PKG.P_ORG_ADDR1ValidTrigger FROM JAI_PO_REP_PRRG_T WHERE run_no = :lp_run_no GROUP BY vendor_id, vendor_site_id, invoice_id, invoice_num, invoice_date, invoice_currency_code, voucher_num, exchange_rate, po_number, po_header_id, po_release_num, po_creation_date, receipt_number, receipt_date ORDER BY vendor_id, vendor_site_id, invoice_id, po_header_id, po_release_num, receipt_number Y JA JAINPRRG_XML US JA India - Purchase Register Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Purchase Register Report - India Local Application: Asia/Pacific Localizations Source: India - Purchase Register Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINPRRG_XML DB package: JA_JAINPRRG_XMLP_PKG ZHS JA 印度 - 采购登记表报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 采购登记表报表 - 印度本地化 Application: 亚太地区本地化 Source: 印度 - 采购登记表报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINPRRG_XML DB package: JA_JAINPRRG_XMLP_PKG BI Publisher :cp_serial :cs_addcvd :cs_cst :cs_customs :cs_cvd :cs_excise :cs_freight :cs_line_amount :cs_lst :cs_octroi :cs_others :lp_from_date :lp_org_addr :lp_org_name :lp_run_no :lp_sob_name :lp_to_date :operating_unit :p_commit_data :p_conc_request_id :p_from_date :p_line_no :p_org_addr :p_org_id :p_org_name :p_rnd_fact :p_run_no :p_sob_name :p_to_date :p_vendor_id :p_vendor_site_id 1 -30 :p_org_id Number select mo_global.get_current_org_id from dual US Operating Unit ZHS 业务实体 2 -20 :p_commit_data 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 N US Commit Temp Data Selecting Yes will Commit the Temperory data generated to display in report. If No, then deletes the data ZHS 提交临时数据 选择“是”将提交生成的临时数据以便显示在报表中。如果选择“否”，则删除数据。 3 10 :p_vendor_id LOV Oracle JA_IN_VENDOR_ID Y select vendor_id id, vendor_name value, segment1 description from po_vendors pov where vendor_id in (select distinct vendor_id from jai_cmn_vendor_sites) order by value,description US Vendor Name ZHS 供应商名称 4 20 :p_vendor_site_id LOV Oracle JA_IN_VENDOR_SITE_ID Y select p.vendor_site_id id, p.vendor_site_code value, p.vendor_site_id description from po_vendor_sites_all p where p.vendor_site_id in (select vendor_site_id from jai_cmn_vendor_sites b where b.vendor_id=:$flex$.ja_in_vendor_id ) order by p.vendor_site_code US Vendor Site ZHS 供应商地点 5 30 :p_from_date Date Y US Start Date ZHS 起始日期 6 40 :p_to_date Date Y US End Date ZHS 终止日期