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）限制的操作单元。 C6E085D470FF51A9E05362FB09050512 SELECT DECODE(:P_ORDER_BY, 'CUSTOMER', party.party_name) "CUST1", DECODE(:P_ORDER_BY, 'CUSTOMER', H.ORDER_NUMBER) "RMA_NUM1", DECODE(:P_ORDER_BY, 'RETURN_TYPE', otype.name) "RMA_TYPE2", DECODE(:P_ORDER_BY, 'RETURN_TYPE', party.party_name) "CUST2", DECODE(:P_ORDER_BY, 'RETURN_TYPE', H.ORDER_NUMBER) "RMA_NUM2", DECODE(:P_ORDER_BY, 'RETURN_NUMBER', H.ORDER_NUMBER) "RMA_NUM3", otype.name RETURN_TYPE, ltype.name RETURN_LINE_TYPE, H.ORDER_NUMBER RETURN_NUM, party.party_NAME CUSTOMER, cust.account_number CUSTOMER_NUMBER, to_char(H.ORDERED_DATE,'DD-MON-YY') RETURN_DATE, L.LINE_NUMBER LINE_NUM, L.LINE_NUMBER || DECODE( L.SHIPMENT_NUMBER, NULL, NULL,'.'||L.SHIPMENT_NUMBER) || DECODE(L.OPTION_NUMBER,NULL,NULL,'.' ||L.OPTION_NUMBER) LINE_SHIP_OPTION_NUM, &rp_item_flex_all_seg item_flex, l.item_identifier_type, l.inventory_item_id, l.ordered_item_id, l.ordered_item, LK.MEANING OPEN, LU.MEANING REF_TYPE, L.RETURN_CONTEXT REF_TYPE_CODE, L.RETURN_ATTRIBUTE1 REF_ID, to_char(L.REQUEST_DATE,'DD-MON-YY') EXPECTED_DATE, NVL(L.UNIT_SELLING_PRICE, 0) SELLING_PRICE, H.TRANSACTIONAL_CURR_CODE CURRENCY_CODE, NVL(L.ORDERED_QUANTITY, 0) QTY_ORDERED, NVL(L.ORDERED_QUANTITY, 0) - NVL(L.CANCELLED_QUANTITY, 0) QTY_EXPECTED, DECODE(L.LINE_CATEGORY_CODE, 'RETURN', NVL(L.SHIPPED_QUANTITY, 0) ,0) QTY_RECEIVED, DECODE(L.BOOKED_FLAG,'Y' ,NVL(L.FULFILLED_QUANTITY, 0),0) QTY_ACCEPTED, NVL(L.ORDERED_QUANTITY,0) QTY_AUTHORIZED, nvl(l.shipped_quantity,0) qty_shipped, TRX.TRX_NUMBER CREDIT_TO_INVOICE, L.LINE_ID LINE_ID, ONT_OEXOEORD_XMLP_PKG.AMT_EXPECTEDFORMULA(NVL(L.ORDERED_QUANTITY,0), NVL(L.UNIT_SELLING_PRICE, 0),H.TRANSACTIONAL_CURR_CODE) AMT_EXPECTED, ONT_OEXOEORD_XMLP_PKG.AMT_RECEIVEDFORMULA(DECODE(L.LINE_CATEGORY_CODE, 'RETURN', NVL(L.SHIPPED_QUANTITY, 0) ,0), NVL(L.UNIT_SELLING_PRICE, 0),H.TRANSACTIONAL_CURR_CODE) AMT_RECEIVED, ONT_OEXOEORD_XMLP_PKG.AMT_ACCEPTEDFORMULA(DECODE(L.BOOKED_FLAG,'Y' ,NVL(L.FULFILLED_QUANTITY, 0),0), NVL(L.UNIT_SELLING_PRICE, 0),H.TRANSACTIONAL_CURR_CODE) AMT_ACCEPTED, ONT_OEXOEORD_XMLP_PKG.Item_dspFormula (l.item_identifier_type , l.inventory_item_id, l.ordered_item_id,l.ordered_item,SI.ORGANIZATION_ID,SI.INVENTORY_ITEM_ID) Item_dsp FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H, oe_transaction_types_tl otype, oe_transaction_types_tl ltype, OE_LOOKUPS LU, OE_LOOKUPS LK, JTF_RS_SALESREPS SR, MTL_SYSTEM_ITEMS_VL SI, hz_cust_accounts cust, hz_parties party, RA_CUSTOMER_TRX_ALL TRX, RA_CUSTOMER_TRX_LINES_ALL TRXL WHERE h.header_id = l.header_id AND L.ITEM_TYPE_CODE(+)!='INCLUDED' AND H.BOOKED_FLAG='Y' AND L.BOOKED_FLAG='Y' AND LU.LOOKUP_TYPE(+) = 'REFERENCE_TYPE' AND LU.LOOKUP_CODE(+) = L.RETURN_CONTEXT AND LK.LOOKUP_TYPE='YES_NO' AND LK.LOOKUP_CODE=NVL(H.OPEN_FLAG ,'N') and l.line_type_id = ltype.transaction_type_id(+) and h.order_type_id = otype.transaction_type_id(+) and ltype.language(+) = :p_lang and otype.language(+) = :p_lang AND H.SALESREP_ID = SR.SALESREP_ID(+) AND L.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID AND SI.ORGANIZATION_ID = :c_master_org and h.sold_to_org_id = cust.cust_account_id and party.party_id = cust.party_id AND L.CREDIT_INVOICE_LINE_ID = TRXL.CUSTOMER_TRX_LINE_ID(+) AND TRXL.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID(+) and nvl(h.org_id,0) = :p_organization_id and nvl(sr.org_id,0) = :p_organization_id &LP_RETURN_TYPE &LP_RETURN_LINE_TYPE &LP_LINE_CATEGORY &LP_SALESREP &LP_CUSTOMER_NAME &LP_CUSTOMER_NUM and &LP_ITEM &LP_RETURN_NUM &LP_RETURN_DATE &LP_OPEN_RETURNS_ONLY ORDER BY 1 ASC,2 ASC, 3 ASC,4 ASC,5 ASC,6 ASC,9 ASC,10 ASC,11 ASC,7 ASC,20 ASC,35 ASC,L.LINE_NUMBER Y ONT OEXOEORD_XML AR ONT تقرير تفاصيل الطلب الدائن Imported from BI Publisher Description: تقرير تفاصيل الطلب الدائن Application: إدارة الطلبات Source: تقرير تفاصيل الطلب الدائن (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG D ONT Gutschriftsfähige Aufträge - Details Imported from BI Publisher Description: Auswertung "Gutschriftsfähige Aufträge - Details" Application: Order Management Source: Gutschriftsfähige Aufträge - Details (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG E ONT Informe Detalle de Pedido de Abono Imported from BI Publisher Description: Informe Detalle de Pedido de Abono Application: Order Management Source: Informe Detalle de Pedido de Abono (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG F ONT Etat Détail commande créditrice Imported from BI Publisher Description: Etat Détail commande créditrice Application: Order Management Source: Etat Détail commande créditrice (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG I ONT Rapporto Dettaglio ordine di accredito Imported from BI Publisher Description: Rapporto Dettaglio ordine di accredito Application: Order Management Source: Rapporto Dettaglio ordine di accredito (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG JA ONT クレジット受注詳細レポート Imported from BI Publisher Description: クレジット受注詳細レポート Application: Order Management Source: クレジット受注詳細レポート(XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG KO ONT 신용 주문 상세 보고서 Imported from BI Publisher Description: 신용 주문 상세내역 보고서 Application: Order Management Source: 신용 주문 상세 보고서(XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG PTB ONT Relatório Detalhado da Ordem de Crédito Imported from BI Publisher Description: Relatório Detalhado da Ordem de Crédito Application: Gerenciamento de Ordens Source: Relatório Detalhado da Ordem de Crédito (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG RU ONT Подробный отчет о заказах на возврат кредита Imported from BI Publisher Description: Подробный отчет о заказах на возврат кредита Application: Управление заказами Source: Подробный отчет о заказах на возврат кредита (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG S ONT Kreditorder - detaljrapport Imported from BI Publisher Description: Kreditorder - detaljrapport Application: Order Management Source: Kreditorder - detaljrapport (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG TR ONT Kredili Sipariş Detay Raporu Imported from BI Publisher Description: Kredili Sipariş Detay Raporu Application: Sipariş Yönetimi(1) Source: Kredili Sipariş Detay Raporu (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG US ONT Credit Order Detail Imported from BI Publisher Description: Credit Order Detail Report Application: Order Management Source: Credit Order Detail Report (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG ZHS ONT 信用订单明细报表 Imported from BI Publisher Description: 信用订单详细资料报表 Application: 订单管理 Source: 信用订单明细报表 (XML) Short Name: OEXOEORD_XML DB package: ONT_OEXOEORD_XMLP_PKG BI Publisher &lp_customer_name &lp_customer_num &lp_item &lp_line_category &lp_open_returns_only &lp_return_date &lp_return_line_type &lp_return_num &lp_return_type &lp_salesrep &rp_item_flex_all_seg :c_master_org :credit_only_meaning :customer_num_parms :customer_parms :l_line_type :l_order_type :lp_credit_only :lp_customer_name :lp_customer_num :lp_item :lp_line_category :lp_open_returns_only :lp_return_date :lp_return_line_type :lp_return_num :lp_return_type :lp_salesrep :operating_unit :p_conc_request_id :p_credit_only :p_customer_name_high :p_customer_name_low :p_customer_num_high :p_customer_num_low :p_enable_trace :p_item :p_item_flex_code :p_item_name :p_item_structure_num :p_lang :p_line_category :p_min_precision :p_open_returns_only :p_order_by :p_organization_id :p_print_description :p_return_date_high :p_return_date_low :p_return_line_type :p_return_num_high :p_return_num_low :p_return_type :p_salesrep :p_sob_id :return_date_parms :return_num_parms :rp_company_name :rp_curr_profile :rp_data_found :rp_functional_currency :rp_item_flex_all_seg :rp_open_returns_only :rp_print_description :rp_report_name :rp_sub_title :sort_by_meaning 1 -30 :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 -20 :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 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 4 10 :p_order_by LOV Oracle ONT_SRS_OEXOEORD_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXOEORD ORDER BY' order by meaning select meaning from oe_lookups where lookup_code = 'CUSTOMER' and lookup_type = 'OEXOEORD ORDER BY' 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 排序依据 排序依据 5 20 :p_open_returns_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 gutschriftsfähige Aufträge Nur offene gutschriftsfähige Aufträge E Sólo Pedidos de Abono Abiertos Sólo Pedidos de Abono Abiertos F Ouvrir commandes créditrices uniquement Ouvrir commandes créditrices uniquement I Solo ordini di accredito aperti Solo ordini di accredito aperti JA オープン・クレジット受注のみ オープン・クレジット受注のみ KO 개설 신용 주문만 개설 신용 주문만 PTB Abrir Somente Ordens de Crédito Abrir Somente Ordens de Crédito RU Только открытые заказы на возврат кредита Только открытые заказы на возврат кредита S Öppna endast kreditorder Öppna endast kreditorder TR Yalnızca Kredili Siparişleri Aç Yalnızca Kredili Siparişleri Aç US Open Credit Orders Only Open Credit Orders Only ZHS 仅限于未结信用订单 仅限于未结信用订单 6 30 :p_item LOV Oracle ONT: Internal_item Y select inventory_item_id id, concatenated_segments value, null description from mtl_system_items_kfv where customer_order_enabled_flag='Y' and bom_item_type in (1,4) and organization_id= oe_sys_parameters.value('MASTER_ORGANIZATION_ID') order by value,description 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 物料 物料 7 40 :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 Lagerartikel-Beschreibung drucken E Presentación de Artículo Imprimir Descripción de Artículo de Inventario F Affichage article Imprimer description d'article stocké I Visualizzazione articolo Stampa descrizione articolo di magazzino JA 品目表示 在庫品目摘要の印刷 KO 품목 표시 재고 품명 인쇄 PTB Exibição do Item Imprimir Descrição do Item de Inventário RU Вывод позиции Печать описания позиции запасов S Artikelvisning Skriv ut beskrivning av lagerartikel TR Kalem Görüntüleme Envanter Kalemi Tanımlaması'nı yazdırır US Item Display Print Inventory Item Description ZHS 项目显示 打印库存物料说明 8 50 :p_salesrep 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 Vertriebsmitarbeiter Vertriebsmitarbeiter E Vendedor Vendedor F Vendeur Vendeur I Rappresentante commerciale Rappresentante commerciale JA 営業担当 営業担当 KO 영업사원 영업사원 PTB Vendedor Vendedor RU Продавец Продавец S Säljare Säljare TR Satış Elemanı Satış Elemanı US Salesperson Salesperson ZHS 销售人员 销售人员 9 60 :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) De Nombre de Cliente F Nom client (De) Nom client (De) I Nome cliente - Da Nome cliente (min) JA 顧客名 (自) 顧客名 (自) KO 고객명(부터) 고객명 (하한) PTB Nome do Cliente (De) Nome do Cliente (Inferior) RU Имя заказчика с Имя заказчика с S Kundnamn (från) Kundnamn (från) TR Müşteri Adı (İlk) Müşteri Adı (Alt Değer) US Customer Name (From) Customer Name (Low) ZHS 客户名称（自） 客户名称（下限） 10 70 :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) A Nombre de Cliente F Nom client (A) Nom client (Au) I Nome cliente - A Nome cliente (max) JA 顧客名 (至) 顧客名 (至) KO 고객명(까지) 고객명 (상한) PTB Nome do Cliente (Até) Nome do Cliente (Superior) RU Имя заказчика по Имя заказчика по S Kundnamn (till) Kundnamn (till) TR Müşteri Adı (Son) Müşteri Adı (Üst Değer) US Customer Name (To) Customer Name (High) ZHS 客户名称（至） 客户名称（上限） 11 80 :p_customer_num_low LOV Oracle ONT_SRS_CUSTOMER_NUMBER Y select customer_number id, customer_number value, null description from oe_sold_to_orgs_v order by customer_number AR رقم العميل (من) رقم العميل (من) D Von Kundennummer Von Kundennummer E Número de Cliente (De) De Número de Cliente F Numéro client (De) Numéro client (De) I Numero cliente - Da Numero cliente - Minimo JA 顧客番号 (自) 顧客番号 (自) KO 고객 번호(부터) 고객 번호(하한) PTB Número do Cliente (De) Número do Cliente (Inferior) RU Номер заказчика с Номер заказчика с S Kundnummer (från) Kundnummer (från) TR Müşteri Numarası (İlk) Müşteri Numarası (İlk) US Customer Number (From) Customer Number (Low) ZHS 客户编号（自） 客户编号（下限） 12 90 :p_customer_num_high LOV Oracle ONT_SRS_CUSTOMER_NUMBER Y select customer_number id, customer_number value, null description from oe_sold_to_orgs_v order by customer_number select :$flex$.customer_number_from from sys.dual AR رقم العميل (إلى) رقم العميل (إلى) D Bis Kundennummer Bis Kundennummer E Número de Cliente (A) A Número de Cliente F Numéro client (A) Numéro client (Au) I Numero cliente - A Numero cliente - Massimo JA 顧客番号 (至) 顧客番号 (至) KO 고객 번호(까지) 고객 번호(상한) PTB Número do Cliente (Até) Número do Cliente (Superior) RU Номер заказчика по Номер заказчика по S Kundnummer (till) Kundnummer (till) TR Müşteri Numarası (Son) Müşteri Numarası (İlk) US Customer Number (To) Customer Number (High) ZHS 客户编号（至） 客户编号（上限） 13 100 :p_return_type 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 Art gutschriftsfähiger Auftrag Art gutschriftsfähiger Auftrag E Tipo de Pedido de Abono Tipo de Pedido de Abono F Type commande créditrice Type commande créditrice I Tipo ordine di accredito Tipo ordine di accredito JA クレジット受注タイプ クレジット受注タイプ KO 신용 주문 유형 신용 주문 유형 PTB Tipo da Ordem de Crédito Tipo da Ordem de Crédito RU Тип заказа на возврат кредита Тип заказа на возврат кредита S Kreditordertyp Kreditordertyp TR Kredili Sipariş Tipi Kredili Sipariş Tipi US Credit Order Type Credit Order Type ZHS 信用订单类型 信用订单类型 14 110 :p_return_line_type LOV Oracle ONT_MOAC_SRS_LINE_TYPES Y select lt.line_type_id id, lt.name value, null description from oe_line_types_v lt,hr_operating_units ou where lt.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=lt.org_id) order by lt.name AR نوع سطر الطلب الدائن نوع سطر الطلب الدائن D Positionsart gutschriftsfähiger Auftrag Positionsart gutschriftsfähiger Auftrag E Tipo de Línea de Pedido de Abono Tipo de Línea de Pedido de Abono F Type de ligne commande créditrice Type de ligne commande créditrice I Tipo linea ordine di accredito Tipo linea ordine di accredito JA クレジット受注明細タイプ クレジット受注明細タイプ KO 신용 주문 라인 유형 신용 주문 라인 유형 PTB Tipo de Linha da Ordem de Crédito Tipo de Linha da Ordem de Crédito RU Тип строки заказа на возврат кредита Тип строки заказа на возврат кредита S Kreditorderradtyp Kreditorderradtyp TR Kredili Sipariş Satır Tipi Kredili Sipariş Satır Tipi US Credit Order Line Type Credit Order Line Type ZHS 信用订单行类型 信用订单行类型 15 120 :p_line_category LOV Oracle ONT_SRS_CREDIT_LINE_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' and lookup_code<>'SALES' order by value,description select meaning from oe_lookups where lookup_type = 'REPORT_LINE_DISPLAY' and lookup_code = 'CREDIT' 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 行类别 行类别 16 130 :p_return_num_low Number AR رقم الطلب الدائن من رقم الطلب الدائن (من) D Von Nummer gutschriftsfähiger Auftrag Von Nummer gutschriftsfähiger Auftrag E Número de Pedido de Abono (De) De Número de Pedido de Abono F Numéro commande créditrice (De) Numéro commande créditrice (De) I Numero ordine di accredito - Da Numero ordine di accredito - Minimo JA クレジット受注番号 (自) クレジット受注番号 (自) KO 신용 주문 번호(부터) 신용 주문 번호(하한) PTB Número da Ordem de Crédito (De) Número da Ordem de Crédito (Inferior) RU Номер заказа на возврат кредита с Номер заказа на возврат кредита с S Kreditordernummer (från) Kreditordernummer (från) TR Kredili Sipariş Numarası (İlk) Kredili Sipariş Numarası (Alt Değer) US Credit Order Number (From) Credit Order Number (Low) ZHS 信用订单编号（自） 信用订单编号（下限） 17 140 :p_return_num_high Number select :$flex$.credit_order_number_from from sys.dual AR رقم الطلب الدائن (إلى) رقم الطلب الدائن (إلى) D Bis Nummer gutschriftsfähiger Auftrag Bis Nummer gutschriftsfähiger Auftrag E Número de Pedido de Abono (A) A Número de Pedido de Abono F Numéro commande créditrice (A) Numéro commande créditrice (A) I Numero ordine di accredito - A Numero ordine di accredito - Massimo JA クレジット受注番号 (至) クレジット受注番号 (至) KO 신용 주문 번호(까지) 신용 주문 번호(상한) PTB Número da Ordem de Crédito (Até) Número da Ordem de Crédito (superior) RU Номер заказа на возврат кредита с 2 Номер заказа на возврат кредита по S Kreditordernummer (till) Kreditordernummer (till) TR Kredili Sipariş Numarası (Son) Kredili Sipariş Numarası (üst değer) US Credit Order Number (To) Credit Order Number (high) ZHS 信用订单编号（至） 信用订单编号（上限） 18 150 :p_return_date_low Date AR تاريخ الطلب الدائن (من) تاريخ الطلب الدائن (من) D Von Datum gutschriftsfähiger Auftrag Von Datum gutschriftsfähiger Auftrag E Fecha de Pedido de Abono (De) De Fecha de Pedido de Abono F Date commande créditrice (Du) Date commande créditrice (Du) I Data ordine di accredito - Da Data ordine di accredito - Minimo JA クレジット受注日 (自) クレジット受注日 (自) KO 신용 주문 일자(부터) 신용 주문 일자(하한) PTB Data da Ordem de Crédito (De) Data da Ordem de Crédito (Inferior) RU Дата возврата кредита с Дата возврата кредита с S Kreditorderdatum (från) Kreditorderdatum (till) TR Kredili Sipariş Tarihi (İlk) Kredili Sipariş Tarihi (Alt Değer) US Credit Order Date (From) Credit Order Date (Low) ZHS 信用订单日期（自） 信用订单日期（下限） 19 160 :p_return_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.credit_order_date_from)) from sys.dual AR تاريخ الطلب الدائن (إلى) تاريخ الطلب الدائن (إلى) D Bis Datum gutschriftsfähiger Auftrag Bis Datum gutschriftsfähiger Auftrag E Fecha de Pedido de Abono (A) A Fecha de Pedido de Abono F Date commande créditrice (Au) Date commande créditrice (Au) I Data ordine di accredito - A Data ordine di accredito - Massimo JA クレジット受注日 (至) クレジット受注日 (至) KO 신용 주문 일자(까지) 신용 주문 일자(상한) PTB Data da Ordem de Crédito (Até) Data da Ordem de Crédito (Superior) RU Дата возврата кредита по Дата возврата кредита по S Kreditorderdatum (till) Kreditordernummer (till) TR Kredili Sipariş Tarihi (Son) Kredili Sipariş tarihi (İlk) US Credit Order Date (To) Credit Order date (High) ZHS 信用订单日期（至） 信用订单日期（上限） 20 170 :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_code = 'N' and lookup_type = 'YES_NO' 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 使用分类帐币种 使用分类帐币种 :$flex$.credit_order_date_from Credit Order Date (From) Y Credit Order Date (To) :$flex$.credit_order_number_from Credit Order Number (From) Credit Order Number (To) :$flex$.customer_name_from Customer Name (From) Customer Name (To) :$flex$.customer_number_from Customer Number (From) Customer Number (To)