ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2413869E053B46B63588994Y SELECT KHD.Id Contract_Id ,KCTS.Object1_Id1 Rep_Name ,KHD.Sts_Code Status_Code ,SUBSTR(KHD.Sts_Code,1,10) Status_Code_SUBSTR ,KSTB.STE_Code Status_Type ,SUBSTR(KSTB.STE_Code,1,10) Status_Type_SUBSTR ,KSTT.Meaning Status_Meaning ,PTYC.Party_Id Customer_Id ,SUBSTR(PTYC.Party_Name,1,22) Customer_Name_Substr ,PTYC.Party_Number Customer_Number ,KHD.Contract_Number_Modifier Contract_Modifier ,SUBSTR(KHD.Contract_Number_Modifier,1,13) Contract_Modifier_Substr ,SUBSTR(KHD.Contract_Number,1,20) Contract_Number_Substr ,KHD.Start_Date Start_Date ,KHD.End_Date End_Date ,ROUND(OKS_Extwar_Util_Pvt.Round_Currency_Amt(KHD.Estimated_Amount,KHD.Currency_Code),0) Total_Value_Round ,KHD.Authoring_Org_Id Org_Id ,ORG.Name Org_Name ,KHD.Currency_Code Currency_Code, OKS_OKSSUMCO_XMLP_PKG.cf_salesrep_nameformula(KCTS.Object1_Id1, KHD.Authoring_Org_Id) CF_salesrep_name, SUBSTR(KSTB.STE_Code,1,10) CF_StatusType_SUBSTR, SUBSTR(KHD.Sts_Code,1,10) CF_StatusCode_SUBSTR, OKS_OKSSUMCO_XMLP_PKG.cf_prodlinevalueformula(KHD.Id, KHD.Sts_Code, KHD.Currency_Code) CF_ProdLineValue_Round, OKS_OKSSUMCO_XMLP_PKG.cf_prodline_valueperdayformula(KHD.Id, KHD.Sts_Code, KHD.Currency_Code) CF_ProdLine_ValuePerDay, OKS_OKSSUMCO_XMLP_PKG.cf_prodline_annrateformula(OKS_OKSSUMCO_XMLP_PKG.cf_prodline_valueperdayformula(KHD.Id, KHD.Sts_Code, KHD.Currency_Code)) CF_ProdLine_AnnRate_Round, OKS_OKSSUMCO_XMLP_PKG.cf_reccountformula() CF_ProdLine_RecCount FROM OKC_K_HEADERS_B KHD ,OKC_K_PARTY_ROLES_B KPRC ,HZ_PARTIES PTYC ,OKC_K_PARTY_ROLES_B KPRV ,OKC_Contacts KCTS ,OKC_Statuses_B KSTB ,OKC_Statuses_TL KSTT ,HR_ALL_ORGANIZATION_UNITS_TL ORG &P_CONTRACT_GROUP_FROM WHERE KHD.Scs_Code IN ('SERVICE','WARRANTY') AND KPRC.Dnz_Chr_Id = KHD.Id AND KPRC.Rle_code = 'CUSTOMER' AND KPRC.Jtot_Object1_Code = 'OKX_PARTY' AND KPRC.Object1_Id1 = PTYC.Party_Id AND KPRC.Object1_Id2 = '#' AND KPRC.Chr_Id = KHD.Id AND KPRC.Cle_Id IS NULL AND KPRV.Dnz_Chr_Id = KHD.Id AND KPRV.Rle_code = 'VENDOR' AND KPRV.Jtot_Object1_Code = 'OKX_OPERUNIT' AND KPRV.Chr_Id = KHD.Id AND KPRV.Cle_Id IS NULL AND KCTS.CPL_Id (+) = KPRV.Id AND KCTS.CRO_Code (+) = :P_Vendor_Cont_Role AND KCTS.JTOT_Object1_Code (+)= 'OKX_SALEPERS' AND KCTS.ID = OKS_EXTWAR_UTIL_PVT.active_salesrep(KHD.ID, KPRV.ID, KHD.authoring_org_id) AND KCTS.Object1_Id2 (+) = '#' AND KSTB.Code = KHD.Sts_Code AND KSTT.Code = KHD.Sts_Code AND KSTB.Code = KSTT.Code AND KSTT.LANGUAGE = USERENV('LANG') AND KHD.Authoring_Org_Id = ORG.Organization_Id AND ORG.Language = USERENV('LANG') &P_START_END_DATE_WHERE &P_REP_NAME_WHERE &P_CUSTOMER_NAME_WHERE &P_STATUS_CODE_WHERE &P_STATUS_TYPE_WHERE &P_ORG_ID_WHERE &P_CUSTOMER_NUMBER_WHERE &P_CURRENCY_CODE_WHERE &P_CONTRACT_GROUP_WHERE order by org_name, org_id, Currency_Code, CF_salesrep_name, Rep_Name, Status_Code, Status_Type, Status_Meaning, Status_Code_SUBSTR, Status_Type_SUBSTR, Customer_Name_Substr, Customer_Number, Contract_Number_Substr, Contract_Modifier, Contract_Modifier_substr, Contract_Id, Customer_Id, Start_Date, End_Date, ORG.Name ,KHD.Currency_Code, KSTB.Ste_Code, KHD.Sts_Code, PTYC.Party_Name, PTYC.Party_Number, KHD.Contract_Number, KHD.Contract_Number_Modifier OKS OKSSUMCO_XML AR OKS عقود الخدمة حسب تقرير الموقف Application: عقود الخدمة Source: عقود الخدمة حسب تقرير الموقف (XML) Short Name: OKSSUMCO_XML DB package: OKS_OKSSUMCO_XMLP_PKG D OKS Serviceverträge nach Status Application: Service Contracts Source: Serviceverträge nach Status (XML) Short Name: OKSSUMCO_XML DB package: OKS_OKSSUMCO_XMLP_PKG F OKS Contrats de service par statut Application: Service Contracts Source: Contrats de service par statut (XML) Short Name: OKSSUMCO_XML DB package: OKS_OKSSUMCO_XMLP_PKG US OKS Service Contracts by Status Application: Service Contracts Source: Service Contracts by Status Report (XML) Short Name: OKSSUMCO_XML DB package: OKS_OKSSUMCO_XMLP_PKG ZHS OKS 按状态列出的服务合同报表 Application: 服务合同管理系统 Source: 按状态列出的服务合同报表 (XML) Short Name: OKSSUMCO_XML DB package: OKS_OKSSUMCO_XMLP_PKG BI Publisher &p_contract_group_from &p_contract_group_where &p_currency_code_where &p_customer_name_where &p_customer_number_where &p_org_id_where &p_rep_name_where &p_start_end_date_where &p_status_code_where &p_status_type_where :lp_end_from_date :lp_end_to_date :lp_start_from_date :lp_start_to_date :p_conc_request_id :p_contract_group :p_contract_group_from :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_detail_yn :p_end_from_date :p_end_to_date :p_org_id :p_org_id_where :p_party_id_name_char :p_party_id_num_char :p_rep_id_char :p_rep_name :p_rep_name_where :p_start_end_date_where :p_start_from_date :p_start_to_date :p_status_code :p_status_code_where :p_status_type :p_status_type_where :p_vendor_cont_role 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_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 Nom du vendeur US Sales Rep Name ZHS 销售代表姓名 4 40 :p_customer_number LOV Oracle OKS_REP_CUSTOMER_NUMBER Y select party_id id, party_number value, party_name description from hz_parties order by party_number AR رقم العميل D Kundennummer F Numéro de client US Customer Number ZHS 客户编号 5 50 :p_customer_name LOV Oracle OKS_REP_CUSTOMER_NAME Y select party_id id, party_name value, party_number description from hz_parties order by party_name AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 6 60 :p_start_from_date Date Y AR من تاريخ البداية D Von Startdatum F Date de début - Du US From Start Date ZHS 自起始日期 7 70 :p_start_to_date Date Y AR إلى تاريخ البداية D Bis Startdatum F Date de début - Au US To Start Date ZHS 至起始日期 8 80 :p_end_from_date Date AR من تاريخ النهاية D Von Enddatum F Date de fin - Du US From End Date ZHS 自终止日期 9 90 :p_end_to_date Date AR إلى تاريخ النهاية D Bis Enddatum F Date de fin - Au US To End Date ZHS 至终止日期 10 100 :p_status_code LOV Oracle OKS_CONTRACT_STATUS_MEAN Y select code id, code value, meaning description from okc_statuses_v order by value,description AR رمز الموقف D Status F Code statut US Status Code ZHS 状态代码 11 110 :p_status_type LOV Oracle OKS_STATUS_VALUES_TEST Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='OKC_STATUS_TYPE' order by value,description AR نوع الموقف D Statusart F Type de statut US Status Type ZHS 状态类型 12 120 :p_currency_code LOV Oracle OKS_CURRENCIES Y select currency_code id, currency_code value, name description from fnd_currencies_vl order by currency_code AR رمز العملة D Währungsschlüssel F Code devise US Currency Code ZHS 币种代码 13 130 :p_detail_yn LOV Oracle OKC_SRS_YN Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type='OKS_Y_N' and lookup_code='Y' AR التقرير التفصيلي D Detailauswertung F Etat détaillé US Detail Report ZHS 明细报表