ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F23D3869E053B46B63588994 SELECT SL.Dnz_Chr_Id SL_Dnz_Chr_Id ,SL.Id SL_Id ,SL.Lse_Id SL_Lse_Id ,SL.Line_Number SL_Line_Number ,TO_NUMBER(SL.Line_Number) SL_Line_No ,SL.Start_Date SL_Start_Date ,SL.End_Date SL_End_Date ,CL.Line_Number CL_Line_Number ,TO_NUMBER(CL.Line_Number) CL_Line_No ,CL.Id CL_Id ,CL.Start_Date CL_Start_Date ,CL.End_Date CL_End_Date ,CL.Price_Negotiated ,ST.STE_Code CL_STE_Code ,ST.Meaning STS_Code ,SL.Price_Negotiated SL_Price_Negotiated, OKS_OKSCODET_XMLP_PKG.cf_service_levelformula(SL.Lse_Id, SL.Id) CF_Service_Level, OKS_OKSCODET_XMLP_PKG.cf_srv_price_roundformula(SL.Price_Negotiated, :CURRENCY_CODE) CF_Srv_Price_Round, OKS_OKSCODET_XMLP_PKG.cf_price_negotiated_roundformu(CL.Price_Negotiated, :CURRENCY_CODE) CF_Price_Negotiated_Round, OKS_OKSCODET_XMLP_PKG.cf_cancelled_valueformula(ST.STE_Code, CL.Price_Negotiated) CF_Cancelled_value, OKS_OKSCODET_XMLP_PKG.cf_total_valueformula(ST.STE_Code, CL.Price_Negotiated) CF_Total_value, OKS_OKSCODET_XMLP_PKG.cf_product_detailsformula(CL.Id) CF_Product_Details, OKS_OKSCODET_XMLP_PKG.CP_Prod_Name_p CP_Prod_Name, OKS_OKSCODET_XMLP_PKG.CP_CSI_p CP_CSI, OKS_OKSCODET_XMLP_PKG.CP_Prod_Serial_No_p CP_Prod_Serial_No, OKS_OKSCODET_XMLP_PKG.CP_Prod_Ref_No_p CP_Prod_Ref_No, OKS_OKSCODET_XMLP_PKG.CP_Prod_Qty_p CP_Prod_Qty, OKS_OKSCODET_XMLP_PKG.CP_Num_Of_Users_p CP_Num_Of_Users, OKS_OKSCODET_XMLP_PKG.CP_Pricing_Lic_Lvl_p CP_Pricing_Lic_Lvl, OKS_OKSCODET_XMLP_PKG.CP_Lic_Lvl_p CP_Lic_Lvl FROM OKC_K_Lines_B SL ,OKC_K_Lines_B CL ,OKC_STATUSES_V ST WHERE SL.Lse_ID IN (14, 19) AND SL.Cle_Id IS NULL AND CL.Cle_Id = SL.Id AND CL.Lse_Id IN (18, 25) AND ST.CODE = CL.STS_CODE and SL.Dnz_Chr_Id = :Id10 ORDER By SL_Line_No, SL_Line_Number, SL_Start_Date, SL_End_Date, SL_Dnz_Chr_Id, SL_Id, SL_Lse_Id, CL_STE_Code, STS_Code, CL_Line_No, CL_Line_Number, CL_Start_Date, CL_End_Date, TO_NUMBER(SL.Line_Number) ,TO_NUMBER(CL.Line_Number) Y OKS OKSCODET_XML AR OKS تقرير تفاصيل عقود الخدمة Application: عقود الخدمة Source: تقرير تفاصيل عقود الخدمة (XML) Short Name: OKSCODET_XML DB package: OKS_OKSCODET_XMLP_PKG D OKS Serviceverträge - Details Application: Service Contracts Source: Serviceverträge - Details (XML) Short Name: OKSCODET_XML DB package: OKS_OKSCODET_XMLP_PKG F OKS Service Contracts - Etat détaillé Application: Service Contracts Source: Service Contracts - Etat détaillé (XML) Short Name: OKSCODET_XML DB package: OKS_OKSCODET_XMLP_PKG US OKS Service Contracts Detail Application: Service Contracts Source: Service Contracts Detail Report (XML) Short Name: OKSCODET_XML DB package: OKS_OKSCODET_XMLP_PKG ZHS OKS 服务合同详细信息报表 Application: 服务合同管理系统 Source: 服务合同详细信息报表 (XML) Short Name: OKSCODET_XML DB package: OKS_OKSCODET_XMLP_PKG BI Publisher :cp_csi :cp_lic_lvl :cp_num_of_users :cp_pricing_lic_lvl :cp_prod_name :cp_prod_qty :cp_prod_ref_no :cp_prod_serial_no :currency_code :id10 :p_conc_request_id :p_contract_group :p_contract_group_where :p_contract_id :p_contract_id_where :p_customer_id :p_customer_id_where :p_end_date_from :p_end_date_from_where :p_end_date_to :p_end_date_to_where :p_operating_unit :p_org :p_org_where :p_start_date_from :p_start_date_from_where :p_start_date_to :p_start_date_to_where :p_status_code :p_status_code_where :p_status_type :p_status_type_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_contract_id LOV Oracle OKS_QUOTE_K_NUMBER Y Y select id id, contract_number value, null description from okc_k_headers_b where okc_util.get_k_access_level(id,scs_code) in ('U','R') order by contract_number,contract_number_modifier AR رقم العقد D Vertragsnummer F Num. contrat US Contract # ZHS 合同编号 3 30 :p_customer_id LOV Oracle OKS_PARTY_ID Y Y select id1 id, name value, party_number description from okx_parties_v order by name,party_number AR العميل D Kunde F Client US Customer ZHS 客户 4 40 :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 状态类型 5 50 :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 状态代码 6 60 :p_start_date_from Date AR تاريخ البداية من D Von Startdatum F Date début - Du US Start Date From ZHS 起始日期自 7 70 :p_start_date_to Date AR تاريخ البداية إلى D Bis Startdatum F Date début - Au US Start Date To ZHS 起始日期至 8 80 :p_end_date_from Date AR تاريخ النهاية من D Von Enddatum F Date de fin - Du US End Date From ZHS 终止日期自 9 90 :p_end_date_to Date AR تاريخ النهاية إلى D Bis Enddatum F Date de fin - Au US End Date To ZHS 终止日期至 10 100 :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 业务实体