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）限制的操作单元。 C6E085D471C751A9E05362FB09050512Y SELECT distinct prxl.sequence_num Sequence , null C_FLEX_ITEM , null C_FLEX_CAT , prxl.item_revision Rev , prxl.unit_meas_lookup_code Unit , prxl.unit_price Unit_Price , decode(prxl.source_type_code, 'INVENTORY',(decode(nvl(ood.organization_name,'A') ,'A',ood.organization_name ,ood.organization_name||', ')|| decode(nvl(prxl.source_subinventory,'') ,'',prxl.source_subinventory ,prxl.source_subinventory)) ,'VENDOR' ,(decode(nvl(pov.vendor_name,'') ,'',pov.vendor_name ,pov.vendor_name||', '|| decode(nvl(pvs.vendor_site_code,'') ,'',pvs.vendor_site_code ,pvs.vendor_site_code||', '|| decode(nvl(pvc.first_name,'') ,'',pvc.first_name ,pvc.first_name||', '|| decode(nvl(papf.first_name,'') ,'',papf.first_name ,papf.first_name)))))) Source , prxl.express_name Express_Name , t.type_name Requisition_Type , polc.displayed_field Source_Type , prxl.item_description Item_Description, 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_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP FROM mtl_system_items msi , mtl_categories mca , po_vendors pov , po_vendor_sites pvs , po_vendor_contacts pvc , PER_ALL_PEOPLE_F PAPF , po_reqexpress_lines prxl , po_reqexpress_headers prxh , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B , po_lookup_codes polc , org_organization_definitions ood WHERE prxl.item_id = msi.inventory_item_id (+) AND prxl.suggested_vendor_id = pov.vendor_id (+) AND prxl.suggested_vendor_site_id = pvs.vendor_site_id (+) AND prxl.suggested_vendor_contact_id = pvc.vendor_contact_id (+) AND prxl.suggested_buyer_id = papf.person_id (+) AND prxl.category_id = mca.category_id AND prxl.express_name = prxh.express_name AND B.document_type_code = 'REQUISITION' AND B.document_subtype = prxh.type_lookup_code AND polc.lookup_type = 'REQUISITION SOURCE TYPE' AND polc.lookup_code = prxl.source_type_code AND prxl.express_name = decode(:P_EXPRESS_NAME,'', prxl.express_name, :P_EXPRESS_NAME) AND prxl.source_organization_id = ood.organization_id (+) AND 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 B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prxh.ORG_ID AND T.LANGUAGE = USERENV('LANG') and prxl.express_name=:Express_Name_header ORDER BY prxl.express_name , 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') , 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') , prxl.sequence_num PO POXRQEXP_XML AR PO قائمة قالب طلبات الشراء العاجل (بتنسيق XML) Imported from BI Publisher Description: قائمة قالب طلبات الشراء العاجل Application: المشتريات Source: قائمة قالب طلبات الشراء العاجل (بتنسيق XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG D PO Anforderungen - Schemas für schnelle Anforderungseingabe Imported from BI Publisher Description: Anforderungen - Schemas für schnelle Eingabe Application: Einkauf Source: Anforderungen - Schemas für schnelle Anforderungseingabe (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG E PO Listado de Plantillas de Solicitudes Simplificadas Imported from BI Publisher Description: Listado de Plantillas de Solicitudes Simplificadas Application: Purchasing Source: Listado de Plantillas de Solicitudes Simplificadas (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG F PO Liste des modèles de D.A. express Imported from BI Publisher Description: Liste des modèles de D.I. express Application: Purchasing Source: Liste des modèles de D.A. express (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG I PO Elenco modelli richieste rapide Imported from BI Publisher Description: Elenco modelli richieste semplificate Application: Purchasing Source: Elenco modelli richieste rapide (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG JA PO 購買依頼簡易入力テンプレート・リスト Imported from BI Publisher Description: 購買依頼簡易入力テンプレート・リスト Application: Purchasing Source: 購買依頼簡易入力テンプレート・リスト(XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG KO PO 구매요청 신속 템플리트 목록 Imported from BI Publisher Description: 구매요청 신속 템플리트 목록 Application: Purchasing Source: 구매요청 신속 템플리트 목록(XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG PTB PO Lista de Modelos de Requisição Expressa Imported from BI Publisher Description: Lista de Modelos de Req. Expressa Application: Compra Source: Lista de Modelos de Requisição Expressa (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG RU PO Список шаблонов экспресс-заявок Imported from BI Publisher Description: Список шаблонов экспресс-заявок Application: Закупки Source: Список шаблонов экспресс-заявок (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG S PO Mallar för standardrekv. - lista Imported from BI Publisher Description: Mall för ReqExpress - lista Application: Purchasing Source: Mallar för standardrekv. - lista (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG TR PO Ekspres Talep Şablonları Listesi Imported from BI Publisher Description: ReqExpress Şablon Listesi Application: Satın Alma Yönetimi Source: Ekspres Talep Şablonları Listesi (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG US PO ReqExpress Templates Listing Imported from BI Publisher Description: ReqExpress Template Listing Application: Purchasing Source: ReqExpress Templates Listing (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG ZHS PO 快速申请模板列表 Imported from BI Publisher Description: 快速申请模板列表 Application: 采购管理系统 Source: 快速申请模板列表 (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG BI Publisher :express_name_header :operating_unit :p_conc_request_id :p_express_name :p_flex_cat :p_flex_item :p_item_struct_num :p_struct_num :p_title 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 Kategoriestruktur P_STRUCT_NUM E Estructura de Categoría P_STRUCT_NUM F Structure de catégorie P_STRUCT_NUM I Struttura categoria P_STRUCT_NUM JA カテゴリ体系 P_STRUCT_NUM KO 범주 구조 P_STRUCT_NUM PTB Estrutura da Categoria P_STRUCT_NUM RU Структура категорий P_STRUCT_NUM S Kategoristruktur P_STRUCT_NUM TR Kategori Yapısı P_STRUCT_NUM US Category Structure P_STRUCT_NUM 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_express_name LOV Oracle PO_SRS_EXPRESS_NAME Y select express_name id, express_name value, null description from po_reqexpress_headers order by express_name AR اسم عاجل اسم عاجل D Schema Schema E Nombre Nombre F Demande d'approvisionnement express Demande d'approvisionnement express I Nome Express Nome Express JA 簡易名 簡易名 KO 신속 이름 신속 이름 PTB Nome Expresso Nome Expresso RU Имя шаблона Имя шаблона S Expressnamn Expressnamn TR Ekspress Adı Ekspress Adı US Express Name Express Name ZHS 快件名称 快件名称