ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FCA51A9E05362FB09050512Y SELECT orgnmst.orgn_name Orgn_Name, ordr_hdr.order_type Order_Type, ordr_hdr.release_no Release_no, ordr_hdr.order_date O_Date, ordr_hdr.order_id Order_id_hdr, ordr_hdr.order_no O_No, ordr_hdr.sched_shipdate Ship_Date, ordr_hdr.custpo_no Cust_Po, ordr_hdr.text_code Text, ordr_hdr.billing_currency Bill_Curr, soldcust.cust_no Sold_Cust, soldcust.cust_name Sold_Name, soldcust.addr_id Sold_id, billcust.cust_no Bill_No, billcust.cust_name Bill_Name, billcust.mailaddr_id Bill_id, shipcust.cust_name Ship_Name, ordr_hdr.fob_code Fbc, ordr_hdr.frtbill_mthd Fbm, ordr_hdr.terms_code Terms, ordr_hdr.shipcust_id Ship_id, ordr_hdr.shipaddr_id Ship_Add, GML_ORAKRP_XMLP_PKG.udateformula(ordr_hdr.order_type,ordr_hdr.order_no,ordr_hdr.release_no) udate, GML_ORAKRP_XMLP_PKG.head_chargescfformula(ordr_hdr.order_id) Header_chargesCF, GML_ORAKRP_XMLP_PKG.head_discountscfformula(ordr_hdr.order_id) Header_discountsCF, GML_ORAKRP_XMLP_PKG.ord_tot_formula(ordr_hdr.order_id) Ord_Total, GML_ORAKRP_XMLP_PKG.terms_codeformula(ordr_hdr.terms_code) Terms_code FROM op_ordr_hdr ordr_hdr, op_cust_mst soldcust, op_cust_mst billcust, op_cust_mst shipcust, sy_orgn_mst orgnmst WHERE ordr_hdr.orgn_code = :ORGN_CODE AND ordr_hdr.delete_mark = 0 AND ordr_hdr.order_status != -2 AND ordr_hdr.completed_ind != -1 AND orgnmst.orgn_code = :ORGN_CODE AND soldcust.cust_id (+) = ordr_hdr.soldtocust_id AND billcust.cust_id (+) = ordr_hdr.billcust_id AND shipcust.cust_id (+) = ordr_hdr.shipcust_id and TRUNC(ordr_hdr.order_date) between TRUNC(nvl(:from_order_date_1,ordr_hdr.order_date)) and TRUNC(nvl(:to_order_date_1,ordr_hdr.order_date)) &Order_NumberCP &Sold_ToCP &Bill_ToCP &Exclude_PrintedCP &Exclude_On_HoldCP ORDER BY orgnmst.orgn_name,ordr_hdr.order_date,ordr_hdr.order_no,ordr_hdr.Order_id,ordr_hdr.shipaddr_id,ordr_hdr.shipcust_id, ordr_hdr.order_type, DECODE (:SORT_1,'1','ordr_hdr.order_no','2', 'ordr_hdr.order_date','3','soldcust.cust_no','4','billcust.cust_no') &Sort2_CP &Sort3_CP GML ORAKRP_XML AR GML تقرير إشعار استلام أمر المبيعات Imported from BI Publisher Description: تقرير إشعار استلام أمر مبيعات عملية OPM لأوراكل Application: الإجراءات التنظيمية للتصنيع التشغيلي Source: تقرير إشعار استلام أمر المبيعات (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG D GML Auftragsbestätigung Imported from BI Publisher Description: Auswertung "Auftragsbestätigung" in OPM OP Application: Process Manufacturing Logistik Source: Auftragsbestätigung (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG E GML Acuse de Recibo de Pedidos de Venta Imported from BI Publisher Description: Informe Reconocimiento de Pedidos de Venta de OP de OPM Application: Process Manufacturing Logistics Source: Acuse de Recibo de Pedidos de Venta (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG F GML Accusé de réception de commande Imported from BI Publisher Description: Etat Accusé de réception de commande d'Oracle OPM PO Application: Process Manufacturing Logistics Source: Accusé de réception de commande (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG I GML Rapporto Accettazione ordine di vendita Imported from BI Publisher Description: Rapporto Accettazione ordini di vendita di Oracle OPM OP Application: Process Manufacturing Logistics Source: Rapporto Accettazione ordine di vendita (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG JA GML 販売オーダー確認レポート Imported from BI Publisher Description: Oracle OPM OPの販売オーダー確認レポート Application: Process Manufacturing Logistics Source: 販売オーダー確認レポート(XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG KO GML 판매 주문 동의 보고서 Imported from BI Publisher Description: Oracle OPM OP의 판매 주문 동의 보고서 Application: Process Manufacturing Logistics Source: 판매 주문 동의 보고서(XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG PTB GML Relatório de Confirmação da Ordem de Venda Imported from BI Publisher Description: Relatório de Confirmação da Ordem de Venda do Oracle OPM OP Application: Process Manufacturing Logistics Source: Relatório de Confirmação da Ordem de Venda (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG RU GML Отчет о подтверждениях заказов на продажу Imported from BI Publisher Description: Отчет о подтверждениях заказов на продажу в ЗП УНП Application: Логистика УНП Source: Отчет о подтверждениях заказов на продажу (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG S GML Kundordererkännande - rapport Imported from BI Publisher Description: Ordererkännande - rapport i Oracle OPM OB Application: Process Manufacturing Logistics Source: Kundordererkännande - rapport (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG TR GML Satış Siparişi Onay Raporu Imported from BI Publisher Description: Oracle OPM OP Satış Siparişi Onay Raporu Application: Üretim Prosesi Lojistik Source: Satış Siparişi Onay Raporu (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG US GML Sales Order Acknowledgement Imported from BI Publisher Description: Sales Order Acknowledgement Report of Oracle OPM OP Application: Process Manufacturing Logistics Source: Sales Order Acknowledgement Report (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG ZHS GML 销售订单确认报表 Imported from BI Publisher Description: Oracle OPM OP 的销售订单确认报表 Application: OPM 采购管理系统 Source: 销售订单确认报表 (XML) Short Name: ORAKRP_XML DB package: GML_ORAKRP_XMLP_PKG BI Publisher &bill_tocp &exclude_on_holdcp &exclude_printedcp &order_numbercp &sold_tocp &sort2_cp &sort3_cp :bill_tocp :charge_amtcp :charge_desccp :cp_orgn_name :cp_user :default_user :exclude_on_hold :exclude_on_holdcp :exclude_printed :exclude_printedcp :from_bill_to :from_order_date :from_order_date_1 :from_order_number :from_sold_to :lfrom_bill_to :lfrom_order_number :lfrom_sold_to :lto_bill_to :lto_order_number :lto_sold_to :order_datecp :order_numbercp :orgn_code :orgn_name_cp :p_bill_address1 :p_conc_request_id :p_default_orgn :p_sort_order :sold_tocp :sort1_cp :sort2_cp :sort3_cp :sort_1 :sort_2 :sort_3 :to_bill_to :to_order_date :to_order_date_1 :to_order_number :to_sold_to 1 -40 :orgn_code LOV Oracle ORGN_CODE_CHAR4 Y select orgn_code id, orgn_code value, null description from sy_orgn_mst order by orgn_code fnd_profile.value('GEMMS_DEFAULT_ORGN') Y AR ORGN_CODE_CHAR4 التنظيم D ORGN_CODE_CHAR4 Org. E ORGN_CODE_CHAR4 Organización F ORGN_CODE_CHAR4 Organisation I ORGN_CODE_CHAR4 Org. JA ORGN_CODE_CHAR4 組織 KO ORGN_CODE_CHAR4 조직 PTB ORGN_CODE_CHAR4 Org. RU ORGN_CODE_CHAR4 Орг. S ORGN_CODE_CHAR4 Org. TR ORGN_CODE_CHAR4 Organizasyon US ORGN_CODE_CHAR4 Orgn ZHS ORGN_CODE_CHAR4 组织 2 -30 :p_default_orgn LOV Oracle OP_DEFAULT_COMPANY Y select co_code id, co_code value, null description from sy_orgn_mst where orgn_code=:$flex$.orgn_code_char4 order by value,description SELECT co_code FROM sy_orgn_mst WHERE orgn_code = :$FLEX$.ORGN_CODE_CHAR4 AR الشركة الشركة D Firma Firma E Compañía Compañía F Société Société I Società Società JA 会社 会社 KO 회사 회사 PTB Empresa Empresa RU Компания Компания S Företag Företag TR Şirket Şirket US Company Company ZHS 公司 公司 3 -20 :default_user Number fnd_profile.value('USER_ID') Y AR مستخدم مستخدم D Benutzer Benutzer E Usuario Usuario F Utilisateur Utilisateur I Utente Utente JA ユーザー ユーザー KO 사용자 사용자 PTB Usuário Usuário RU Пользователь Пользователь S Användare Användare TR Kullanıcı Kullanıcı US User User ZHS 用户 用户 4 10 :exclude_printed LOV Oracle OP_EXCLUDE_PRINTED Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='OP_EXCLUDE_PRINTED' order by lookup_code 1 AR استثناء مطبوع استثناء مطبوع D Ohne gedruckte Ohne gedruckte E Excluir Impresos Excluir Impresos F Exclure imprimé Exclure imprimé I Escludi ordini stampati Escludi ordini stampati JA 印刷済を除く 印刷済を除く KO 인쇄 제외 인쇄 제외 PTB Excluir Impresso Excluir Impresso RU Исключить напечатанные Исключить напечатанные S Exkludera utskrift Exkludera utskrift TR Yazdırılanı Hariç Tut Yazdırılanı Hariç Tut US Exclude Printed Exclude Printed ZHS 不打印 不打印 5 20 :from_order_number LOV Oracle OP_ORDER_NO Y select order_no id, order_no value, null description from op_ordr_hdr where delete_mark=0 and orgn_code= fnd_profile.value('GEMMS_DEFAULT_ORGN') order by order_no AR من رقم الطلب من رقم الطلب D Von Auftragsnummer Von Auftragsnummer E De Número de Pedido De Número de Pedido F Numéro commande - De Numéro commande - De I N. ordine - Da N. ordine - Da JA オーダー番号:自 オーダー番号:自 KO 주문 번호: 부터 주문 번호: 부터 PTB Nr. Ordem - De Nr. Ordem - De RU № заказа с № заказа с S Från ordernummer Från ordernummer TR İlk Sipariş Numarası İlk Sipariş Numarası US From Order Number From Order Number ZHS 起始订单编号 起始订单编号 6 30 :to_order_number LOV Oracle OP_ORDER_NO Y select order_no id, order_no value, null description from op_ordr_hdr where delete_mark=0 and orgn_code= fnd_profile.value('GEMMS_DEFAULT_ORGN') order by order_no :$flex$.from_order_number AR إلى رقم الطلب إلى رقم الطلب D Bis Auftragsnummer Bis Auftragsnummer E A Número de Pedido A Número de Pedido F Numéro commande - A Numéro commande - A I N. ordine - A N. ordine - A JA オーダー番号:至 オーダー番号:至 KO 주문 번호: 까지 주문 번호: 까지 PTB Nr. da Ordem - Até Nr. da Ordem - Até RU № заказа по № заказа по S Till ordernummer Till ordernummer TR Son Sipariş Numarası Son Sipariş Numarası US To Order Number To Order Number ZHS 终止订单编号 终止订单编号 7 40 :from_order_date Date AR من تاريخ الطلب من تاريخ الطلب D Von Auftragsdatum Von Auftragsdatum E De Fecha de Pedido De Fecha de Pedido F Date de commande - Du Date de commande - Du I Data ordine - Da Data ordine - Da JA オーダー日:自 オーダー日:自 KO 주문 일자: 부터 주문 일자: 부터 PTB Data da Ordem - De Data da Ordem - De RU Дата заказа с Дата заказа с S Från orderdatum Från orderdatum TR İlk Sipariş Tarihi İlk Sipariş Tarihi US From Order Date From Order Date ZHS 起始订单日期 起始订单日期 8 50 :to_order_date Date AR إلى تاريخ الطلب إلى تاريخ الطلب D Bis Bis E A Fecha de Pedido A Fecha de Pedido F Date de commande - Au Date de commande - Au I Data ordine - A Data ordine - A JA オーダー日:至 オーダー日:至 KO 주문 일자: 까지 주문 일자: 까지 PTB Data da Ordem - Até Data da Ordem - Até RU Дата заказа по Дата заказа по S Till orderdatum Till orderdatum TR Son Sipariş Tarihi Son Sipariş Tarihi US To Order Date To Order Date ZHS 订单日期至 订单日期至 9 60 :from_sold_to LOV Oracle OP_BILLTO_CUST Y Y select cust_no id, cust_no value, cust_name description from op_cust_mst where delete_mark=0 and bill_ind=1 order by custsort_no, cust_no, cust_name AR من العميل المباع من العميل المباع D Von Kunde Verkauf Von Kunde Verkauf E De Cliente de Venta De Cliente de Venta F Client acheteur - De Client acheteur - De I Cliente vendita - Da Cliente vendita - Da JA 販売顧客:自 販売顧客:自 KO 판매 고객: 부터 판매 고객: 부터 PTB Cliente da Venda - De Cliente da Venda - De RU Покупатель с Покупатель с S Från köpare Från köpare TR İlk Satın Alan Müşteri İlk Satın Alan Müşteri US From Sold Customer From Sold Customer ZHS 起始采购客户 起始采购客户 10 70 :to_sold_to LOV Oracle OP_BILLTO_CUST Y Y select cust_no id, cust_no value, cust_name description from op_cust_mst where delete_mark=0 and bill_ind=1 order by custsort_no, cust_no, cust_name :$flex$.from_sold_customer AR إلى العميل المباع له إلى العميل المباع له D Bis Kunde Verkauf Bis Kunde Verkauf E A Cliente de Venta A Cliente de Venta F Client acheteur - A Client acheteur - A I Cliente vendita - A Cliente vendita - A JA 販売顧客:至 販売顧客:至 KO 판매 고객: 까지 판매 고객: 까지 PTB Cliente da Venda - Até Cliente da Venda - Até RU Покупатель по Покупатель по S Till köpare Till köpare TR Son Satın Alan Müşteri Son Satın Alan Müşteri US To Sold Customer To Sold Customer ZHS 终止采购客户 终止采购客户 11 80 :from_bill_to LOV Oracle OP_BILLTO_CUST Y Y select cust_no id, cust_no value, cust_name description from op_cust_mst where delete_mark=0 and bill_ind=1 order by custsort_no, cust_no, cust_name AR من عميل الفاتورة من عميل الفاتورة D Von Kunde Rechnung Von Kunde Rechnung E De Cliente de Facturación De Cliente de Facturación F Client facturé - De Client facturé - De I Cliente fatturazione - Da Cliente fatturazione - Da JA 請求顧客:自 請求顧客:自 KO 청구처 고객: 부터 청구처 고객: 부터 PTB Cliente para Faturamento - De: Cliente para Faturamento - De: RU Получатель счета с Получатель счета с S Från faktureringskund Från faktureringskund TR İlk Fatura Müşterisi İlk Fatura Müşterisi US From Bill Customer From Bill Customer ZHS 起始收单客户 起始收单客户 12 90 :to_bill_to LOV Oracle OP_BILLTO_CUST Y Y select cust_no id, cust_no value, cust_name description from op_cust_mst where delete_mark=0 and bill_ind=1 order by custsort_no, cust_no, cust_name :$flex$.from_bill_customer AR إلى عميل الفاتورة إلى عميل الفاتورة D Bis Kunde Rechnung Bis Kunde Rechnung E A Cliente de Facturación A Cliente de Facturación F Client facturé - A Client facturé - A I Cliente fatturazione - A Cliente fatturazione - A JA 請求顧客:至 請求顧客:至 KO 청구처 고객: 까지 청구처 고객: 까지 PTB Cliente para Faturamento - Até Cliente para Faturamento - Até RU Получатель счета по Получатель счета по S Till faktureringskund Till faktureringskund TR Son Fatura Müşterisi Son Fatura Müşterisi US To Bill Customer To Bill Customer ZHS 终止收单客户 终止收单客户 13 100 :exclude_on_hold LOV Oracle OP_EXCLUDE_ON_HOLD Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='OP_EXCLUDE_ON_HOLD' order by lookup_code 1 AR استثناء محتجز استثناء محتجز D Ohne gesperrte Ohne gesperrte E Excluir Retenidos Excluir Retenidos F Exclure bloqué Exclure bloqué I Escludi ordini bloccati Escludi ordini bloccati JA 保留中を除く 保留中を除く KO 현재고 제외 현재고 제외 PTB Excluir Em Retenção Excluir Em Retenção RU Исключить заблокированные Исключить заблокированные S Exkludera spärrad Exkludera spärrad TR Durdurulanı Hariç Tut Durdurulanı Hariç Tut US Exclude On Hold Exclude On Hold ZHS 不暂挂 不暂挂 14 110 :sort_1 LOV Oracle OP_ORDER_BY Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='OP_SORT_ORDER' order by lookup_code 1 Y AR ترتيب الفرز 1 ترتيب الفرز 1 D Sortierfolge 1 Sortierfolge 1 E Orden de Clasificación 1 Orden de Clasificación 1 F Ordre de tri 1 Ordre de tri 1 I Ordinamento 1 Ordinamento 1 JA ソート順1 ソート順1 KO 정렬 순서 1 정렬 순서 1 PTB Ordem de Classificação 1 Ordem de Classificação 1 RU Порядок сортировки 1 Порядок сортировки 1 S Sorteringsordning 1 Sorteringsordning 1 TR Sıralama Sırası 1 Sıralama Sırası 1 US Sort Order 1 Sort Order 1 ZHS 排序 1 排序 1 15 120 :sort_2 LOV Oracle OP_ORDER_BY Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='OP_SORT_ORDER' order by lookup_code AR ترتيب الفرز 2 ترتيب الفرز 2 D Sortierfolge 2 Sortierfolge 2 E Orden de Clasificación 2 Orden de Clasificación 2 F Ordre de tri 2 Ordre de tri 2 I Ordinamento 2 Ordinamento 2 JA ソート順2 ソート順2 KO 정렬 순서 2 정렬 순서 2 PTB Ordem de Classificação 2 Ordem de Classificação 2 RU Порядок сортировки 2 Порядок сортировки 2 S Sorteringsordning 2 Sorteringsordning 2 TR Sıralama Sırası 2 Sıralama Sırası 2 US Sort Order 2 Sort Order 2 ZHS 排序 2 排序 2 16 130 :sort_3 LOV Oracle OP_ORDER_BY Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='OP_SORT_ORDER' order by lookup_code AR ترتيب الفرز 3 ترتيب الفرز 3 D Sortierfolge 3 Sortierfolge 3 E Orden de Clasificación 3 Orden de Clasificación 3 F Ordre de tri 3 Ordre de tri 3 I Ordinamento 3 Ordinamento 3 JA ソート順3 ソート順3 KO 정렬 순서 3 정렬 순서 3 PTB Ordem de Classificação 3 Ordem de Classificação 3 RU Порядок сортировки 3 Порядок сортировки 3 S Sorteringsordning 3 Sorteringsordning 3 TR Sıralama Sırası 3 Sıralama Sırası 3 US Sort Order 3 Sort Order 3 ZHS 排序 3 排序 3