ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D472BF51A9E05362FB09050512Y SELECT SUBSTRB(PARTY.PARTY_NAME,1,50) AS CUSTOMER_NAME, CUST_ACCT.ACCOUNT_NUMBER AS CUSTOMER_NUMBER, WDD.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID, WSH_UTIL_CORE.GET_ITEM_NAME(WDD.INVENTORY_ITEM_ID,:P_ORGANIZATION_ID,:P_ITEM_FLEX_CODE,:LP_STRUCTURE_NUM) as ITEM_SEG, WDL.PICK_UP_STOP_ID AS STOP_ID, WDD.SHIPPED_QUANTITY AS SHIPPED_QUANTITY, NVL(FLV_WT.MEANING, FLV_WDD.MEANING) AS SHIP_METHOD, WND.WAYBILL AS WAYBILL, WDD.SOURCE_HEADER_NUMBER AS ORDER_NUMBER, TO_CHAR(WDD.DATE_SCHEDULED,'DD-MON-RRRR') AS SCHEDULED_SHIP_DATE, WND.NAME AS DELIVERY, WDD.DELIVERY_DETAIL_ID AS DELIVERY_LINE, WDD.ORGANIZATION_ID AS SHIP_FROM_ORGANIZATION, WDD.SOURCE_LINE_NUMBER AS ORDER_LINE , WDD.SOURCE_HEADER_ID AS SOURCE_HEADER_ID, WSH_WSHRDSDL_XMLP_PKG.cf_ship_from_organization_name(WDD.ORGANIZATION_ID) CF_SHIP_FROM_ORGANIZATION_NAME, WSH_WSHRDSDL_XMLP_PKG.cf_released_quantityformula(WDD.DELIVERY_DETAIL_ID, WDD.SOURCE_HEADER_ID) CF_RELEASED_QUANTITY, WSH_WSHRDSDL_XMLP_PKG.cf_ship_dateformula(WDL.PICK_UP_STOP_ID) CF_SHIP_DATE, WSH_WSHRDSDL_XMLP_PKG.cf_item_displayformula(WDD.INVENTORY_ITEM_ID, WDD.ORGANIZATION_ID) CF_ITEM_DISPLAY FROM HZ_PARTIES PARTY, (select CUST_ACCOUNT_ID, 'C' CUST_TYPE, PARTY_ID, ACCOUNT_NUMBER from HZ_CUST_ACCOUNTS UNION select VENDOR_ID CUST_ACCOUNT_ID, 'V' CUST_TYPE, PARTY_ID, SEGMENT1 ACCOUNT_NUMBER from PO_VENDORS) CUST_ACCT, &LP_TABLE_NAME, WSH_TRIPS WT, WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS_V WDA, WSH_DELIVERY_LEGS WDL, WSH_NEW_DELIVERIES WND, ORG_ORGANIZATION_DEFINITIONS OOD, FND_LOOKUP_VALUES_VL FLV_WT, FND_LOOKUP_VALUES_VL FLV_WDD WHERE WDD.ORGANIZATION_ID = OOD.ORGANIZATION_ID AND OOD.OPERATING_UNIT = :P_ORGANIZATION_ID AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID AND WDA.DELIVERY_ID = WND.DELIVERY_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND nvl(wnd.shipment_direction, 'O') IN ('O', 'IO') AND WND.DELIVERY_TYPE = 'STANDARD' &LP_WHERE_CLAUSE AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID AND WDD.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID AND NVL(WDD.CONSIGNEE_FLAG,'C') = CUST_ACCT.CUST_TYPE AND WDA.DELIVERY_ID IS NOT NULL AND WDD.RELEASED_STATUS IN ( 'C','I') AND WDD.CONTAINER_FLAG = 'N' AND WDD.SOURCE_CODE = :P_SOURCE_SYSTEM AND FLV_WT.LOOKUP_TYPE (+) = 'SHIP_METHOD' AND FLV_WT.LOOKUP_CODE (+) = WT.SHIP_METHOD_CODE AND FLV_WDD.LOOKUP_TYPE (+) = 'SHIP_METHOD' AND FLV_WDD.LOOKUP_CODE (+) = WDD.SHIP_METHOD_CODE &LP_CUSTOMER_NAME &LP_DELIVERY &LP_ORDER_NUMBER &LP_SHIP_DATE &LP_SHIP_FROM_ORG_ID &LP_SHIP_METHOD &LP_ITEM &LP_ORDER_TYPE ORDER BY &LP_ORDER_BY WSH WSHRDSDL_XML AR WSH تقرير سطور تسليم الشحنة (بتنسيق XML) Imported from BI Publisher Description: تقرير سطور تسليم الشحنة Application: تنفيذ الشحن Source: تقرير سطور تسليم الشحنة (بتنسيق XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG D WSH Gelieferte Auslieferungspositionen Imported from BI Publisher Description: Auswertung "Gelieferte Auslieferpositionen" Application: Shipping Execution Source: Gelieferte Auslieferungspositionen (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG E WSH Informe Líneas de Entregas Enviadas Imported from BI Publisher Description: Líneas de Entregas Enviadas Application: Shipping Execution Source: Informe Líneas de Entregas Enviadas (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG F WSH Etat Lignes de livraison expédiées Imported from BI Publisher Description: Etat Lignes de livraison expédiées Application: Shipping Execution Source: Etat Lignes de livraison expédiées (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG I WSH Rapporto Linee consegna spedite Imported from BI Publisher Description: Rapporto Linee consegna spedite Application: Shipping Execution Source: Rapporto Linee consegna spedite (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG JA WSH 出荷搬送明細レポート Imported from BI Publisher Description: 出荷搬送明細レポート Application: Shipping Execution Source: 出荷搬送明細レポート(XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG KO WSH 출하 납품 라인 보고서 Imported from BI Publisher Description: 출하 납품 라인 보고서 Application: Shipping Execution Source: 출하 납품 라인 보고서(XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG PTB WSH Relatório das Linhas de Distribuição Entregues Imported from BI Publisher Description: Relatório das Linhas de Distribuição Entregues Application: Execução da Entrega Source: Relatório das Linhas de Distribuição Entregues (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG RU WSH Отчет об отгруженных строках доставки Imported from BI Publisher Description: Отчет об отгруженных строках доставки Application: Выполнение отгрузки Source: Отчет об отгруженных строках доставки (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG S WSH Levererade leveransrader - rapport Imported from BI Publisher Description: Levererade leveransrader - rapport Application: Shipping Execution Source: Levererade leveransrader - rapport (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG TR WSH Sevkedilen Teslimat Hatları Raporu Imported from BI Publisher Description: Sevkedilen Teslimat Hatları Raporu Application: Sevkiyat Yönetimi Source: Sevkedilen Teslimat Hatları Raporu (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG US WSH Shipped Delivery Lines Imported from BI Publisher Description: Shipped Delivery Lines Report Application: Shipping Execution Source: Shipped Delivery Lines Report (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG ZHS WSH 已发运交货行报表 Imported from BI Publisher Description: 已发运交货行报表 Application: 发运管理系统 Source: 已发运交货行报表 (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG BI Publisher &lp_customer_name &lp_delivery &lp_item &lp_order_by &lp_order_number &lp_order_type &lp_ship_date &lp_ship_from_org_id &lp_ship_method &lp_table_name &lp_where_clause :lp_customer_name :lp_delivery :lp_item :lp_item_select :lp_order_by :lp_order_number :lp_order_type :lp_ship_date :lp_ship_from_org_id :lp_ship_method :lp_structure_num :lp_table_name :lp_where_clause :operating_unit :p_conc_request_id :p_consignee_type :p_customer_name_high :p_customer_name_low :p_delivery_high :p_delivery_low :p_item :p_item_display :p_item_flex_code :p_order_by_1 :p_order_by_2 :p_order_by_3 :p_order_number_high :p_order_number_low :p_order_type :p_organization_id :p_ship_date_high :p_ship_date_low :p_ship_from_org_id :p_ship_method :p_source_system :report_customer_from :report_customer_to :report_delivery_from :report_delivery_to :report_item :report_item_display :report_name :report_order_number_from :report_order_number_to :report_order_type :report_ship_date_from :report_ship_date_to :report_ship_from :report_ship_method :report_sort_by_1 :report_sort_by_2 :report_sort_by_3 1 -20 :p_organization_id Char SELECT MO_GLOBAL.GET_CURRENT_ORG_ID FROM DUAL Y AR P_ORGANIZATION_ID وحدة التشغيل D P_ORGANIZATION_ID Betriebseinheit E P_ORGANIZATION_ID Unidad Operativa F P_ORGANIZATION_ID Unité opérationnelle I P_ORGANIZATION_ID Unità operativa JA P_ORGANIZATION_ID 営業単位 KO P_ORGANIZATION_ID 운영 단위 PTB P_ORGANIZATION_ID Unidade Operacional RU P_ORGANIZATION_ID Операционная единица S P_ORGANIZATION_ID Operativ enhet TR P_ORGANIZATION_ID Faaliyet Birimi US P_ORGANIZATION_ID Operating Unit ZHS P_ORGANIZATION_ID 业务实体 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_ship_from_org_id LOV Oracle WSH_SRS_OU_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where operating_unit=mo_global.get_current_org_id order by value,description AR شحن من التنظيم شحن من التنظيم D Versandorganisation Versandorganisation E Organización de Origen de Envío Organización de Origen de Envío F Organisation d'expédition Organisation d'expédition I Org. di spedizione Org. di spedizione JA 出荷元組織 出荷元組織 KO 출고처 조직 출고처 조직 PTB Organização de Entrega Organização de Entrega RU Организация отправителя товара Организация отправителя товара S Avsändaradress - organisation Avsändaradress - organisation TR Sevk Çıkış Organizasyonu Sevk Çıkış Organizasyonu US Ship From Organization Ship From Organization ZHS 发货组织 发货组织 4 20 :p_source_system LOV Oracle WSH_SRS_SOURCE_SYSTEM Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='SOURCE_SYSTEM' and enabled_flag='Y' and lookup_code not in ('PO','OSP') order by meaning Y AR النظام المصدر النظام المصدر D Herkunftssystem Herkunftssystem E Sistema de Origen Sistema de Origen F Système d'origine Système d'origine I Sistema di origine Sistema di origine JA ソース・システム ソース・システム KO 출처 시스템 출처 시스템 PTB Sistema de Origem Sistema de Origem RU Исходная система Исходная система S Källsystem Källsystem TR Kaynak Sistem Kaynak Sistem US Source System Source System ZHS 源系统 源系统 5 30 :p_order_type LOV Oracle WSH_SOURCE_TYPES Y select source_type_id id, source_type_name value, description description from wsh_source_types_v where source_system=:$flex$.wsh_srs_source_system order by value,description AR نوع المصدر نوع المصدر D Herkunftsart Herkunftsart E Tipo de Origen Tipo de Origen F Type d'origine Type d'origine I Tipo di origine Tipo di origine JA ソース・タイプ ソース・タイプ KO 출처 유형 출처 유형 PTB Tipo de Origem Tipo de Origem RU Тип источника Тип источника S Källtyp Källtyp TR Kaynak Tipi Kaynak Tipi US Source Type Source Type ZHS 来源类型 来源类型 6 40 :p_order_number_low LOV Oracle WSH_SOURCE_NUMBERS Y select source_number id, source_number value, null description from wsh_source_numbers_v where source_system=:$flex$.wsh_srs_source_system and source_type_id=:$flex$.wsh_source_types order by value,description AR رقم المصدر من رقم المصدر من D Von Herkunftsnummer Von Herkunftsnummer E De Número de Origen De Número de Origen F Numéro d'origine (De) Numéro d'origine (De) I Numero origine - Da Numero origine - Da JA ソース番号:自 ソース番号:自 KO 출처 번호: 부터 출처 번호: 부터 PTB Número de Origem - De Número de Origem - De RU Номер источника с Номер источника с S Källnummer från Källnummer från TR İlk Kaynak Başlığı İlk Kaynak Başlığı US Source Number From Source Number From ZHS 来源编号自 来源编号自 7 50 :p_order_number_high LOV Oracle WSH_SOURCE_NUMBERS Y select source_number id, source_number value, null description from wsh_source_numbers_v where source_system=:$flex$.wsh_srs_source_system and source_type_id=:$flex$.wsh_source_types order by value,description AR رقم المصدر إلى رقم المصدر إلى D Bis Herkunftsnummer Bis Herkunftsnummer E A Número de Origen A Número de Origen F Numéro d'origine (A) Numéro d'origine (A) I Numero origine - A Numero origine - A JA ソース番号:至 ソース番号:至 KO 출처 번호: 까지 출처 번호: 까지 PTB Número de Origem - Até Número de Origem - Até RU Номер источника по Номер источника по S Källnummer till Källnummer till TR Son Kaynak Başlığı Son Kaynak Başlığı US Source Number To Source Number To ZHS 来源编号至 来源编号至 8 60 :p_delivery_low LOV Oracle WSH_SRS_OU_DELIVERIES Y select name id, name value, null description from wsh_new_deliveries where organization_id=:$flex$.wsh_srs_ou_organizations and nvl(shipment_direction,'O') in ('O','IO') and status_code in ('CO','CL','IT') and delivery_type='STANDARD' order by value,description AR التسليم من التسليم من D Von Auslieferung Von Auslieferung E De Entrega De Entrega F Livraison - De Livraison - De I Consegna - Da Consegna - Da JA 搬送元 搬送元 KO 납품: 부터 납품: 부터 PTB Distribuição - De Distribuição - De RU Доставка с Доставка с S Leverans från Leverans från TR Teslim Eden Teslim Eden US Delivery From Delivery From ZHS 交货自 交货自 9 70 :p_delivery_high LOV Oracle WSH_SRS_OU_DELIVERIES Y select name id, name value, null description from wsh_new_deliveries where organization_id=:$flex$.wsh_srs_ou_organizations and nvl(shipment_direction,'O') in ('O','IO') and status_code in ('CO','CL','IT') and delivery_type='STANDARD' order by value,description AR التسليم إلى التسليم إلى D Bis Auslieferung Bis Auslieferung E A Entrega A Entrega F Livraison - A Livraison - A I Consegna - A Consegna - A JA 搬送先 搬送先 KO 수령처 수령처 PTB Distribuição - Até Distribuição - Até RU Доставка по Доставка по S Mottagningsplats Mottagningsplats TR Son Teslimat Son Teslimat US Delivery To Delivery To ZHS 交货至 交货至 10 80 :p_item Char AR الصنف الصنف D Artikel Artikel E Artículo Artículo F Article Article I Articolo Articolo JA 品目 品目 KO 품목 품목 RU Позиция Позиция S Artikel Artikel TR Kalem Kalem US Item Item ZHS 物品 物品 11 90 :p_item_display LOV Oracle WSH_MGD_ITEM_DISPLAY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='ITEM_DISPLAY' and enabled_flag='Y' order by meaning Y AR عرض الصنف عرض الصنف D Artikelanzeige Artikelanzeige E Presentación del Artículo Presentación del Artículo F Affichage article Affichage article I Visualizzazione articolo Visualizzazione articolo JA 品目表示 品目表示 KO 품목 표시 품목 표시 PTB Exibição do Item Exibição do Item RU Вывод позиции Вывод позиции S Artikelvisning Artikelvisning TR Kalem Görüntüleme Kalem Görüntüleme US Item Display Item Display ZHS 物料显示 物料显示 12 100 :p_customer_name_low LOV Oracle WSH_SD_CONSIGNEES Y Y select customer_id id, party_name value, customer_number description from wsh_consignees_v where type_flag=decode(:$flex$.wsh_srs_source_system,'OE','C','OKE','C','WSH','C','RTV',decode(nvl(:$flex$.wsh_consignee_type:null,'V'),'I','I','V','V','V'),'V') order by value,description AR عميل من عميل من D Von Kunde Von Kunde E De Cliente De Cliente F Client - De Client - De I Cliente - Da Cliente - Da JA 顧客:自 顧客:自 KO 고객 From 고객 From PTB Cliente - De Cliente - De RU Заказчик с Заказчик с S Från kund Från kund TR İlk Müşteri İlk Müşteri US Customer From Customer From ZHS 客户自 客户自 13 110 :p_customer_name_high LOV Oracle WSH_SD_CONSIGNEES Y Y select customer_id id, party_name value, customer_number description from wsh_consignees_v where type_flag=decode(:$flex$.wsh_srs_source_system,'OE','C','OKE','C','WSH','C','RTV',decode(nvl(:$flex$.wsh_consignee_type:null,'V'),'I','I','V','V','V'),'V') order by value,description AR عميل إلى عميل إلى D Bis Kunde Bis Kunde E A Cliente A Cliente F Client - A Client - A I Cliente - A Cliente - A JA 顧客:至 顧客:至 KO 고객 To 고객 To PTB Cliente - Até Cliente - Até RU Заказчик по Заказчик по S Till kund Till kund TR Son Müşteri Son Müşteri US Customer To Customer To ZHS 客户至 客户至 14 120 :p_ship_date_low DateTime AR تاريخ الشحن من تاريخ الشحن من D Von Lieferdatum Von Lieferdatum E De Fecha de Envío De Fecha de Envío F Date d'expédition - Du Date d'expédition - Du I Data spedizione - Da Data spedizione - Da JA 出荷日:自 出荷日:自 KO 출하 일자: 부터 출하 일자: 부터 PTB Data da Entrega - De Data da Entrega - De RU Дата отгрузки с Дата отгрузки с S Från leveransdatum Från leveransdatum TR Sevk Başlangıç Tarihi Sevk Başlangıç Tarihi US Ship Date From Ship Date From ZHS 发运起始日期 发运起始日期 15 130 :p_ship_date_high DateTime AR تاريخ الشحن إلى تاريخ الشحن إلى D Bis Lieferdatum Bis Lieferdatum E A Fecha de Envío A Fecha de Envío F Date d'expédition - Au Date d'expédition - Au I Data spedizione - A Data spedizione - A JA 出荷日:至 出荷日:至 KO 출하 일자: 까지 출하 일자: 까지 PTB Data da Entrega - Até Data da Entrega - Até RU Дата отгрузки по Дата отгрузки по S Leveransdatum till Leveransdatum till TR Sevk Bitiş Tarihi Sevk Bitiş Tarihi US Ship Date To Ship Date To ZHS 发运终止日期 发运终止日期 16 140 :p_ship_method LOV Oracle WSH_SRS_FREIGHT_CARRIER Y Y select lookup_code id, meaning value, description description from fnd_lookup_values_vl where view_application_id=3 and lookup_type='SHIP_METHOD' and exists (select 1 from wsh_carrier_services wcs,wsh_carriers wc where wcs.ship_method_code=lookup_code and wcs.carrier_id=wc.carrier_id and nvl(wc.generic_flag,'N')='N') order by lookup_code AR طريقة الشحن طريقة الشحن D Versandart Versandart E Método de Envío Método de Envío F Mode d'expédition Mode d'expédition I Metodo di spedizione Metodo di spedizione JA 出荷方法 出荷方法 KO 운송 방법 운송 방법 PTB Mét. de Entrega Mét. de Entrega RU Метод отгрузки Метод отгрузки S Leveransmetod Leveransmetod TR Sevk Yöntemi Sevk Yöntemi US Ship Method Ship Method ZHS 发运方法 发运方法 17 150 :p_order_by_1 LOV Oracle WSH_ORDER_BY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='WSH_ORDER_BY' and enabled_flag='Y' order by meaning Y AR فرز بواسطة 1 فرز بواسطة 1 D Sortieren nach 1 Sortieren nach 1 E Ordenar por 1 Ordenar por 1 F Tri par 1 Tri par 1 I Ordina per 1 Ordina per 1 JA ソート・キー 1 ソート・キー 1 KO 정렬 기준 1 정렬 기준 1 PTB Classificar por 1 Classificar por 1 RU Сортировка по 1 Сортировка по 1 S Sortera efter 1 Sortera efter 1 TR Sıralama Bazı 1 Sıralama Bazı 1 US Sort By 1 Sort By 1 ZHS 排序依据 1 排序依据 1 18 160 :p_order_by_2 LOV Oracle WSH_ORDER_BY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='WSH_ORDER_BY' and enabled_flag='Y' order by meaning Y AR فرز بواسطة 2 فرز بواسطة 2 D Sortieren nach 2 Sortieren nach 2 E Ordenar por 2 Ordenar por 2 F Tri par 2 Tri par 2 I Ordina per 2 Ordina per 2 JA ソート・キー 2 ソート・キー 2 KO 정렬 기준 2 정렬 기준 2 PTB Classificar por 2 Classificar por 2 RU Сортировка по 2 Сортировка по 2 S Sortera efter 2 Sortera efter 2 TR Sıralama Bazı 2 Sıralama bazı 2 US Sort By 2 Sort by 2 ZHS 排序依据 2 排序依据 2 19 170 :p_order_by_3 LOV Oracle WSH_ORDER_BY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='WSH_ORDER_BY' and enabled_flag='Y' order by meaning Y AR فرز بواسطة 3 فرز بواسطة 3 D Sortieren nach 3 Sortieren nach 3 E Ordenar por 3 Ordenar por 3 F Tri par 3 Tri par 3 I Ordina per 3 Ordina per 3 JA ソート・キー 3 ソート・キー 3 KO 정렬 기준 3 정렬 기준 3 PTB Classificar por 3 Classificar por 3 RU Сортировка по 3 Сортировка по 3 S Sortera efter 3 Sortera efter 3 TR Sıralama Bazı 3 Sıralama Bazı 3 US Sort By 3 Sort By 3 ZHS 排序依据 3 排序依据 3