ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F23C3869E053B46B63588994 SELECT okc_hdr.currency_code ,salesrep.name ,hzp.party_name ,to_char(okc_hdr.date_approved,'DD-MON-YY') date_approved ,okc_hdr.contract_number ,okc_hdr.contract_number_modifier ,oks_extwar_util_pvt.round_currency_amt(okc_hdr.estimated_amount,okc_hdr.currency_code) "estimated_amount" ,okc_hdr.start_date ,okc_hdr.id FROM okc_k_headers_b okc_hdr ,okc_k_party_roles_b party ,okc_k_party_roles_b party1 ,okc_contacts contact ,jtf_rs_salesreps salesrep ,hz_parties hzp ,okx_organization_defs_v org &p_contract_group_from WHERE okc_hdr.sts_code IN ('ACTIVE','APPROVED','SIGNED') AND okc_hdr.scs_code IN ('SERVICE','WARRANTY') AND okc_hdr.id = party.dnz_chr_id AND party.cle_id is NULL AND party.rle_code = 'CUSTOMER' AND okc_hdr.id = party1.dnz_chr_id AND party1.cle_id IS NULL AND contact.cpl_id = party1.id AND contact.CRO_CODE IN ('SUP_SALES','SALESPERSON') AND contact.ID = OKS_EXTWAR_UTIL_PVT.active_salesrep(okc_hdr.ID,party1.ID, okc_hdr.authoring_org_id) AND party1.rle_code = 'VENDOR' AND hzp.party_id = TO_NUMBER(party.object1_id1) AND salesrep.salesrep_id = TO_NUMBER(contact.object1_id1) AND salesrep.org_id = okc_hdr.authoring_org_id AND okc_hdr.authoring_org_id = org.organization_id AND org.organization_type = 'OPERATING_UNIT' AND org.information_type = 'Operating Unit Information' &p_approved_date_where &p_start_date_where &p_org_where &p_salesrep_where &p_value_where &p_contract_group_where &p_order_by_order Y OKS OKSCOBKS_XML AR OKS تقرير عمليات حجز عقود الخدمة Application: عقود الخدمة Source: تقرير عمليات حجز عقود الخدمة (XML) Short Name: OKSCOBKS_XML DB package: OKS_OKSCOBKS_XMLP_PKG D OKS Serviceverträge buchen Application: Service Contracts Source: Serviceverträge buchen (XML) Short Name: OKSCOBKS_XML DB package: OKS_OKSCOBKS_XMLP_PKG F OKS Service Contracts - Etat des enregistrements Application: Service Contracts Source: Service Contracts - Etat des enregistrements (XML) Short Name: OKSCOBKS_XML DB package: OKS_OKSCOBKS_XMLP_PKG US OKS Service Contracts Bookings Application: Service Contracts Source: Service Contracts Bookings Report (XML) Short Name: OKSCOBKS_XML DB package: OKS_OKSCOBKS_XMLP_PKG ZHS OKS 服务合同登记报表 Application: 服务合同管理系统 Source: 服务合同登记报表 (XML) Short Name: OKSCOBKS_XML DB package: OKS_OKSCOBKS_XMLP_PKG BI Publisher &p_approved_date_where &p_contract_group_from &p_contract_group_where &p_order_by_order &p_org_where &p_salesrep_where &p_start_date_where &p_value_where :p_approved_date_where :p_conc_request_id :p_contract_group :p_contract_group_from :p_contract_group_where :p_date_from :p_date_to :p_order_by :p_order_by_order :p_order_by_order1 :p_org :p_org_where :p_salesrep :p_salesrep_char :p_salesrep_where :p_start_date_from :p_start_date_to :p_start_date_where :p_value :p_value_where 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_start_date_from Date Y AR تاريخ البداية من D Von Startdatum F Date début - Du US Start Date From ZHS 起始日期自 5 50 :p_start_date_to Date Y AR تاريخ البداية إلى D Bis Startdatum F Date début - Au US Start Date To ZHS 起始日期至 6 60 :p_date_from Date AR تاريخ الاعتماد من D Von Genehmigungsdatum F Date d'approbation - Du US Approved Date From ZHS 批准日期自 7 70 :p_date_to Date AR تاريخ الاعتماد إلى D Bis Genehmigungsdatum F Date d'approbation - Au US Approved Date To ZHS 批准日期至 8 80 :p_value Number AR تخطي القيمة D Überschrittener Wert F Valeur excédant US Value Exceeding ZHS 超出值 9 90 :p_order_by LOV Oracle OKS_COBKS_SORT_BY Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='OKS_COBKS_SORT_BY_PARAM' order by meaning AR فرز حسب D Sortieren nach F Tri par US Sort By ZHS 排序依据