ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F23E3869E053B46B63588994Y select run_flag, run_time, status_type, status_code, currency, number_of_contracts , oks_extwar_util_pvt.round_currency_amt(contract_value,currency) contract_value, oks_extwar_util_pvt.round_currency_amt(booking_forecast,currency) booking_forecast, oks_extwar_util_pvt.round_currency_amt(rev_rec_value,currency) rev_rec_value, oks_extwar_util_pvt.round_currency_amt(forecast_value,currency) forecast_value from oks_status_forecast where conc_request_id = :p_conc_request_id OKS OKSFOSUM_XML AR OKS تقرير إجمالي تقدير عقود الخدمة Application: عقود الخدمة Source: تقرير إجمالي تقدير عقود الخدمة (XML) Short Name: OKSFOSUM_XML DB package: OKS_OKSFOSUM_XMLP_PKG D OKS Oracle Service Contracts - Forecast-Übersicht Application: Service Contracts Source: Oracle Service Contracts - Forecast-Übersicht (XML) Short Name: OKSFOSUM_XML DB package: OKS_OKSFOSUM_XMLP_PKG F OKS Service Contracts - Etat de synthèse des prévisions Application: Service Contracts Source: Service Contracts - Etat de synthèse des prévisions (XML) Short Name: OKSFOSUM_XML DB package: OKS_OKSFOSUM_XMLP_PKG US OKS Service Contracts Forecast Summary Application: Service Contracts Source: Service Contracts Forecast Summary Report (XML) Short Name: OKSFOSUM_XML DB package: OKS_OKSFOSUM_XMLP_PKG ZHS OKS 服务合同预测汇总报表 Application: 服务合同管理系统 Source: 服务合同预测汇总报表 (XML) Short Name: OKSFOSUM_XML DB package: OKS_OKSFOSUM_XMLP_PKG BI Publisher :cp_org_name :lp_operating_unit :p_conc_request_id :p_contract_group :p_contract_group_name :p_currency_code :p_end_date :p_end_date1 :p_max_val :p_min_val :p_operating_unit :p_org_name :p_rev_rec_date :p_revenue_recognized :p_start_date :p_start_date1 :p_where_clause 1 10 :p_contract_group LOV Oracle OKS_CONTRACT_GROUPS Y select id id, name value, null description from okc_k_groups_v where user_id is null or user_id=fnd_global.user_id order by value,description AR مجموعة العقود D Vertragsgruppe F Groupe de contrats US Contract Group ZHS 合同组 2 20 :p_operating_unit LOV Oracle OKS_OPERATING_UNITS Y select organization_id id, name value, null description from hr_operating_units where sysdate between nvl(date_from,sysdate) and nvl(date_to,sysdate) and (mo_global.check_access(organization_id)='Y') order by value,description AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 3 30 :p_currency_code LOV Oracle OKS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR رمز العملة D Währungsschlüssel F Code devise US Currency Code ZHS 币种代码 4 40 :p_start_date Date AR تاريخ البداية D Startdatum F Date de début US Start Date ZHS 起始日期 5 50 :p_end_date Date AR تاريخ النهاية D Enddatum F Date de fin US End Date ZHS 终止日期 6 60 :p_min_val Number AR الحد الأدنى لقيمة العقد D Mindestvertragswert F Valeur de contrat minimum US Minimum Contract Value ZHS 最小合同值 7 70 :p_max_val Number AR الحد الأقصى لقيمة العقد D Höchstvertragswert F Valeur de contrat maximum US Maximum Contract Value ZHS 最大合同值 8 80 :p_rev_rec_date Date AR تاريخ الإيراد المعتمد D Umsatz anerkannt am F Date produit constaté US Recognized Revenue Date ZHS 收入确认日期