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）限制的操作单元。 C6E085D471BD51A9E05362FB09050512Y SELECT poh.segment1 PO_Number , poh.creation_date Creation_Date , plc_sta.displayed_field || decode(poh.cancel_flag, 'Y',', '||plc_can.displayed_field,NULL) || decode(nvl(poh.closed_code, 'OPEN'), 'OPEN', NULL, ', '||plc_clo.displayed_field) || decode(poh.frozen_flag, 'Y',', '||plc_fro.displayed_field,NULL) || decode(poh.user_hold_flag, 'Y', ', '||plc_hld.displayed_field, NULL) Status , poh.revision_num Rev , poh.printed_date Printed_Date , pdt.type_name Type , ppf.full_name Buyer , poh.revised_date Revised_Date , poh.currency_code C_CURRENCY , pov.vendor_name Vendor , poh.acceptance_due_date Acceptance_Date , decode(poh.user_hold_flag,'Y',:yes,'N',:no,null) On_Hold , pvs.vendor_site_code Vendor_Site , decode(poh.acceptance_required_flag, 'Y',:yes, 'N',:no,null) Acceptance_Required , SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), PLL.price_override * (PLL.quantity - NVL(PLL.quantity_cancelled, 0)))) C_AMOUNT_AGR , poh.po_header_id , fc.precision c_fnd_precision, SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , PO_POXPOSTD_XMLP_PKG.c_amount_agr_round( PLL.amount - NVL ( PLL.amount_cancelled , 0 ), fc.precision ), 'FIXED PRICE' , PO_POXPOSTD_XMLP_PKG.c_amount_agr_round( PLL.amount - NVL ( PLL.amount_cancelled , 0 ), fc.precision ), PO_POXPOSTD_XMLP_PKG.c_amount_agr_round( PLL.price_override * ( PLL.quantity - NVL ( PLL.quantity_cancelled , 0 ) ), fc.precision ) ) ) C_AMOUNT_AGR_ROUND FROM po_line_locations pll , fnd_currencies fc , po_headers poh , po_lines POL , po_vendors pov , po_vendor_sites pvs , per_people_f ppf , po_system_parameters psp , po_lookup_codes plc_sta , po_lookup_codes plc_can , po_lookup_codes plc_clo , po_lookup_codes plc_fro , po_lookup_codes plc_hld , po_document_types pdt WHERE poh.vendor_id = pov.vendor_id (+) AND poh.currency_code = fc.currency_code AND pdt.document_type_code = 'PO' AND pdt.document_subtype = poh.type_lookup_code AND plc_sta.lookup_code = nvl(poh.authorization_status, 'INCOMPLETE') AND POL.po_header_id (+) = POH.po_header_id AND PLL.po_line_id (+) = POL.po_line_id AND nvl(pll.shipment_type,'STANDARD') in ('STANDARD', 'PLANNED') AND poh.agent_id = ppf.person_id AND poh.vendor_site_id = pvs.vendor_site_id(+) AND poh.type_lookup_code in ('STANDARD','PLANNED') AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND plc_sta.lookup_type in ('PO APPROVAL','DOCUMENT STATE') AND plc_can.lookup_code = 'CANCELLED' AND plc_can.lookup_type = 'DOCUMENT STATE' AND plc_clo.lookup_code = nvl(poh.closed_code,'OPEN') AND plc_clo.lookup_type = 'DOCUMENT STATE' AND plc_fro.lookup_code = 'FROZEN' AND plc_fro.lookup_type = 'DOCUMENT STATE' AND plc_hld.lookup_code = 'ON HOLD' AND plc_hld.lookup_type = 'DOCUMENT STATE' AND (:P_status is NULL OR :P_status = nvl(poh.authorization_status,'INCOMPLETE') OR (:P_status = 'RESERVED' AND EXISTS ( select 'do we have uncancelled/not_f_closed shipments' FROM PO_LINE_LOCATIONS POLL1 WHERE POLL1.po_header_id = poh.po_header_id AND nvl(POLL1.cancel_flag, 'N') = 'N' AND nvl(POLL1.closed_code, 'OPEN') != 'FINALLY CLOSED' ) AND NOT EXISTS ( SELECT 'Do we have uncancelled/not f_closed shipments' FROM PO_LINE_LOCATIONS POLL2 WHERE POLL2.po_header_id = poh.po_header_id AND nvl(POLL2.encumbered_flag, 'N') = 'N' AND POLL2.shipment_type in ('STANDARD', 'PLANNED') AND nvl(POLL2.cancel_flag, 'N') != 'Y' AND nvl(POLL2.closed_code, 'OPEN') != 'FINALLY CLOSED'))) AND (:P_buyer is NULL OR :P_buyer = ppf.person_id) AND (:P_vendor_from is NULL OR pov.vendor_name >= :P_vendor_from) AND (:P_vendor_to is NULL OR pov.vendor_name <= :P_vendor_to) &WHERE_PERFORMANCE AND EXISTS (SELECT 'Category Flexfield Range' FROM po_lines pol , mtl_categories mca WHERE pol.category_id = mca.category_id AND &P_WHERE_CAT AND poh.po_header_id = pol.po_header_id) AND EXISTS (SELECT 'Item Flexfield Range' FROM po_lines pol , mtl_system_items msi WHERE pol.item_id = msi.inventory_item_id (+) AND nvl(msi.organization_id,:c_organization_id) = :c_organization_id AND &P_WHERE_ITEM AND poh.po_header_id = pol.po_header_id) GROUP BY poh.segment1 , poh.creation_date , poh.revision_num , poh.printed_date , pdt.type_name , ppf.full_name , poh.revised_date , poh.currency_code , pov.vendor_name , poh.acceptance_due_date , decode(poh.user_hold_flag,'Y',:yes,'N',:no,null) , pvs.vendor_site_code , decode(poh.acceptance_required_flag, 'Y',:yes, 'N',:no,null) , poh.po_header_id , decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', decode(rtrim(poh.segment1,'0123456789'),NULL, to_number(poh.segment1),null),null) , plc_sta.displayed_field || decode(poh.cancel_flag, 'Y',', '||plc_can.displayed_field,NULL) || decode(nvl(poh.closed_code,'OPEN'), 'OPEN', NULL, ', '||plc_clo.displayed_field) || decode(poh.frozen_flag, 'Y',', '||plc_fro.displayed_field,NULL) || decode(poh.user_hold_flag, 'Y', ', '||plc_hld.displayed_field, NULL) , fc.precision ORDER BY pov.vendor_name , decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', decode(rtrim(poh.segment1,'0123456789'),NULL, to_number(poh.segment1),null),null) PO POXPOSTD_XML AR PO تقرير تفاصيل أمر الشراء (بتنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل أمر الشراء Application: المشتريات Source: تقرير تفاصيل أمر الشراء (بتنسيق XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG D PO Bestellungen - Details Imported from BI Publisher Description: Bestellungen - Details Application: Einkauf Source: Bestellungen - Details (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG E PO Informe Detalle de Pedidos Imported from BI Publisher Description: Informe de detalle de pedidos Application: Purchasing Source: Informe Detalle de Pedidos (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG F PO Etat détaillé des commandes Imported from BI Publisher Description: Etat détaillé des commandes Application: Purchasing Source: Etat détaillé des commandes (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG I PO Rapporto Dettagli ordine di acquisto Imported from BI Publisher Description: Rapporto Dettagli ordine di acquisto Application: Purchasing Source: Rapporto Dettagli ordine di acquisto (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG JA PO 発注詳細レポート Imported from BI Publisher Description: 発注詳細レポート Application: Purchasing Source: 発注詳細レポート(XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG KO PO 구매발주 상세 보고서 Imported from BI Publisher Description: 구매발주 상세내역 보고서 Application: Purchasing Source: 구매발주 상세 보고서(XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG PTB PO Relatório Detalhado da Ordem de Compra Imported from BI Publisher Description: Relatório Detalhado da Ordem de Compra Application: Compra Source: Relatório Detalhado da Ordem de Compra (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG RU PO Подробный отчет о заказах на приобретение Imported from BI Publisher Description: Подробный отчет о заказах на приобретение Application: Закупки Source: Подробный отчет о заказах на приобретение (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG S PO Inköpsorder - detaljrapport Imported from BI Publisher Description: Inköpsorder - detaljrapport Application: Purchasing Source: Inköpsorder - detaljrapport (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG TR PO Satın Alma Siparişi Detay Raporu Imported from BI Publisher Description: Satın Alma Siparişi Detay Raporu Application: Satın Alma Yönetimi Source: Satın Alma Siparişi Detay Raporu (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG US PO Purchase Order Detail Imported from BI Publisher Description: Purchase Order Detail Report Application: Purchasing Source: Purchase Order Detail Report (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG ZHS PO 采购订单明细报表 Imported from BI Publisher Description: 采购订单明细报表 Application: 采购管理系统 Source: 采购订单明细报表 (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG BI Publisher &p_where_cat &p_where_item &where_performance :c_organization_id :format_mask :no :operating_unit :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_flex_item :p_item_from :p_item_struct_num :p_item_to :p_po_num_from :p_po_num_to :p_po_num_type :p_qty_precision :p_single_po_print :p_status :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat :p_where_item :where_performance :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_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ä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 采购员姓名 采购员姓名 5 30 :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 物料自 物料自 6 40 :p_item_to Char AR إلى الأصناف إلى D Bis Bis Artikel E A A Artículo F A Articles - A I A Articoli - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Itens - Até RU По Позиции по S Till Till artiklar TR Son Kalemler, Son US To Items To ZHS 至 物料至 7 50 :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 类别自 类别自 8 60 :p_category_to Char 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_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 Von Lieferant E De Proveedor De Proveedor F Fournisseurs - De Fournisseurs - De I Fornitori - Da Fornitori - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedores - De Fornecedores - De RU Поставщики с Поставщики с S Från leverantörer Från leverantörer TR Tedarikçiler, İlk Tedarikçiler, İlk US Vendors From Vendors From ZHS 供应商自 供应商自 10 80 :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 إلى 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_po_num_from LOV Oracle PO_SRS_PO_NUMBER_2 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') 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 编号自 12 100 :p_po_num_to LOV Oracle PO_SRS_PO_NUMBER_2 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') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR إلى 4 أرقام أوامر الشراء إلى D Bis 4 Bis Bestellnummer E A 4 A Número de Pedido F A 4 Numéros de commande - A I A 4 Numeri OA - A JA 至 4 発注番号:至 KO 까지 4 PO 번호: 까지 PTB Até 4 Números de OC - Até RU По 4 Номера ЗП по S Till 4 IO-nummer till TR Son 4 SS Numaraları: Son US To 4 PO Numbers To ZHS 至 4 PO 编号至 13 110 :p_status LOV Oracle PO_SRS_AUTHORIZATION_STATUS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='DOCUMENT STATE' and lookup_code in ('RETURNED','RESERVED','APPROVED', 'REQUIRES REAPPROVAL','REJECTED','PRE-APPROVED', 'IN PROCESS','INCOMPLETE') order by displayed_field AR الموقف الموقف E Estado Estado F Statut Statut I Stato Stato JA ステータス ステータス KO 상태 상태 RU Статус Статус S Status Status TR Statü Statü US Status Status ZHS 状态 状态 14 120 :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 动态精确度选项 数量精确度