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）限制的操作单元。 C6E085D471B951A9E05362FB09050512Y SELECT min(poh.segment1) PO_Number , min(apt.name) Terms , min(poh.blanket_total_amount) C_AMOUNT_AGR , min(poh.type_lookup_code) po_type , min(papf.full_name) Buyer , min(poh.start_date) Effective_Date , min(poh.amount_limit) C_AMOUNT_LIM , min(pov.vendor_name) Vendor , min(poh.end_date) Expiration_date , min(pvs.vendor_site_code) Vendor_Site , min(decode(poh.cancel_flag,'Y',:yes,'N',:no,null)) Cancelled , min(T.type_name) Type , min(poh.global_agreement_flag) global_agreement_flag , min(plc1.displayed_field) Approved , min(poh.currency_code) C_CURRENCY , min(poh.po_header_id) po_header_id , min(decode(psp1.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null)) , min(decode(psp1.manual_po_num_type,'NUMERIC', null, poh.segment1)), PO_POXPOBPS_XMLP_PKG.c_amount_rem(min ( poh.po_header_id )) C_AMOUNT_REM, PO_POXPOBPS_XMLP_PKG.c_amount_rel(min ( poh.po_header_id )) C_AMOUNT_REL, PO_POXPOBPS_XMLP_PKG.cur_planned_amt_agreed(min ( poh.type_lookup_code ), min ( poh.po_header_id )) C_planned_po_amt_agreed, PO_POXPOBPS_XMLP_PKG.cur_planned_amt_released(min ( poh.type_lookup_code ), min ( poh.po_header_id )) C_planned_po_amt_released FROM po_line_locations pll , po_headers poh , po_vendor_sites pvs , po_vendors pov , per_all_people_f papf , po_lookup_codes plc1 , ap_terms apt , po_system_parameters_all psp1 , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE PAPF.BUSINESS_GROUP_ID = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) FROM FINANCIALS_SYSTEM_PARAMETERS FSP) 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 = poh.ORG_ID AND T.LANGUAGE = USERENV('LANG') AND poh.type_lookup_code in ( 'BLANKET','PLANNED') AND poh.type_lookup_code = B.document_subtype AND B.document_type_code in ('PA', 'PO') AND poh.vendor_site_id = pvs.vendor_site_id(+) AND poh.terms_id = apt.term_id(+) AND poh.agent_id = papf.person_id AND poh.vendor_id = pov.vendor_id(+) AND poh.po_header_id = pll.po_header_id(+) AND plc1.lookup_type = 'DOCUMENT STATE' AND plc1.lookup_code = nvl(poh.authorization_status,'INCOMPLETE') AND ((decode(psp1.manual_po_num_type, 'NUMERIC',decode(ltrim(poh.segment1,'1234567890'), null,poh.segment1, null), null) BETWEEN decode(psp1.manual_po_num_type,'NUMERIC', to_number(nvl(:P_po_num_from,poh.segment1)),null) AND decode(psp1.manual_po_num_type,'NUMERIC', to_number(nvl(:P_po_num_to,poh.segment1)),null)) OR (poh.segment1 BETWEEN decode(psp1.manual_po_num_type,'ALPHANUMERIC', nvl(:P_po_num_from,poh.segment1),null) AND decode(psp1.manual_po_num_type,'ALPHANUMERIC', nvl(:P_po_num_to,poh.segment1),null))) AND psp1.ORG_ID = poh.ORG_ID AND papf.full_name = nvl(:P_buyer, papf.full_name) AND nvl(pov.vendor_name,'A') between nvl(:P_vendor_from, nvl(pov.vendor_name,'A')) and nvl(:P_vendor_to, nvl(pov.vendor_name,'A')) AND (poh.end_date <= :P_expiration_date OR :P_expiration_date is null) AND (:P_CATEGORY_FROM is null OR (EXISTS (SELECT 'Lines with correct items' FROM po_lines pol , mtl_categories mca WHERE poh.po_header_id = pol.po_header_id AND pol.category_id = mca.category_id AND &P_WHERE_CAT ))) GROUP BY pll.po_header_id , decode(psp1.manual_po_num_type, 'NUMERIC', null, poh.segment1) , decode(psp1.manual_po_num_type, 'NUMERIC', to_number(poh.segment1), null) , pov.vendor_name ORDER BY &orderby_clause PO POXPOBPS_XML AR PO تقرير موقف أمر الشراء العام والمخطط (بتنسيق XML) Imported from BI Publisher Description: تقرير موقف أمر الشراء العام والمخطط Application: المشتريات Source: تقرير موقف أمر الشراء العام والمخطط (بتنسيق XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG D PO Bestellungen - Rahmenvertragsstatus Imported from BI Publisher Description: Bestellungen - Rahmenvertragsstatus Application: Einkauf Source: Bestellungen - Rahmenvertragsstatus (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG E PO Informe Estado de Pedidos Abiertos y Planificados Imported from BI Publisher Description: Informe Estado de Pedidos de Compra Abiertos y Planificados Application: Purchasing Source: Informe Estado de Pedidos Abiertos y Planificados (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG F PO Statut des commandes ouvertes et planifiées Imported from BI Publisher Description: Statut des commandes ouvertes et planifiées Application: Purchasing Source: Statut des commandes ouvertes et planifiées (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG I PO Rapporto Stato OA aperto e pianificato Imported from BI Publisher Description: Rapporto Stato OA aperto e pianificato Application: Purchasing Source: Rapporto Stato OA aperto e pianificato (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG JA PO 包括および計画発注ステータス・レポート Imported from BI Publisher Description: 包括および計画発注ステータス・レポート Application: Purchasing Source: 包括および計画発注ステータス・レポート(XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG KO PO 총괄 및 계획 PO 상태 보고서 Imported from BI Publisher Description: 총괄 및 계획 PO 상태 보고서 Application: Purchasing Source: 총괄 및 계획 PO 상태 보고서(XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG PTB PO Relatório de Status da OC em Aberto ou Planejada Imported from BI Publisher Description: Relatório de Status da OC em Aberto ou Planejada Application: Compra Source: Relatório de Status da OC em Aberto ou Planejada (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG RU PO Отчет о статусе общих и плановых ЗП Imported from BI Publisher Description: Отчет о статусе общих и плановых ЗП Application: Закупки Source: Отчет о статусе общих и плановых ЗП (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG S PO Status för avropsorder och planerade inköpsorder - rapport Imported from BI Publisher Description: Status för avropsorder och planerade inköpsorder - rapport Application: Purchasing Source: Status för avropsorder och planerade inköpsorder - rapport (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG TR PO Çerçeve ve Planlı SS Statü Raporu Imported from BI Publisher Description: Çerçeve ve Planlı SS Statü Raporu Application: Satın Alma Yönetimi Source: Çerçeve ve Planlı SS Statü Raporu (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG US PO Blanket and Planned PO Status Imported from BI Publisher Description: Blanket and Planned PO Status Report Application: Purchasing Source: Blanket and Planned PO Status Report (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG ZHS PO 一揽子 PO 和计划 PO 状态报表 Imported from BI Publisher Description: 一揽子 PO 和计划 PO 状态报表 Application: 采购管理系统 Source: 一揽子 PO 和计划 PO 状态报表 (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG BI Publisher &orderby_clause &p_where_cat :no :operating_unit :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_expiration_date :p_flex_cat :p_flex_item :p_item_struct_num :p_orderby :p_orderby_displayed :p_po_num_from :p_po_num_to :p_qty_precision :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat :qty_precision :yes 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_po_num_from LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR أرقام أوامر الشراء من أرقام أوامر الشراء من D Von Bestellnummer Von Bestellnummer E De Número de Pedido De Número de Pedido F Numéros de commande - De Numéros de commande - De I Numeri OA - Da Numeri OA - Da JA 発注番号:自 発注番号:自 KO PO 번호-부터: PO 번호-부터: PTB Números de OC - De Números de OC - De RU Номера ЗП с Номера ЗП с S Från IO-nummer Från IO-nummer TR SS Numaraları, İlk SS Numaraları, İlk US PO Numbers From PO Numbers From ZHS PO 编号自 PO 编号自 5 30 :p_po_num_to LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR إلى أرقام أوامر الشراء إلى D Bis Bis Bestellnummer E A A Número de Pedido F A Numéros de commande - A I A Numeri OA - A JA 至 発注番号:至 KO 까지 PO 번호: 까지 PTB Até Números de OC - Até RU По Номера ЗП по S Till IO-nummer till TR Son SS Numaraları: Son US To PO Numbers To ZHS 至 PO 编号至 6 40 :p_buyer 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äufername Einkäufername E Nombre de Comprador Nombre de Comprador F Nom de l'acheteur Nom de l'acheteur I Nome buyer Nome buyer JA 購買担当名 購買担当名 KO 구매자명 구매자명 PTB Nome do Comprador Nome do Comprador RU Имя покупателя Имя покупателя S Köpare Köpare TR Satın Alan Adı Satın Alan Adı US Buyer Name Buyer Name ZHS 采购员姓名 采购员姓名 7 50 :p_vendor_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR الموردون من الموردون D Von Lieferant Lieferanten E De Proveedor Proveedores F Fournisseurs - De Fournisseurs I Fornitori - Da Fornitori JA 仕入先:自 仕入先 KO 공급자: 부터 공급자 PTB Fornecedores - De Fornecedores RU Поставщики с Поставщики S Från leverantörer Leverantörer TR Tedarikçiler, İlk Tedarikçiler US Vendors From Vendors ZHS 供应商自 供应商 8 60 :p_vendor_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR إلى 2 إلى D Bis 2 Bis E A 2 A F A 2 A I A 2 A JA 至 2 至 KO 까지 2 까지 PTB Até 2 Até RU По 2 По S Till 2 Till TR Son 2 Son US To 2 To ZHS 至 2 至 9 70 :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 类别自 类别自 10 80 :p_category_to Char AR إلى 3 إلى D Bis 3 Bis E A 3 A F A 3 A I A 3 A JA 至 3 至 KO 까지 3 까지 PTB Até 3 Até RU По 3 По S Till 3 Till TR Son 3 Son US To 3 To ZHS 至 3 至 11 90 :p_expiration_date Date AR تاريخ انتهاء صلاحية تاريخ انتهاء صلاحية D Gültig bis Gültig bis E Fecha Caducada Fecha Caducada F Date d'expiration Date d'expiration I Scadenza Scadenza JA 失効日 失効日 KO 만기 일자 만기 일자 PTB Data de Expiração Data de Expiração RU Окончание срока действия Окончание срока действия S Giltig till Giltig till TR Geçerlilik Sonu Tarihi Geçerlilik Sonu Tarihi US Expired Date Expired Date ZHS 过期日 过期日 12 100 :p_orderby LOV Oracle PO_SRS_POXPOBPS_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 ('VENDOR','PO NUMBER') 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 110 :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 动态精确度选项 数量精确度