ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F53B3869E053B46B63588994 SELECT WIV.service_provider service_provider, WRH.Error_type error_type, WRH.Error_code error_code, NVL(WIRR.Interpreted_value_code,'DATA') interpreted_value, Count(*) FROM WSH_ITM_VENDORS WIV, WSH_ITM_RESPONSE_RULES WIRR, WSH_ITM_RESPONSE_HEADERS WRH, WSH_ITM_REQUEST_CONTROL WRC WHERE WRH.VENDOR_ID = WIV.VENDOR_ID AND WRH.ERROR_TYPE = WIRR.ERROR_TYPE(+) AND WRH.ERROR_CODE = WIRR.ERROR_CODE(+) AND WRH.VENDOR_ID = WIRR.VENDOR_ID(+) AND WRC.RESPONSE_HEADER_ID = WRH.RESPONSE_HEADER_ID AND WRH.ERROR_TYPE IS NOT NULL AND WRH.ERROR_CODE IS NOT NULL AND WRC.PROCESS_FLAG <> 1 &lp_application_id &lp_appl_user_id &lp_master_org_id &lp_organization_id &lp_vendor_id GROUP BY WIV.service_provider, WRH.Error_type, WRH.Error_code, WIRR.Interpreted_value_code UNION SELECT WIV.service_provider service_provider, WRL.Error_type error_type, WRL.Error_code error_code, WIRR.Interpreted_value_code interpreted_value, Count(*) FROM WSH_ITM_VENDORS WIV, WSH_ITM_RESPONSE_RULES WIRR, WSH_ITM_RESPONSE_LINES WRL, WSH_ITM_REQUEST_CONTROL WRC WHERE WRL.RESPONSE_HEADER_ID = WRC.RESPONSE_HEADER_ID AND WRL.ERROR_TYPE = WIRR.ERROR_TYPE(+) AND WRL.ERROR_CODE = WIRR.ERROR_CODE(+) AND WRL.ERROR_CODE IS NOT NULL AND WRL.ERROR_TYPE IS NOT NULL AND WIRR.VENDOR_ID = WIV.VENDOR_ID &lp_application_id &lp_appl_user_id &lp_master_org_id &lp_organization_id &lp_vendor_id GROUP BY WIV.service_provider, WRL.Error_type, WRL.Error_code, WIRR.Interpreted_value_code Y WSH WSHRDIST_XML AR WSH تقرير موقف مكيف ITM (بتنسيق XML) Application: تنفيذ الشحن Source: تقرير موقف مكيف ITM (بتنسيق XML) Short Name: WSHRDIST_XML DB package: WSH_WSHRDIST_XMLP_PKG D WSH ITM-Adapter-Status Application: Shipping Execution Source: ITM-Adapter-Status (XML) Short Name: WSHRDIST_XML DB package: WSH_WSHRDIST_XMLP_PKG F WSH Etat Statut de l'adaptateur ITM Application: Shipping Execution Source: Etat Statut de l'adaptateur ITM (XML) Short Name: WSHRDIST_XML DB package: WSH_WSHRDIST_XMLP_PKG US WSH ITM Adapter Status Application: Shipping Execution Source: ITM Adapter Status Report (XML) Short Name: WSHRDIST_XML DB package: WSH_WSHRDIST_XMLP_PKG ZHS WSH ITM 适配器状态报表 Application: 发运管理系统 Source: ITM 适配器状态报表 (XML) Short Name: WSHRDIST_XML DB package: WSH_WSHRDIST_XMLP_PKG BI Publisher &lp_appl_user_id &lp_application_id &lp_master_org_id &lp_organization_id &lp_vendor_id :lp_appl_user_id :lp_application_id :lp_master_org_id :lp_organization_id :lp_vendor_id :p_appl_user_id :p_application_id :p_conc_request_id :p_master_org_id :p_organization_id :p_vendor_id 1 10 :p_application_id LOV Oracle WSH_ITM_APPLICATION Y select application_id id, application_name value, null description from fnd_application_vl where application_id in(660,665) order by application_name Y AR التطبيق D Anwendung US Application ZHS 应用产品 2 20 :p_master_org_id LOV Oracle WSH_ITM_MASTER_ORG Y select org.organization_id id, org.organization_name value, org.organization_id description from org_organization_definitions2 org,mtl_parameters mtl,mfg_lookups a where nvl(org.disable_date,sysdate+1)>sysdate and ((mtl.organization_id=mtl.master_organization_id)) and mtl.organization_id (+)=org.organization_id and a.lookup_code=nvl(mtl.primary_cost_method,1) and a.lookup_type='MTL_PRIMARY_COST' order by org.organization_name AR التنظيم الرئيسي D Hauptorganisation F Organisation principale US Master Organization ZHS 主组织 3 30 :p_organization_id LOV Oracle WSH_ITM_ORG Y select org.organization_id id, org.organization_name value, org.organization_id description from org_organization_definitions org,mtl_parameters mtl where nvl(org.disable_date,sysdate+1)>sysdate and (mtl.master_organization_id=:$flex$.wsh_itm_master_org) and mtl.organization_id (+)=org.organization_id and org.organization_id!=:$flex$.wsh_itm_master_org order by org.organization_name AR التنظيم D Organisation F Organisation US Organization ZHS 组织 4 40 :p_appl_user_id LOV Oracle WSH_ITM_USERS Y select user_id id, user_name value, null description from fnd_user order by user_name AR مستخدم التطبيق D Anwendungsbenutzer F Utilisateur application US Application User ZHS 应用产品用户 5 50 :p_vendor_id LOV Oracle WSH_ITM_VENDORS Y select vendor_id id, service_provider value, null description from wsh_itm_vendors order by service_provider AR المورد D Lieferant F Fournisseur US Vendor ZHS 供应商 :$flex$.wsh_itm_master_org Master Organization Organization