ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2403869E053B46B63588994 select kh.id contract_id, ct.object1_id1 sr_salesrep_id, kh.currency_code currency_code, pr2.object1_id1 hz_party_id, kh.contract_number contract_number, kh.contract_number_modifier contract_number_modifier, ks.ste_code status_type, kh.sts_code status_code, kr.last_update_date last_update_date, kh.start_date start_date, kh.end_date end_date, kr.Est_Rev_Date forecast_date, kr.Est_Rev_Percent forecast_per, kh.authoring_org_id org_id, OKS_OKSSCOFM_XMLP_PKG.cf_salesrep_nameformula(ct.object1_id1, kh.authoring_org_id) CF_salesrep_name, OKS_OKSSCOFM_XMLP_PKG.cf_party_nameformula(pr2.object1_id1) CF_party_name, OKS_OKSSCOFM_XMLP_PKG.cf_contract_valueformula(kh.id) CF_CONTRACT_VALUE, OKS_OKSSCOFM_XMLP_PKG.cf_rev_recformula(kh.id, OKS_OKSSCOFM_XMLP_PKG.cf_contract_valueformula(kh.id)) CF_REV_REC, OKS_OKSSCOFM_XMLP_PKG.cf_forecast_revformula(OKS_OKSSCOFM_XMLP_PKG.cf_contract_valueformula(kh.id), kr.Est_Rev_Percent, OKS_OKSSCOFM_XMLP_PKG.cf_rev_recformula(kh.id, OKS_OKSSCOFM_XMLP_PKG.cf_contract_valueformula(kh.id))) CF_forecast_rev, OKS_OKSSCOFM_XMLP_PKG.cf_contract_forecastformula(OKS_OKSSCOFM_XMLP_PKG.cf_contract_valueformula(kh.id), kr.Est_Rev_Percent) CF_CONTRACT_FORECAST from oks_k_headers_b kr, okc_contacts ct, okc_statuses_b ks, okc_k_party_roles_b pr2, okc_k_party_roles_b pr, okc_k_headers_b kh where kh.scs_code IN ('SERVICE','WARRANTY') and kh.id = pr.dnz_chr_id and pr.cle_id is null and kh.id=pr.chr_id and ct.cpl_id = pr.id and pr.rle_code = 'VENDOR' and ct.cro_code IN ( 'SALESPERSON', 'SUP_SALES') and ct.ID = OKS_EXTWAR_UTIL_PVT.active_salesrep(kh.ID,pr.ID, kh.authoring_org_id) and kh.id = pr2.dnz_chr_id and pr2.cle_id is null and kh.id=pr2.chr_id and pr2.rle_code = 'CUSTOMER' and ks.code = kh.sts_code and kr.chr_id(+) = kh.id and ks.ste_code = 'ENTERED' &p_where_clause &p_contract_group_where --ORDER BY 3 ASC,14 ASC , kh.estimated_amount Desc order by currency_code, org_id, CF_salesrep_name, CF_CONTRACT_VALUE desc, kh.estimated_amount Desc Y OKS OKSSCOFM_XML AR OKS تقرير إدارة تقدير عقد الخدمة Application: عقود الخدمة Source: تقرير إدارة تقدير عقد الخدمة (XML) Short Name: OKSSCOFM_XML DB package: OKS_OKSSCOFM_XMLP_PKG D OKS Forecasts für Serviceverträge verwalten Application: Service Contracts Source: Forecasts für Serviceverträge verwalten (XML) Short Name: OKSSCOFM_XML DB package: OKS_OKSSCOFM_XMLP_PKG F OKS Gestion des prévisions de contrats de service Application: Service Contracts Source: Gestion des prévisions de contrats de service (XML) Short Name: OKSSCOFM_XML DB package: OKS_OKSSCOFM_XMLP_PKG US OKS Service Contract Forecast Management Application: Service Contracts Source: Service Contract Forecast Management Report (XML) Short Name: OKSSCOFM_XML DB package: OKS_OKSSCOFM_XMLP_PKG ZHS OKS 服务合同预测管理报表 Application: 服务合同管理系统 Source: 服务合同预测管理报表 (XML) Short Name: OKSSCOFM_XML DB package: OKS_OKSSCOFM_XMLP_PKG BI Publisher &p_contract_group_where &p_where_clause :p_conc_request_id :p_contract_group :p_contract_group_name :p_contract_group_where :p_currency_code :p_forecast_end_period :p_forecast_end_period_v :p_forecast_st_period :p_forecast_st_period_v :p_maximum_contract_value :p_minimum_contract_value :p_operating_unit :p_org_name :p_regz_date :p_revenue_reconized :p_salesrep :p_salesrep_name :p_status_code :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_salesrep LOV Oracle OKS_SALESREP_NAME1 Y select resource_id id, name value, null description from oks_rep_v where org_id=oks_util_pub.resp_org_id or oks_util_pub.resp_org_id is null order by value,description AR مندوب المبيعات D Vertriebsmitarbeiter F Vendeur US Sales Rep ZHS 销售代表 4 40 :p_status_code LOV Oracle OKS_STATUS_MEAN Y select code id, meaning value, null description from okc_statuses_v order by value,description AR رمز الموقف D Status F Code statut US Status Code ZHS 状态代码 5 50 :p_currency_code LOV Oracle OKC_SRS_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 币种代码 6 60 :p_minimum_contract_value Number AR الحد الأدنى لقيمة العقد D Mindestvertragswert F Valeur de contrat minimum US Minimum Contract Value ZHS 最小合同值 7 70 :p_maximum_contract_value Number AR الحد الأقصى لقيمة العقد D Höchstvertragswert F Valeur de contrat maximum US Maximum Contract Value ZHS 最大合同值 8 80 :p_forecast_st_period Date AR فترة بداية التقدير D Forecast von Periode F Période de début de prévision US Forecast Start Period ZHS 预测起始期间 9 90 :p_forecast_end_period Date AR قترة نهاية التقدير D Forecast bis Periode F Période de fin de prévision US Forecast End Period ZHS 预测终止期间 10 100 :p_regz_date Date AR تاريخ الإيراد المعتمد D Umsatz anerkannt am F Date produit reconnu US Revenue Recognized Date ZHS 收入确认日期