ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF603869E053B46B63588994 SELECT CV.INCIDENT_NUMBER, CV.INCIDENT_DATE, CV.PROBLEM_CODE, CV.RESOLUTION_CODE, CV.INCIDENT_TYPE, CV.SEVERITY, CV.STATUS_CODE, CV.URGENCY, CV.OWNER, CV.CUSTOMER_NUMBER, CV.COMPANY_NAME CUSTOMER_NAME, NVL(CV.CURRENT_SERIAL_NUMBER, CII.SERIAL_NUMBER) CURRENT_SERIAL_NUMBER, CV.REFERENCE_NUMBER, CV.PRODUCT_NAME, CV.SUMMARY FROM CS_SR_REPORT_V CV, MTL_SYSTEM_ITEMS_VL MSI, CSI_ITEM_INSTANCES cii WHERE CV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND CV.inventory_item_id = cii.inventory_item_id(+) AND cii.instance_id(+) = CV.customer_product_id AND MSI.organization_id(+) = to_number(fnd_profile.value_specific('SO_ORGANIZATION_ID')) &LP_CUSTOMER_NUMBER &LP_REQUEST_NUMBER &LP_CLOSEDDATE &LP_CLOSED_FLAG &LP_LOGGEDBY &LP_OWNER &LP_PROBLEM_CODE &LP_RESOLUTION_CODE &LP_SEVERITY &LP_STATUS &LP_TYPE &LP_URGENCY AND &P_ITEM_WHERE ORDER BY CV.CUSTOMER_NUMBER , CV.INCIDENT_NUMBER Y CS CSXSRSUM_XML AR CS تقرير إجمالي طلبات الخدمة (تنسيق XML) Application: الخدمة Source: تقرير إجمالي طلبات الخدمة (تنسيق XML) Short Name: CSXSRSUM_XML DB package: CS_CSXSRSUM_XMLP_PKG D CS Serviceanfragen - Übersicht Application: Service Source: Serviceanfragen - Übersicht (XML) Short Name: CSXSRSUM_XML DB package: CS_CSXSRSUM_XMLP_PKG F CS Etat Synthèse des demandes de service Application: Service Source: Etat Synthèse des demandes de service (XML) Short Name: CSXSRSUM_XML DB package: CS_CSXSRSUM_XMLP_PKG US CS Service Request Summary Application: Service Source: Service Request Summary Report (XML) Short Name: CSXSRSUM_XML DB package: CS_CSXSRSUM_XMLP_PKG ZHS CS 服务请求汇总报表 Application: 服务管理系统 Source: 服务请求汇总报表 (XML) Short Name: CSXSRSUM_XML DB package: CS_CSXSRSUM_XMLP_PKG BI Publisher &lp_closed_flag &lp_closeddate &lp_customer_number &lp_loggedby &lp_owner &lp_problem_code &lp_request_number &lp_resolution_code &lp_severity &lp_status &lp_type &lp_urgency &p_item_where :lp_active_workflow :lp_closed_flag :lp_closeddate :lp_customer_number :lp_install_location :lp_item_number :lp_loggedby :lp_owner :lp_problem_code :lp_request_number :lp_resolution_code :lp_return :lp_severity :lp_status :lp_type :lp_urgency :p_active_workflow :p_closed_date :p_closed_flag :p_conc_request_id :p_customer_num_high :p_customer_num_low :p_flex_item_code :p_install_location :p_item_high :p_item_low :p_item_struct_num :p_item_where :p_logged_by :p_organization :p_organization_id :p_owner :p_problem_code :p_request_high :p_request_low :p_resolution_code :p_return :p_severity :p_sob_id :p_status :p_type :p_urgency :rp_company_name :rp_report_name 1 10 :p_customer_num_low LOV Oracle CS_SRS_CUSTOMER_NUMBERS2 Y select party_number id, party_number value, party_name description from hz_parties order by party_number AR من رقم العميل D Von Kundennummer F Numéro de client - De US From Customer Number ZHS 客户起始编号 2 20 :p_customer_num_high LOV Oracle CS_SRS_CUSTOMER_NUMBERS2 Y select party_number id, party_number value, party_name description from hz_parties order by party_number AR إلى العميل رقم D Bis Kundennummer F Numéro de client - A US To Customer Number ZHS 终止客户编号 3 30 :p_item_low Char AR من الصنف D Von Artikel F Article - De US From Item ZHS 起始项 4 40 :p_item_high Char AR إلى الصنف D Bis Artikel F Article - A US To Item ZHS 终止项 5 50 :p_request_low LOV Oracle CS_SRS_INC_REQUEST_NUMBERS Y select incident_number id, incident_number value, null description from cs_sr_report_v order by incident_number AR من رقم الطلب D Von Anfragenummer F Numéro de la demande - De US From Request Number ZHS 请求起始编号 6 60 :p_request_high LOV Oracle CS_SRS_INC_REQUEST_NUMBERS Y select incident_number id, incident_number value, null description from cs_sr_report_v order by incident_number AR إلى الطلب رقم D Bis Anfragenummer F Numéro de la demande - A US To Request Number ZHS 请求终止编号 7 70 :p_type LOV Oracle CS_SRS_INC_TYPES Y select name id, name value, description description from cs_incident_types_vl where incident_subtype='INC' order by value,description AR النوع D Art US Type ZHS 类型 8 80 :p_severity LOV Oracle CS_SRS_INC_SEVERITY Y select name id, name value, description description from cs_incident_severities where incident_subtype='INC' order by value,description AR الخطورة D Bedeutung F Gravité US Severity ZHS 重要程度 9 90 :p_urgency LOV Oracle CS_SRS_INC_URGENCY Y select name id, name value, description description from cs_incident_urgencies order by value,description AR الضرورة D Dringlichkeit F Urgence US Urgency ZHS 紧急程度 10 100 :p_problem_code LOV Oracle CS_SRS_INC_PROBLEM_CODE Y select lookup_code id, lookup_code value, meaning description from cs_lookups where lookup_type='REQUEST_PROBLEM_CODE' order by value,description AR رمز المشكلة D Problemschlüssel F Code problème US Problem Code ZHS 问题代码 11 110 :p_resolution_code LOV Oracle CS_SRS_INC_RESOLUTION_CODE Y select lookup_code id, lookup_code value, meaning description from cs_lookups where lookup_type='REQUEST_RESOLUTION_CODE' order by value,description AR رمز الحل D Lösungsschlüssel F Code résolution US Resolution Code ZHS 解决方法代码 12 120 :p_status LOV Oracle CS_SRS_INC_STATUS Y select name id, name value, description description from cs_incident_statuses order by value,description AR الموقف F Statut US Status ZHS 状态 13 130 :p_owner LOV Oracle CS_SRS_INC_OWNERS Y select resource_name id, resource_name value, resource_number description from jtf_rs_resource_extns_vl order by resource_name AR المالك D Verantwortlicher F Responsable US Owner ZHS 责任人 14 140 :p_closed_date Date AR تاريخ الإغلاق D Geschlossen am F Date de fermeture US Closed Date ZHS 关闭日期 15 150 :p_logged_by LOV Oracle CS_SRS_INC_LOGGED_BY2 Y select user_name id, user_name value, null description from fnd_user order by user_name AR الدخول بواسطة D Protokoll von F Consigné par US Logged By ZHS 记录人 16 160 :p_closed_flag LOV Oracle CS_SRS_INC_CLOSED_FLAG Y select lookup_code id, lookup_code value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR علامة الإقفال D Erledigt F Indicateur Fermé US Closed Flag ZHS 关闭标志 17 170 :p_install_location LOV Oracle CS_SRS_INSTALL_LOCATION Y select location id, location value, null description from cs_ra_addr_loc_rg_v order by customer_number AR موقع التركيب D Installationsort F Lieu d'installation US Install Location ZHS 安装地点