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）限制的操作单元。 C6E085D471B451A9E05362FB09050512 SELECT null C_FLEX_ITEM , null C_FLEX_CAT , mtl.description Description , null C_FLEX_ACC , msi.qty_rcv_tolerance Receipt_Tolerance , decode(msi.allow_item_desc_update_flag,'Y',:yes,'N',:no,null) Allow_Item_Description_Update , mum.unit_of_measure Unit , msi.price_tolerance_percent Price_Tolerance , decode(msi.outside_operation_flag,'Y',:yes,'N',:no,null) Outside_Operation , decode(msi.stock_enabled_flag,'Y',:yes,'N',:no,null) Stock_Item , msi.invoice_close_tolerance Invoicing_Close_Tolerance , decode(msi.rfq_required_flag,'Y',:yes,'N',:no,null) RFQ_Required , decode(msi.taxable_flag,'Y',:yes,'N',:no,null) Taxable , msi.receive_close_tolerance Receiving_Close_Tolerance , decode(msi.inspection_required_flag,'Y',:yes,'N',:no,null) Inspection_Required , decode(msi.internal_order_enabled_flag,'Y',:yes,'N',:no,null) Internal_Order , plc2.displayed_field Tolerance_Level , decode(msi.allow_substitute_receipts_flag,'Y',:yes,'N',:no,null) Allow_Substitute_Receipts , decode(msi.inventory_asset_flag,'Y',:yes,'N',:no,null) Inventory_Asset , papf.full_name Buyer , decode(msi.allow_express_delivery_flag,'Y',:yes,'N',:no,null) AllowExpress_Delivery , plc1.displayed_field Days_Receipt_Exception , msi.days_early_receipt_allowed Days_Early_Receipt_Allowed , plc.displayed_field Enforce_Ship_To_Location , msi.list_price_per_unit List_Price , msi.days_late_receipt_allowed Days_Late_Receipt_Allowed , pun.un_number UN_Number , msi.market_price Market_Price , round(msi.fixed_order_quantity,:P_qty_precision) Reorder_Quantity , phc.hazard_class Hazard_Class &C_CST_SELECT , msi.rounding_factor Rounding_Factor , null C_FLEX_ASS , msi.receiving_routing_id Routing_Steps , rrh.routing_name Default_Routing , decode(msi.must_use_approved_vendor_flag,'Y',:yes,'N',:no,null) Use_Approved_Vendor , msi.outside_operation_uom_type Outside_Operation_Unit_Type , msi.unit_of_issue Unit_of_Issue , msi.inventory_item_id Parent_id , msi.expense_account Expense_id , msi.full_lead_time Processing_Time, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ACC_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_ass_disp', 'OFA', 'CAT#', 101, NULL, FAC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ASS_DISP FROM mtl_system_items msi , mtl_system_items_tl mtl , gl_code_combinations gcc , mtl_units_of_measure mum , po_un_numbers pun , po_hazard_classes phc , per_all_people_f papf , po_agents poa , rcv_routing_headers rrh &C_CST_FROM , &C_OFA_dynamic fac , mtl_categories mca , mtl_item_categories mic , po_lookup_codes plc , po_lookup_codes plc1 , po_lookup_codes plc2 where TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE(+) AND PAPF.EFFECTIVE_END_DATE(+) AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF.PERSON_ID(+), PAPF.PERSON_TYPE_ID(+), PAPF.EMPLOYEE_NUMBER(+),PAPF.APPLICANT_NUMBER(+) ,PAPF.NPW_NUMBER(+) )) = 'TRUE' AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF.BUSINESS_GROUP_ID (+), HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID(+) AND msi.expense_account = gcc.code_combination_id (+) &C_OFA_where AND mtl.inventory_item_id = msi.inventory_item_id AND mtl.organization_id = msi.organization_id AND mtl.language = userenv('LANG') AND msi.organization_id = :c_organization_id AND msi.primary_uom_code = mum.uom_code AND msi.buyer_id = poa.agent_id (+) AND poa.agent_id = papf.person_id(+) AND nvl(papf.full_name,'-1') = nvl(:P_buyer_name, nvl(papf.full_name,'-1')) AND msi.un_number_id = pun.un_number_id (+) AND msi.hazard_class_id = phc.hazard_class_id (+) AND msi.receiving_routing_id = rrh.routing_header_id (+) &C_CST_WHERE AND msi.inventory_item_id = mic.inventory_item_id AND mic.category_set_id = :c_category_set_id AND mic.organization_id = :c_organization_id AND mic.category_id = mca.category_id AND (msi.purchasing_item_flag = 'Y' OR msi.internal_order_flag = 'Y') AND ((:P_active_inactive = 'BOTH') OR (:P_active_inactive = 'ACTIVE' AND msi.purchasing_enabled_flag = 'Y') OR (:P_active_inactive = 'INACTIVE' AND msi.purchasing_enabled_flag = 'N')) AND &P_WHERE_CAT AND &P_WHERE_ITEM AND plc.lookup_type (+) = 'RECEIVING CONTROL LEVEL' AND plc.lookup_code (+) = msi.enforce_ship_to_location_code AND plc1.lookup_type (+) = 'RECEIVING CONTROL LEVEL' AND plc1.lookup_code (+) = msi.receipt_days_exception_code AND plc2.lookup_type (+) = 'RECEIVING CONTROL LEVEL' AND plc2.lookup_code (+) = msi.qty_rcv_exception_code ORDER BY &orderby_clause Y PO POXDETIT_XML AR PO قائمة تفاصيل الصنف (بتنسيق XML) Imported from BI Publisher Description: قائمة تفاصيل الصنف Application: المشتريات Source: قائمة تفاصيل الصنف (بتنسيق XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG D PO Artikel - Details Imported from BI Publisher Description: Artikel - Details Application: Einkauf Source: Artikel - Details (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG E PO Listado de Detalles de Artículos Imported from BI Publisher Description: Listado de detalles de artículos Application: Purchasing Source: Listado de Detalles de Artículos (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG F PO Liste détaillée des articles Imported from BI Publisher Description: Liste détaillée des articles Application: Purchasing Source: Liste détaillée des articles (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG I PO Elenco dettagli articolo Imported from BI Publisher Description: Elenco dettagli articolo Application: Purchasing Source: Elenco dettagli articolo (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG JA PO 品目詳細リスト Imported from BI Publisher Description: 品目詳細リスト Application: Purchasing Source: 品目詳細リスト(XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG KO PO 품목 상세내역 목록 Imported from BI Publisher Description: 품목 상세내역 목록 Application: Purchasing Source: 품목 상세내역 목록(XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG PTB PO Lista Detalhada de Itens Imported from BI Publisher Description: Lista Detalhada de Itens Application: Compra Source: Lista Detalhada de Itens (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG RU PO Подробный список позиций Imported from BI Publisher Description: Подробный список позиций Application: Закупки Source: Подробный список позиций (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG S PO Artikeldetaljer Imported from BI Publisher Description: Artikeldetaljer Application: Purchasing Source: Artikeldetaljer (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG TR PO Kalem Detayı Listesi Imported from BI Publisher Description: Kalem Detay Listesi Application: Satın Alma Yönetimi Source: Kalem Detayı Listesi (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG US PO Item Detail Listing Imported from BI Publisher Description: Item Detail Listing Application: Purchasing Source: Item Detail Listing (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG ZHS PO 物料明细列表 Imported from BI Publisher Description: 物料明细列表 Application: 采购管理系统 Source: 物料明细列表 (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG BI Publisher &c_cst_from &c_cst_select &c_cst_where &c_ofa_dynamic &c_ofa_where &orderby_clause &p_where_cat &p_where_item :c_category_set_id :c_organization_id :l_industry :l_oracle_schema :no :operating_unit :org_id :organization_id :p_acat_struct_num :p_act_inact_disp :p_active_inactive :p_ass_struct_num :p_buyer_name :p_category_from :p_category_to :p_chart_of_accounts_id :p_conc_request_id :p_cst_status :p_fa_installed :p_flex_acc :p_flex_ass :p_flex_cat :p_flex_item :p_item_cross_ref :p_item_from :p_item_struct_num :p_item_to :p_ofa_status :p_orderby :p_orderby_cat :p_orderby_item :p_qty_precision :p_struct_num :p_title :p_where_cat :p_where_item :yes 1 -30 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR P_STRUCT_NUM رقم الهيكل D P_STRUCT_NUM Strukturnummer E P_STRUCT_NUM Número de Estructura F P_STRUCT_NUM Numéro de structure I P_STRUCT_NUM Numero struttura JA P_STRUCT_NUM 体系番号 KO P_STRUCT_NUM 구조번호 PTB P_STRUCT_NUM Número da estrutura RU P_STRUCT_NUM Номер структуры S P_STRUCT_NUM Strukturnummer TR P_STRUCT_NUM Yapı Numarası US P_STRUCT_NUM Structure number ZHS P_STRUCT_NUM 结构编号 2 -20 :p_item_cross_ref Char fnd_profile.value('PO_ITEM_REFERENCE_WARNING') AR الإسناد المتقاطع لصنف الإسناد المتقاطع لصنف D Artikel-Querverweise Artikel-Querverweise E Referencia Cruzada del Artículo Referencia Cruzada del Artículo F Référence croisée article Références croisées article I Riferimenti incrociati articoli Riferimenti incrociati articoli JA 品目相互参照 品目相互参照 KO 품목 상호참조 품목 상호참조 PTB Referência Cruzada do Item Referências Cruzadas do Item RU Перекрестная ссылка позиции Перекрестные ссылки позиций S Korsreferenser för artiklar Korsreferenser för artiklar TR Kalem Kros Referansı Kalem Kros Referansları US Item Cross Reference Item Cross References 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_title Char AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 5 20 :p_active_inactive LOV Oracle PO_SRS_ACTIVE_OPTIONS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='ACTIVE_INACTIVE' order by displayed_field Y AR ساري/غير ساري ساري/غير ساري D Gültig/Ungültig Gültig/Ungültig E Activo/Inactivo Activo/Inactivo F Activé/Désactivé Activé/Désactivé I Attivo/inattivo Attivo/inattivo JA 有効/無効 有効/無効 KO 유효/무효 유효/무효 PTB Ativos/Inativos Ativos/Inativos RU Активность Активность S Aktiv/inaktiv Aktiv/inaktiv TR Etkin/Etkin Olmayan Etkin/Etkin Olmayan US Active/Inactive Active/Inactive ZHS 有效/无效 有效/无效 6 30 :p_category_from Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 7 40 :p_category_to Char AR إلى إلى D Bis Bis E A A F A A I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 8 50 :p_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 9 60 :p_item_to Char AR إلى 2 الأصناف إلى D Bis 2 Bis Artikel E A 2 A Artículo F A 2 Articles - A I A 2 Articoli - A JA 至 2 品目:至 KO 까지 2 품목: 까지 PTB Até 2 Itens - Até RU По 2 Позиции по S Till 2 Till artiklar TR Son 2 Kalemler, Son US To 2 Items To ZHS 至 2 物料至 10 70 :p_buyer LOV Oracle PO_SRS_BUYER_NAME_NUM Y select buyer_id id, buyer_info value, null description from po_buyer_name_num_v order by buyer_info AR اسم المشتري، رقم الموظف اسم المشتري، رقم الموظف (تمرير المعرف) D Einkäufer, Personalnummer Einkäufer, Personalnummer (Kennung) E Nombre de Comprador, Número de Empleado Nombre de Comprador, Número de Empleado (Id Transferencia) F Nom de l'acheteur, matricule de l'employé Nom de l'acheteur, matricule de l'employé (transmet l'ID) I Nome buyer, numero dipendente Nome buyer, numero dipendente (ID passante) JA 購買担当名、従業員番号 購買担当名、従業員番号(パスID) KO 구매자명, 사원 번호 구매자명, 사원 번호 (통과 ID) PTB Nome do Comprador, Número do Funcionário Nome do Comprador, Número do Funcionário (ID de aprovação) RU Имя покупателя, номер работника Имя покупателя, номер работника (передается идентификатор) S Namn på inköpare, anställningsnummer Namn på inköpare, anställningsnummer (godkänt id) TR Satın Alan Adı, Çalışan Numarası Satın Alan Adı, Çalışan Numarası (iletim No) US Buyer Name, Employee Number Buyer Name, Employee Number (passing ID) ZHS 采购员姓名；员工编号 采购员姓名；员工编号（通行标识） 11 80 :p_buyer_name LOV Oracle PO_SRS_BUYER_NAME Y select hre.full_name id, hre.full_name value, null description from po_agents poa,hr_employees hre where poa.agent_id=hre.employee_id order by full_name AR المشتري المشتري D Einkäufer Einkäufer E Comprador Comprador F Acheteur Acheteur JA 購買担当 購買担当 KO 구매자 구매자 PTB Comprador Comprador RU Покупатель Покупатель S Köpare Köpare TR Alıcı Alıcı US Buyer Buyer ZHS 采购员 采购员 12 90 :p_orderby LOV Oracle PO_SRS_ITEM_LISTING_SORTS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('ITEM','CATEGORY') order by displayed_field 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 Esası Sıralama Esası US Sort By Sort By ZHS 排序依据 排序依据 13 100 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR خيار الدقة الديناميكية دقة الكمية D Option Nachkommastellen Nachkommastellen E Opción Precisión Dinámica Precisión de Cantidad F Option précision dynamique Précision des quantités I Opzione precisione dinamica Precisione quantità JA 動的演算精度オプション 数量精度 KO 동적 소수점자리 옵션 수량 소수점 이하 자릿수 PTB Opção de Precisão Dinâmica Precisão da Quantidade RU Динамическая точность Точность количества S Alternativ för dynamisk precision Kvantitetsprecision TR Dinamik Duyarlılık Seçeneği Miktar Duyarlılığı US Dynamic Precision Option Quantity Precision ZHS 动态精确度选项 数量精确度