ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2423869E053B46B63588994Y select REP_NAME, CUSTOMER_ID, CUSTOMER_NUMBER, CUSTOMER_NAME, CONTRACT_ID , CONTRACT_NUMBER , CONTRACT_MODIFIER, STATUS_CODE , STATUS_TYPE , STATUS_MEANING , START_DATE , END_DATE , oks_extwar_util_pvt.round_currency_amt(TOTAL_VALUE,CURRENCY_CODE) total_value , Currency_Code, LAST_UPDATE_DATE , org_id, OKS_OKSSUMRP_XMLP_PKG.cf_1formula(REP_NAME, org_id) CF_salesrep_name, OKS_OKSSUMRP_XMLP_PKG.cf_last_intreractionformula(CONTRACT_ID) CF_last_intreraction from oks_repname_v where 'A' = 'A' &p_start_date_where &p_rep_name_where &p_customer_name_where &p_customer_number_where &p_currency_code_where &p_contract_group_where /*order by REP_NAME, CUSTOMER_NAME, CUSTOMER_NUMBER, Currency_Code, LAST_UPDATE_DATE, CONTRACT_MODIFIER, STATUS_CODE, STATUS_TYPE, org_id, CONTRACT_ID, CUSTOMER_ID, CONTRACT_NUMBER, STATUS_MEANING, START_DATE, END_DATE, total_value, rep_name,status_meaning, nvl(total_value,0) desc,customer_name*/ ORDER BY 1 ASC,4 ASC,3 ASC , rep_name , status_meaning , nvl ( total_value , 0 ) desc , customer_name OKS OKSSUMRP_XML AR OKS تقرير إجمالي عقود الخدمات Application: عقود الخدمة Source: تقرير إجمالي عقود الخدمات (XML) Short Name: OKSSUMRP_XML DB package: OKS_OKSSUMRP_XMLP_PKG D OKS Serviceverträge - Übersicht Application: Service Contracts Source: Serviceverträge - Übersicht (XML) Short Name: OKSSUMRP_XML DB package: OKS_OKSSUMRP_XMLP_PKG F OKS Service Contracts - Etat de synthèse Application: Service Contracts Source: Service Contracts - Etat de synthèse (XML) Short Name: OKSSUMRP_XML DB package: OKS_OKSSUMRP_XMLP_PKG US OKS Service Contracts Summary Application: Service Contracts Source: Service Contracts Summary Report (XML) Short Name: OKSSUMRP_XML DB package: OKS_OKSSUMRP_XMLP_PKG ZHS OKS 服务合同汇总报表 Application: 服务合同管理系统 Source: 服务合同汇总报表 (XML) Short Name: OKSSUMRP_XML DB package: OKS_OKSSUMRP_XMLP_PKG BI Publisher &p_contract_group_where &p_currency_code_where &p_customer_name_where &p_customer_number_where &p_rep_name_where &p_start_date_where :p_conc_request_id :p_contract_group :p_contract_group_where :p_currency_code :p_currency_code_where :p_customer_name :p_customer_name_where :p_customer_number :p_customer_number_where :p_from_date :p_operating_unit :p_org_id_where :p_rep_name :p_rep_name_where :p_start_date_where :p_to_date 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_rep_name LOV Oracle OKS_SALESREPS Y select id1 id, name value, null description from okx_salesreps_v order by name AR اسم التقرير D Vertriebsmitarbeiter F Nom rep. US Rep Name ZHS 销售代表姓名 4 40 :p_customer_number LOV Oracle OKS_PARTY_CUSTOMER_NUMBER Y Y select party_id id, party_number value, party_name description from oks_parties_v order by value,description AR رقم العميل D Kundennummer F Numéro de client US Customer Number ZHS 客户编号 5 50 :p_customer_name LOV Oracle OKS_PARTY_CUSTOMER_NAME Y Y select party_id id, party_name value, party_number description from oks_parties_v order by value,description AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 6 60 :p_from_date Date AR من تاريخ D Von Datum F Date - Du US From Date ZHS 自日期 7 70 :p_to_date Date select sysdate from dual AR إلى التاريخ D Bis Datum F Date de fin US To Date ZHS 终止日期 8 80 :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 币种代码