ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704651A9E05362FB09050512 SELECT pll.ship_to_organization_id organization_id, pll.ship_to_location_id location_id1, INV1.invoice_id invoice_id, INV1.invoice_num invoice_num, INV1.invoice_date invoice_date, INV1.invoice_amount invoice_amt, jipov.vendor_id vendor_id, jipov.vendor_site_id vendor_site_id, jitc.tax_id tax_id, jitc.tax_name tax_name, jitc.tax_rate tax_rate, jitc.tax_type tax_type, sum(jiatd.tax_amount) tax_amount, JA_JAINPROS_XMLP_PKG.cf_vend_nameformula(jipov.vendor_id) CF_VEND_NAME, JA_JAINPROS_XMLP_PKG.cf_vend_cstformula(jipov.vendor_id, jipov.vendor_site_id) CF_VEND_CST, JA_JAINPROS_XMLP_PKG.cf_vend_site_codeformula(jipov.vendor_site_id) CF_VEND_SITE_CODE, JA_JAINPROS_XMLP_PKG.cf_reg_noformula(jipov.vendor_id, jipov.vendor_site_id) CF_REG_NO, JA_JAINPROS_XMLP_PKG.CP_VEND_LST_p CP_VEND_LST, JA_JAINPROS_XMLP_PKG.CP_VEND_VAT_p CP_VEND_VAT, JA_JAINPROS_XMLP_PKG.CP_VEND_STATE_p CP_VEND_STATE FROM ap_invoices_all INV1, JAI_AP_MATCH_INV_TAXES jiatd, po_line_locations_all pll, JAI_CMN_TAXES_ALL jitc, JAI_CMN_VENDOR_SITES jipov WHERE jiatd.invoice_id = INV1.invoice_id AND jiatd.line_location_id = pll.line_location_id AND jiatd.tax_id = jitc.tax_id AND jipov.vendor_id = INV1.vendor_id AND jipov.vendor_site_id = INV1.vendor_site_id AND INV1.cancelled_date IS NULL &P_TAX_TYPE_LEX &P_VENDOR_SITE_LEX &P_INVOICE_DATE_LEX and pll.ship_to_organization_id=:orgn_id and pll.ship_to_location_id=:location_id GROUP BY pll.ship_to_organization_id, pll.ship_to_location_id, INV1.invoice_id, INV1.invoice_num, INV1.invoice_date, INV1.invoice_amount, jipov.vendor_id, jipov.vendor_site_id, jitc.tax_id, jitc.tax_name, jitc.tax_rate, jitc.tax_type /*ORDER BY jipov.vendor_id, jipov.vendor_site_id, INV1.invoice_date*/ ORDER BY 1 ASC,2 ASC,7 ASC,8 ASC,3 ASC,5 ASC,4 ASC,6 ASC , jipov.vendor_id , jipov.vendor_site_id , INV1.invoice_date Y JA JAINPROS_XML US JA India - Purchases Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Purchases Outside/Within State and Unregistered Dealers Application: Asia/Pacific Localizations Source: India - Purchases Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINPROS_XML DB package: JA_JAINPROS_XMLP_PKG ZHS JA 印度 - 采购报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 自省内/外以及未登记的经销商处采购 Application: 亚太地区本地化 Source: 印度 - 采购报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINPROS_XML DB package: JA_JAINPROS_XMLP_PKG BI Publisher &p_invoice_date_lex &p_tax_type_lex &p_vendor_site_lex :cp_intadrs :cp_vend_lst :cp_vend_state :cp_vend_vat :location_id :orgn_id :p_conc_request_id :p_end_date :p_end_date1 :p_inv_organization_id :p_invoice_date_lex :p_location_id :p_operating_unit :p_report_type :p_report_type_desc :p_start_date :p_sysdate :p_tax_type_lex :p_vendor_id :p_vendor_site_id :p_vendor_site_lex 1 -20 :p_operating_unit LOV Oracle JA_IN_OPT_UNIT Y select organization_id id, name value, organization_id description from hr_all_organization_units where mo_global.check_access(organization_id)='Y' order by value,description select mo_global.get_current_org_id from dual US Operating Unit Operating Unit taken from Profiles ZHS 业务实体 业务实体 - 取自配置文件 2 10 :p_report_type LOV Oracle JAINPROS_REPORT_TYPE 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=1021165 order by ffvv.flex_value Outside State Y US Report For Based on this parameter report will show data. it can be either OUTSIDE, WITHIN or Unregistered Dealers ZHS 报表 报表将根据此参数显示数据，它可以是“省外”、“省内”或“未登记的经销商”。 3 20 :p_inv_organization_id LOV Oracle ORGANIZATION_PUROS Y select organization_id id, organization_name value, '('||organization_code||'-'||nvl(operating_unit,0)||'-'||legal_entity||')' description from org_organization_definitions ood where organization_id in (select distinct organization_id from jai_cmn_inventory_orgs) order by ood.organization_name Y US Organization ORGANIZATION ZHS 组织 ORGANIZATION 4 30 :p_location_id LOV Oracle LOCATION_PUROS Y select location_id id, description value, null description from hr_locations hloc where location_id in (select distinct location_id from jai_cmn_inventory_orgs where organization_id=:$flex$.organization_puros) order by value,description US Location Location ZHS 地点 地点 5 40 :p_vendor_id LOV Oracle JA_IN_PO_VENDOR_ID Y select vendor_id id, vendor_name value, segment1 description from po_vendors where vendor_id in ( select distinct vendor_id from jai_cmn_vendor_sites ) order by value,description US Supplier Supplier for which the report should display the data. If not selected, then data related to all the customer is shown ZHS 供应商 报表将显示其数据的供应商。如果未选择，则报表将显示有关所有客户的数据。 6 50 :p_vendor_site_id LOV Oracle JA_IN_PO_VENDOR_SITE_ID Y select vendor_site_id id, vendor_site_code value, vendor_site_id description from po_vendor_sites_all where vendor_site_id in ( select vendor_site_id from jai_cmn_vendor_sites where vendor_id=:$flex$.ja_in_po_vendor_id ) and org_id in (select organization_id from hr_operating_units where mo_global.check_access(organization_id)='Y') order by value,description US Supplier Site Supplier Site for which the report should display data. If not selected, then data related to selected supplier would be displayed ZHS 供应商地点 报表将显示其数据的供应商地点。如果未选择，则报表将显示有关选定供应商的数据。 7 60 :p_start_date Date US Start Date START DATE ZHS 起始日期 START DATE 8 70 :p_end_date Date US End Date End Date ZHS 终止日期 终止日期