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）限制的操作单元。 C6E085D471B151A9E05362FB09050512Y SELECT hre.full_name buyer , null C_FLEX_CAT , hrl.location_code location , poa.start_date_active start_date , poa.end_date_active end_date, 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 FROM po_agents poa , hr_locations hrl , hr_employees hre , mtl_categories mca WHERE poa.agent_id = hre.employee_id AND poa.category_id = mca.category_id (+) AND nvl(poa.location_id,-1) = hrl.location_id (+) AND nvl(hrl.location_code,'~') = decode(:P_location, null, nvl(hrl.location_code,'~'), :P_location) AND ((:P_active_inactive = 'BOTH') OR (:P_active_inactive = 'ACTIVE' AND sysdate >= nvl(poa.start_date_active,sysdate - 1) AND sysdate < nvl(poa.end_date_active,sysdate + 1)) OR (:P_active_inactive = 'INACTIVE' AND (sysdate < nvl(poa.start_date_active,sysdate - 1) OR sysdate >= nvl(poa.end_date_active,sysdate + 1)))) AND &P_WHERE_CAT --ORDER BY &orderby_clause ORDER BY &orderby_clause,hrl.location_code,poa.start_date_active,poa.end_date_active PO POXAGLST_XML AR PO قائمة المشترين (بتنسيق XML) Imported from BI Publisher Description: قائمة المشترين Application: المشتريات Source: قائمة المشترين (بتنسيق XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG D PO Einkäufer - Liste Imported from BI Publisher Description: Einkäufer - Liste Application: Einkauf Source: Einkäufer - Liste (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG E PO Listado de Compradores Imported from BI Publisher Description: Compradores Application: Purchasing Source: Listado de Compradores (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG F PO Liste des acheteurs Imported from BI Publisher Description: Liste des acheteurs Application: Purchasing Source: Liste des acheteurs (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG I PO Elenco buyer Imported from BI Publisher Description: Elenco buyer Application: Purchasing Source: Elenco buyer (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG JA PO 購買担当リスト Imported from BI Publisher Description: 購買担当リスト Application: Purchasing Source: 購買担当リスト(XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG KO PO 구매자 목록 Imported from BI Publisher Description: 구매자 목록 Application: Purchasing Source: 구매자 목록(XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG PTB PO Lista do Comprador Imported from BI Publisher Description: Lista do Comprador Application: Compra Source: Lista do Comprador (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG RU PO Список покупателей Imported from BI Publisher Description: Список покупателей Application: Закупки Source: Список покупателей (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG S PO Köpare - lista Imported from BI Publisher Description: Inköpare - lista Application: Purchasing Source: Köpare - lista (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG TR PO Satın Alan Listesi Imported from BI Publisher Description: Satın Alan Listesi Application: Satın Alma Yönetimi Source: Satın Alan Listesi (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG US PO Buyer Listing Imported from BI Publisher Description: Buyer Listing Application: Purchasing Source: Buyer Listing (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG ZHS PO 采购员列表 Imported from BI Publisher Description: 采购员列表 Application: 采购管理系统 Source: 采购员列表 (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG BI Publisher &orderby_clause &p_where_cat :lp_orderby_displayed :operating_unit :p_active_inactive :p_active_inactive_disp :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_location :p_orderby :p_orderby_cat :p_orderby_displayed :p_struct_num :p_title :p_where_cat 1 -20 :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 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 3 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 标题 标题 4 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 有效/无效 有效/无效 5 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 类别自 类别自 6 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 至 至 7 50 :p_location LOV Oracle PO_SRS_LOCATION Y select location_code id, location_code value, null description from hr_locations order by location_code AR الموقع الموقع D Standort Standort E Ubicación Ubicación F Lieu Lieu I Ubicazione Ubicazione JA 事業所 事業所 KO 위치 위치 PTB Local Local RU Расположение Расположение S Adress Adress TR Yerleşim Yerleşim US Location Location ZHS 地点 地点 8 60 :p_orderby LOV Oracle PO_SRS_POXAGLST_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('BUYER','CATEGORY','LOCATION') 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 排序依据 排序依据