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）限制的操作单元。 C6E085D470FA51A9E05362FB09050512Y SELECT distinct h.transactional_curr_code Currency, decode (:p_use_functional_currency,'N',h.transactional_curr_code , :rp_functional_currency) Use_Currency , decode (substr(upper(:p_order_by),1,1), 'S',sr.name,NULL) Sales_Person, decode (substr(upper(:p_order_by),1,1), 'O',ot.name,NULL) Order_Type, decode (substr(upper(:p_order_by),1,1), 'C',acct.cust_account_id,NULL) Trx_id1, decode (substr(upper(:p_order_by),1,1), 'C',party.party_name,NULL) Customer_Name1, decode (substr(upper(:p_order_by),1,1), 'C',NULL, acct.cust_account_id) Trx_id2, decode (substr(upper(:p_order_by),1,1), 'C',NULL, party.party_name) Customer_Name2, h.order_number Order_Number, h.ordered_date Order_Date, party.party_name Customer_Name3, h.header_id Header_Id, ot.name Order_Type1, h.conversion_rate Conversion_Rate, h.salesrep_id header_salesrep_id, sr.name header_salesrep_name, h.ship_to_org_id header_ship_country_id, terr.territory_short_name header_ship_country_name, ONT_OEXOEIOD_XMLP_PKG.C_LINE_COUNTFORMULA(h.header_id ) C_LINE_COUNT, ONT_OEXOEIOD_XMLP_PKG.C_CURRENCYFormula(:Currency1) c_Currency, ONT_OEXOEIOD_XMLP_PKG.C_DATA_NOT_FOUNDFORMULA(:Currency1) FROM oe_order_headers h, oe_order_lines_all l, oe_transaction_types_tl ot, hz_cust_site_uses_all site, hz_cust_acct_sites_all acct_site, hz_party_sites party_site, hz_locations loc, ra_salesreps_all sr, fnd_territories_vl terr, hz_parties party, hz_cust_accounts acct WHERE h.sold_to_org_id = acct.cust_account_id AND party.party_id = acct.party_id AND h.header_id=l.header_id AND l.invoice_interface_status_code = 'YES' AND nvl(h.org_id,0) = nvl(:lp_org_id,0) AND ot.transaction_type_id = h.order_type_id AND ot.language = userenv('LANG') AND h.salesrep_id = sr.salesrep_id (+) AND nvl(sr.org_id(+),0) = nvl(:lp_org_id,0) AND h.ship_to_org_id = site.site_use_id AND site.cust_acct_site_id = acct_site.cust_acct_site_id AND acct_site.party_site_id = party_site.party_site_id AND party_site.location_id = loc.location_id AND loc.country = terr.territory_code &lp_order_num &lp_salesrep &lp_order_type &lp_country &lp_customer_name &lp_open_orders_only &lp_order_category &lp_line_category ORDER BY 1 ASC,3 ASC, 4 ASC,6 ASC,5 ASC,8 ASC,7 ASC ,1 ,decode(substr(upper(:p_order_by),1,1), 'S', sr.name ,'O', ot.name, party.party_name), decode(substr(upper(:p_order_by),1,1), 'S', party.party_name ,'O', party.party_name), h.order_number ONT OEXOEIOD_XML AR ONT تقرير تفاصيل الفاتورة/الطلب Imported from BI Publisher Description: تقرير تفاصيل الفاتورة/الطلب Application: إدارة الطلبات Source: تقرير تفاصيل الفاتورة/الطلب (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG D ONT Rechnungen/Aufträge - Details Imported from BI Publisher Description: Rechnungen/Aufträge - Details Application: Order Management Source: Rechnungen/Aufträge - Details (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG E ONT Informe Detalles de Pedidos/Facturas Imported from BI Publisher Description: Informe Detalles de Pedidos/Facturas Application: Order Management Source: Informe Detalles de Pedidos/Facturas (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG F ONT Etat Détail commande/facture Imported from BI Publisher Description: Etat Détail commande/facture Application: Order Management Source: Etat Détail commande/facture (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG I ONT Rapporto Dettagli ordine/fattura Imported from BI Publisher Description: Rapporto Dettagli ordine/fattura Application: Order Management Source: Rapporto Dettagli ordine/fattura (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG JA ONT 受注/請求書詳細レポート Imported from BI Publisher Description: 受注/請求書詳細レポート Application: Order Management Source: 受注/請求書詳細レポート(XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG KO ONT 주문/송장 상세 보고서 Imported from BI Publisher Description: 주문/송장 상세내역 보고서 Application: Order Management Source: 주문/송장 상세 보고서(XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG PTB ONT Relatório Detalhado da Ordem/NFF Imported from BI Publisher Description: Relatório Detalhado da Ordem/NFF Application: Gerenciamento de Ordens Source: Relatório Detalhado da Ordem/NFF (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG RU ONT Подробный отчет о заказах/счетах-фактурах Imported from BI Publisher Description: Подробный отчет о заказах/счетах-фактурах Application: Управление заказами Source: Подробный отчет о заказах/счетах-фактурах (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG S ONT Order/faktura - detaljrapport Imported from BI Publisher Description: Order/faktura - detaljrapport Application: Order Management Source: Order/faktura - detaljrapport (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG TR ONT Sipariş/Fatura Detay Raporu Imported from BI Publisher Description: Sipariş/Fatura Detay Raporu Application: Sipariş Yönetimi(1) Source: Sipariş/Fatura Detay Raporu (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG US ONT Order/Invoice Detail Imported from BI Publisher Description: Order/Invoice Detail Report Application: Order Management Source: Order/Invoice Detail Report (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG ZHS ONT 订单/发票明细报表 Imported from BI Publisher Description: 订单/发票明细报表 Application: 订单管理 Source: 订单/发票明细报表 (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG BI Publisher &lp_country &lp_customer_name &lp_line_category &lp_open_orders_only &lp_order_category &lp_order_num &lp_order_type &lp_salesrep :c_amount :c_svc_amount :currency1 :dsp_count :l_order_type_high :l_order_type_low :lp_country :lp_customer_name :lp_line_category :lp_open_orders_only :lp_order_category :lp_order_num :lp_order_type :lp_org_id :lp_salesrep :operating_unit :p_conc_request_id :p_country_low :p_customer_name_high :p_customer_name_low :p_dummy_print_description :p_invoice_line_context :p_item_flex_code :p_item_structure_num :p_line_category :p_open_orders_only :p_order_by :p_order_category :p_order_num_high :p_order_num_low :p_order_type_high :p_order_type_low :p_org_id :p_print_description :p_salesrep_high :p_salesrep_low :p_sob_id :p_use_functional_currency :rp_company_name :rp_customer_name_range :rp_data_found :rp_dummy_item :rp_functional_currency :rp_item_flex_all_seg :rp_open_orders_only :rp_order_number_range :rp_order_type_range :rp_print_description :rp_report_name :rp_salesrep_range :rp_sub_title :rp_svc_dummy_item 1 -40 :p_sob_id Number select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) from dual Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 -30 :p_item_flex_code Char fnd_profile.value('OE_ID_FLEX_CODE') Y AR رمز الصنف المرن الرمز المرن للصنف D Artikel-FlexFeld-Schlüssel Artikel-FlexFeld-Schlüssel E Código de Estructura de Artículo Código de Estructura de Artículo F Code clé article Code clé article I Codice flexfield Articolo Codice flexfield Articolo JA 品目フレックス・コード 品目フレックス・コード KO 품목 가변 코드 품목 가변 코드 PTB Código Flex. do Item Código Flex. do Item RU Код ГП позиции Код ГП позиции S Artikelflexkod Artikelflexkod TR Kalem Esnek Kodu Kalem esnek kodu US Item Flex Code Item Flex code ZHS 项目弹性域代码 项目弹性域代码 3 -20 :p_invoice_line_context Char fnd_profile.value('ONT_SOURCE_CODE') Y AR سياق سطر الفاتورة سياق سطر الفاتورة D Kontext Rechnungsposition Kontext Rechnungsposition E Contexto de Línea de Factura Contexto de Línea de Factura F Contexte ligne de facture Contexte ligne de facture I Contesto linea fattura Contesto linea fattura JA 請求書明細コンテキスト 請求書明細コンテキスト KO 송장 라인 컨텍스트 송장 라인 컨텍스트 PTB Contexto da Linha da NFF Contexto da Linha da NFF RU Контекст строки счета-фактуры Контекст строки счета-фактуры S Sammanhang för fakturarad Sammanhang för fakturarad TR Fatura Satır İçeriği Fatura Satır İçeriği US Invoice Line Context Invoice Line Context ZHS 发票行上下文 发票行上下文 4 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 5 10 :p_order_by LOV Oracle ONT_SRS_OEXOEIOD_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXOEIOD ORDER BY' order by meaning select meaning from oe_lookups where lookup_type = 'OEXOEIOD ORDER BY' and lookup_code = 'CUSTOMER' Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Ölçütü Sıralama Ölçütü US Sort By Sort By ZHS 排序依据 排序依据 6 20 :p_open_orders_only LOV Oracle OM: Yes or No 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='YES_NO' AND LOOKUP_CODE='Y' Y AR الطلبات المفتوحة فقط الطلبات المفتوحة فقط D Nur offene Aufträge Nur offene Aufträge E Sólo Pedidos Abiertos Sólo Pedidos Abiertos F Commandes en cours uniquement Commandes en cours uniquement I Solo ordini aperti Solo ordini aperti JA オープン受注のみ オープン受注のみ KO 개설 주문만 개설 주문만 PTB Somente Ordens em Aberto Somente Ordens em Aberto RU Только открытые заказы Только открытые заказы S Endast uteliggande order Endast uteliggande order TR Sadece Açık Siparişler Sadece Açık Siparişler US Open Orders Only Open Orders Only ZHS 仅限于未完成订单 仅限于未完成订单 7 30 :p_print_description LOV Oracle ONT_SRS_ITEM_DISPLAY_CODE Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='ITEM_DISPLAY_CODE' order by value,description select meaning from oe_lookups where lookup_type = 'ITEM_DISPLAY_CODE' and lookup_code = 'D' Y AR عرض الصنف عرض الصنف D Artikelanzeige Artikelanzeige E Presentación de Artículo Presentación de 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 项目显示 项目显示 8 40 :p_customer_name_low LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name AR اسم العميل (من) اسم العميل (من) D Von Kunde Von Kunde E Nombre del Cliente (De) Nombre del Cliente (De) F Nom client (De) Nom client (De) I Nome cliente - Da Nome cliente - Da JA 顧客名 (自) 顧客名 (自) KO 고객명(부터) 고객명(부터) PTB Nome do Cliente (De) Nome do Cliente (De) RU Имя заказчика с Имя заказчика с S Kundnamn (från) Kundnamn (från) TR Müşteri Adı (İlk) Müşteri Adı (İlk) US Customer Name (From) Customer Name (From) ZHS 客户名称（自） 客户名称（自） 9 50 :p_customer_name_high LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name select :$flex$.customer_name_from from sys.dual AR اسم العميل (إلى) اسم العميل (إلى) D Bis Kunde Bis Kunde E Nombre del Cliente (A) Nombre del Cliente (A) F Nom client (A) Nom client (A) I Nome cliente - A Nome cliente - A JA 顧客名 (至) 顧客名 (至) KO 고객명(까지) 고객명(까지) PTB Nome do Cliente (Até) Nome do Cliente (Até) RU Имя заказчика по Имя заказчика по S Kundnamn (till) Kundnamn (till) TR Müşteri Adı (Son) Müşteri Adı (Son) US Customer Name (To) Customer Name (To) ZHS 客户名称（至） 客户名称（至） 10 60 :p_salesrep_low LOV Oracle ONT_MOAC_SRS_SALESREPS Y select rs.name id, rs.name value, null description from ra_salesreps rs,hr_operating_units ou where rs.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=rs.org_id) order by rs.name AR مندوب المبيعات (من) مندوب المبيعات (من) D Von Vertriebsmitarbeiter Von Vertriebsmitarbeiter E Vendedor (De) Vendedor (De) F Vendeur (De) Vendeur (De) I Rappresentante commerciale - Da Rappresentante commerciale - Da JA 営業担当 (自) 営業担当 (自) KO 영업사원(부터) 영업사원(부터) PTB Vendedor (De) Vendedor (De) RU Продавец с Продавец с S Säljare (från) Säljare (från) TR Satış Elemanı (İlk) Satış Elemanı (İlk) US Salesperson (From) Salesperson (From) ZHS 销售人员（自） 销售人员（自） 11 70 :p_salesrep_high LOV Oracle ONT_MOAC_SRS_SALESREPS Y select rs.name id, rs.name value, null description from ra_salesreps rs,hr_operating_units ou where rs.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=rs.org_id) order by rs.name AR مندوب مبيعات (إلى) مندوب مبيعات (إلى) D Bis Vertriebsmitarbeiter Bis Vertriebsmitarbeiter E Vendedor (A) Vendedor (A) F Vendeur (A) Vendeur (A) I Rappresentante commerciale - A Rappresentante commerciale - A JA 営業担当 (至) 営業担当 (至) KO 영업사원(까지) 영업사원(까지) PTB Vendedor (Até) Vendedor (Até) RU Продавец по Продавец по S Säljare (till) Säljare (till) TR Satış Elemanı (Son) Satış Elemanı (Son) US Salesperson (To) Salesperson (To) ZHS 销售人员（至） 销售人员（至） 12 80 :p_order_type_low LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y select ot.order_type_id id, ot.name value, null description from oe_order_types_v ot,hr_operating_units ou where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name AR نوع الطلب (من) نوع الطلب (من) D Von Auftragsart Von Auftragsart E Tipo de Pedido (De) Tipo de Pedido (De) F Type commande (De) Type commande (De) I Tipo di ordine - Da Tipo di ordine - Da JA 受注タイプ (自) 受注タイプ (自) KO 주문 유형(부터) 주문 유형(부터) PTB Tipo da Ordem (De) Tipo da Ordem (De) RU Тип заказа с Тип заказа с S Ordertyp (från) Ordertyp (från) TR Sipariş Tipi (İlk) Sipariş Tipi (İlk) US Order Type (From) Order Type (From) ZHS 订单类型（自） 订单类型（自） 13 90 :p_order_type_high LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y select ot.order_type_id id, ot.name value, null description from oe_order_types_v ot,hr_operating_units ou where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name AR نوع الطلب (إلى) نوع الطلب (إلى) D Bis Auftragsart Bis Auftragsart E Tipo de Pedido (A) Tipo de Pedido (A) F Type commande (A) Type commande (A) I Tipo di ordine - A Tipo di ordine - A JA 受注タイプ (至) 受注タイプ (至) KO 주문 유형(까지) 주문 유형(까지) PTB Tipo da Ordem (Até) Tipo da Ordem (Até) RU Тип заказа по Тип заказа по S Ordertyp (till) Ordertyp (till) TR Sipariş Tipi (Son) Sipariş Tipi (Son) US Order Type (To) Order Type (To) ZHS 订单类型（至） 订单类型（至） 14 100 :p_order_num_low Number AR رقم الطلب (من) رقم الطلب (من) D Von Auftragsnummer Von Auftragsnummer E Número de Pedido (De) Número de Pedido (De) F Numéro commande (De) Numéro commande (De) I Numero ordine - Da Numero ordine - Da JA 受注番号 (自) 受注番号 (自) KO 주문 번호(부터) 주문 번호(부터) PTB Número de Ordem (De) Número de Ordem (De) RU Номер заказа с Номер заказа с S Ordernummer (från) Ordernummer (från) TR Sipariş Numarası (İlk) Sipariş Numarası (İlk) US Order Number (From) Order Number (From) ZHS 订单编号（自） 订单编号（自） 15 110 :p_order_num_high Number select :$flex$.order_number_from from sys.dual AR رقم الطلب (إلى) رقم الطلب (إلى) D Bis Auftragsnummer Bis Auftragsnummer E Número de Pedido (A) Número de Pedido (A) F Numéro commande (A) Numéro commande (A) I Numero ordine - A Numero ordine - A JA 受注番号 (至) 受注番号 (至) KO 주문 번호(까지) 주문 번호(까지) PTB Número de Ordem (Até) Número de Ordem (Até) RU Номер заказа по Номер заказа по S Ordernummer (till) Ordernummer (till) TR Sipariş Numarası (Son) Sipariş Numarası (Son) US Order Number (To) Order Number (To) ZHS 订单编号（至） 订单编号（至） 16 120 :p_country_low LOV Oracle ONT_SRS_COUNTRY Y select territory_short_name id, territory_short_name value, null description from fnd_territories_vl order by territory_short_name AR شحن إلى دولة شحن إلى دولة D Zu belieferndes Land Zu belieferndes Land E País de Envío País de Envío F Pays de livraison Pays de livraison I Paese di spedizione Paese di spedizione JA 出荷先国 出荷先国 KO 납품처 국가 납품처 국가 PTB País para Entrega País para Entrega RU Страна получателя товара Страна получателя товара S Leveransadress - land Leveransadress - land TR Teslim Ülkesi Teslim Ülkesi US Ship to Country Ship to Country ZHS 收货方所在国家（地区） 收货方所在国家（地区） 17 130 :p_order_category LOV Oracle ONT_SRS_ORDER_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_ORDER_CATEGORY' order by meaning select meaning from oe_lookups where lookup_type='REPORT_ORDER_CATEGORY' and lookup_code='SALES' AR فئة الطلب فئة الطلب D Auftragskategorie Auftragskategorie E Categoría de Pedido Categoría de Pedido F Catégorie de commande Catégorie de commande I Categoria ordine Categoria ordine JA 受注カテゴリ 受注カテゴリ KO 주문 범주 주문 범주 PTB Categoria da Ordem Categoria da Ordem RU Категория заказа Категория заказа S Orderkategori Orderkategori TR Sipariş Kategorisi Sipariş Kategorisi US Order Category Order Category ZHS 订单类别 订单类别 18 140 :p_line_category LOV Oracle ONT_SRS_LINE_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' order by meaning select meaning from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' and lookup_code='SALES' AR فئة السطر فئة السطر D Positionskategorie Positionskategorie E Categoría de Línea Categoría de Línea F Catégorie de ligne Catégorie de ligne I Categoria linea Categoria linea JA 明細カテゴリ 明細カテゴリ KO 라인 범주 라인 범주 PTB Categoria da Linha Categoria da Linha RU Категория строки Категория строки S Radkategori Radkategori TR Satır Kategorisi Satır Kategorisi US Line Category Line Category ZHS 行类别 行类别 19 150 :p_use_functional_currency LOV Oracle OM: Yes or No 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='YES_NO' AND LOOKUP_CODE='Y' AR استخدام عملة دفتر الأستاذ استخدام عملة دفتر الأستاذ D Buchwährung verwenden Buchwährung verwenden E Utilizar Divisa de Libro Mayor Utilizar divisa del libro mayor F Utiliser la devise comptable Utiliser la devise comptable I Usa divisa libro contabile Usa la divisa del libro contabile JA 元帳通貨の使用 元帳通貨の使用 KO 원장 통화 사용 원장 통화 사용 PTB Usar Moeda do Razão Usar Moeda do Razão RU Использовать валюту книги Использовать валюту книги S Använd reskontravaluta Använd reskontravaluta TR Defter Para Birimini Kullan Defter Para Birimini Kullan US Use Ledger Currency Use Ledger Currency ZHS 使用分类帐币种 使用分类帐币种