ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) 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')) order by hou.name US C6DDA75BBDE4F0F4E0530100007FA413 select haouv.name operating_unit, ottt.name transaction_type_name, ottt.description, otta.start_date_active, otta.end_date_active, xxen_util.meaning(otta.transaction_type_code,'TRANSACTION_TYPE',660) transaction_type, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) order_category, xxen_util.meaning(otta.agreement_type_code,'AGREEMENT_TYPE',660) agreement_type, ottt1.name default_inbound_line_type, ottt2.name default_outbound_line_type, xxen_util.meaning(otta.agreement_required_flag,'YES_NO',0) agreement_required_flag, xxen_util.meaning(otta.po_required_flag,'YES_NO',0) po_required_flag, oplv.name price_list, xxen_util.meaning(otta.enforce_line_prices_flag,'YES_NO',0) enforce_line_prices_flag, occr1.name entry_credit_check_rule, occr2.name shipping_credit_check_rule, ood.organization_name warehouse, orf.description shipping_method, xxen_util.meaning(otta.shipment_priority_code,'SHIPMENT_PRIORITY',660) shipment_priority, xxen_util.meaning(otta.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, xxen_util.meaning(otta.fob_point_code,'FOB',222) fob, xxen_util.meaning(otta.ship_source_type_code,'SHIPMENT SOURCE TYPE',201) shipment_source_type, xxen_util.meaning(otta.demand_class_code,'DEMAND_CLASS',3) demand_class, xxen_util.meaning(otta.scheduling_level_code,'SCHEDULING_LEVEL',660) scheduling_level, otta.depot_repair_code, rr1.name invoicing_rule, rr2.name accounting_rule, rbs1.name invoicing_source, rbs2.name non_delivery_invoice_source, otta.accounting_credit_method_code, otta.invoicing_credit_method_code, rctt.name receivables_transaction_type, otta.cost_of_goods_sold_account, fcv.name currency_code, gdct.user_conversion_type, xxen_util.meaning(otta.auto_scheduling_flag,'YES_NO',0) auto_scheduling_flag, xxen_util.meaning(otta.inspection_required_flag,'YES_NO',0) inspection_required_flag, gcck.concatenated_segments cogs_account, xxen_util.segments_description(otta.cost_of_goods_sold_account) cogs_description, xxen_util.user_name(otta.created_by) created_by, xxen_util.client_time(otta.creation_date) creation_date, xxen_util.user_name(otta.last_updated_by) last_updated_by, xxen_util.client_time(otta.last_update_date) last_update_date, otta.org_id, otta.transaction_type_id from hr_all_organization_units_vl haouv, oe_transaction_types_all otta, oe_transaction_types_tl ottt, oe_transaction_types_tl ottt1, oe_transaction_types_tl ottt2, oe_price_lists_v oplv, oe_credit_check_rules occr1, oe_credit_check_rules occr2, org_organization_definitions ood, org_freight orf, ra_rules rr1, ra_rules rr2, ra_batch_sources rbs1, ra_batch_sources rbs2, ra_cust_trx_types rctt, fnd_currencies_vl fcv, gl_daily_conversion_types gdct, gl_code_combinations_kfv gcck where 1=1 and haouv.organization_id=otta.org_id and otta.transaction_type_id=ottt.transaction_type_id and otta.default_inbound_line_type_id=ottt1.transaction_type_id(+) and otta.default_outbound_line_type_id=ottt2.transaction_type_id(+) and ottt.language=userenv('lang') and ottt1.language(+)=userenv('lang') and ottt2.language(+)=userenv('lang') and otta.price_list_id=oplv.price_list_id(+) and otta.entry_credit_check_rule_id=occr1.credit_check_rule_id(+) and otta.shipping_credit_check_rule_id=occr2.credit_check_rule_id(+) and otta.warehouse_id=ood.organization_id(+) and otta.shipping_method_code=orf.freight_code(+) and otta.org_id=orf.organization_id(+) and otta.invoicing_rule_id=rr1.rule_id(+) and otta.accounting_rule_id=rr2.rule_id(+) and otta.invoice_source_id=rbs1.batch_source_id(+) and otta.non_delivery_invoice_source_id=rbs2.batch_source_id(+) and otta.cust_trx_type_id=rctt.cust_trx_type_id(+) and otta.currency_code=fcv.currency_code(+) and otta.conversion_type_code=gdct.conversion_type(+) and otta.cost_of_goods_sold_account=gcck.code_combination_id(+) and otta.org_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 haouv.name, ottt.name Fixed bug in operating unit access restriction when the default operating unit is set to something else Y ONT AR ONT تقرير قائمة أنواع الحركات Imported from BI Publisher Description: تقرير قائمة أنواع الحركات Application: إدارة الطلبات Source: تقرير قائمة أنواع الحركات (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG D ONT Transaktionsarten - Liste Imported from BI Publisher Description: Transaktionsarten - Liste Application: Order Management Source: Transaktionsarten - Liste (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG E ONT Informe Listado de Tipos de Transacciones Imported from BI Publisher Description: Informe Listado de Tipos de Transacciones Application: Order Management Source: Informe Listado de Tipos de Transacciones (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG F ONT Etat Liste des types de mouvement Imported from BI Publisher Description: Etat Liste des types de mouvement Application: Order Management Source: Etat Liste des types de mouvement (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG I ONT Rapporto Elenco tipi di transazione Imported from BI Publisher Description: Rapporto relativo all'elenco dei tipi di transazione Application: Order Management Source: Rapporto Elenco tipi di transazione (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG JA ONT 取引タイプ・リスティング・レポート Imported from BI Publisher Description: 取引タイプ・リスティング・レポート Application: Order Management Source: 取引タイプ・リスティング・レポート(XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG KO ONT 트랜잭션 유형 목록 보고서 Imported from BI Publisher Description: 트랜잭션 유형 목록 보고서 Application: Order Management Source: 트랜잭션 유형 목록 보고서(XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG PTB ONT Relatório de Lista dos Tipos de Transação Imported from BI Publisher Description: Relatório de Lista dos Tipos de Transação Application: Gerenciamento de Ordens Source: Relatório de Lista dos Tipos de Transação (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG RU ONT Список типов транзакций Imported from BI Publisher Description: Список типов транзакций Application: Управление заказами Source: Список типов транзакций (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG S ONT Transaktionstyper - listrapport Imported from BI Publisher Description: Transaktionstyper - listrapport Application: Order Management Source: Transaktionstyper - listrapport (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG TR ONT İşlem tipleri Listesi Raporu Imported from BI Publisher Description: İşlem tipleri Listesi Raporu Application: Sipariş Yönetimi(1) Source: İşlem tipleri Listesi Raporu (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG US ONT Transaction Types Listing Imported Oracle standard Order Management transaction types listing, enhanced to show the setup across all operating units Description: Transaction Types Listing Report Application: Order Management Source: Transaction Types Listing Report (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG ZHS ONT 事务处理类型列表报表 Imported from BI Publisher Description: 事务处理类型列表报表 Application: 订单管理 Source: 事务处理类型列表报表 (XML) Short Name: OEXORDTP_XML DB package: ONT_OEXORDTP_XMLP_PKG BI Publisher Enginatics 1=1 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 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')) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) F Unité d'exploitation US Operating Unit 2 20 1=1 otta.transaction_type_code=:trx_type_code LOV Oracle ONT_SRS_TRANSACTION_CODE Y select lookup_code id, meaning value, description description from oe_lookups where lookup_type='TRANSACTION_TYPE' order by meaning AR رمز نوع الحركة رمز نوع الحركة D Schlüssel Transaktionsart Schlüssel Transaktionsart E Código de Tipo de Transacción Código de Tipo de Transacción F Code du type de transaction Code type de mouvement I Codice tipo di transazione Codice tipo di transazione JA 取引タイプ・コード 取引タイプ・コード KO 트랜잭션 유형 코드 트랜잭션 유형 코드 PTB Código do Tipo de Transação Código do Tipo de Transação RU Код типа транзакции Код типа транзакции S Transaktionstypskod Transaktionstypskod TR İşlem Tip Kodu İşlem Tip Kodu US Transaction Type Code Transaction Type Code ZHS 事务处理类型代码 事务处理类型代码 3 30 1=1 otta.order_category_code='RETURN' 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 CREDIT AR رمز فئة الطلب رمز فئة الطلب D Schlüssel Auftragskategorie Schlüssel Auftragskategorie E Código de Categoría de Pedido Código de Categoría de Pedido F Code de la catégorie de commande Code catégorie de commande I Codice categoria ordine Codice categoria ordine JA 受注カテゴリ・コード 受注カテゴリ・コード KO 주문 범주 코드 주문 범주 코드 PTB Código da Categoria da Ordem Código da Categoria da Ordem RU Код категории заказа Код категории заказа S Orderkategorikod Orderkategorikod TR Sipariş Kategori Kodu Sipariş Kategori Kodu US Order Category Code Order Category Code ZHS 订单类别代码 订单类别代码 4 1=1 otta.order_category_code='ORDER' SALES F Code de la catégorie de commande US Order Category Code