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）限制的操作单元。 C6E085D471B651A9E05362FB09050512 SELECT distinct null C_FLEX_CAT , poh.segment1 PO_number , ppf.full_name Buyer , decode(psp1.manual_po_num_type, 'NUMERIC', to_number(poh.segment1), null) Ordering_PO_Num , decode(psp1.manual_po_num_type, 'NUMERIC', null, poh.segment1) , T.type_name PO_type , decode(nvl(poh.user_hold_flag,'N'), 'Y', :yes, :no ) On_hold , pol.line_num Line , plt.line_type Line_type , pol.item_description Item_description , pol.unit_meas_lookup_code Unit , plc1.displayed_field List_code , plc2.displayed_field Market_code , plc3.displayed_field Quote_code , to_number(nvl(pol.unit_price,0)) * nvl(poh.rate,1) Actual_price , decode(poh.creation_date,NULL,decode((pll.promised_date),NULL,decode( (pll.need_by_date),NULL,sysdate,pll.need_by_date),pll.promised_date), poh.creation_date) Quote_date , '1' Dummy , pol.item_id Item_id_qpos , pll.ship_to_organization_id Ship_to_org , pll.ship_to_location_id Ship_to_loc , poh.creation_date Creation_date , poh.rate Rate , pol.quantity Line_quantity , pol.unit_price Line_price , pol.market_price Market_price , pol.list_price_per_unit List , plt.order_type_lookup_code Order_type , pll.shipment_num Shipment_num , pll.quantity Shipment_quantity, 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, PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity) C_QUANTITY, PO_POXKIAGN_XMLP_PKG.return_list(plt.order_type_lookup_code, :C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, poh.rate) C_LIST_PRICE, PO_POXKIAGN_XMLP_PKG.return_amt_list(:C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), poh.rate) C_AMOUNT_LIST, --PO_POXKIAGN_XMLP_PKG.return_amt_act(:C_QUANTITY, pol.unit_price, poh.rate) C_AMOUNT_ACTUAL, PO_POXKIAGN_XMLP_PKG.return_amt_act(PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), pol.unit_price, poh.rate) C_AMOUNT_ACTUAL, --PO_POXKIAGN_XMLP_PKG.return_amt_saved(:C_AMOUNT_LIST, :C_AMOUNT_ACTUAL) C_AMOUNT_SAVED, PO_POXKIAGN_XMLP_PKG.return_amt_saved(PO_POXKIAGN_XMLP_PKG.return_amt_list(:C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), poh.rate), PO_POXKIAGN_XMLP_PKG.return_amt_act(PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), pol.unit_price, poh.rate)) C_AMOUNT_SAVED, --PO_POXKIAGN_XMLP_PKG.return_discount(:C_AMOUNT_LIST, :C_AMOUNT_ACTUAL) C_DISCOUNT, PO_POXKIAGN_XMLP_PKG.return_discount(PO_POXKIAGN_XMLP_PKG.return_amt_list(:C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), poh.rate), PO_POXKIAGN_XMLP_PKG.return_amt_act(PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), pol.unit_price, poh.rate)) C_DISCOUNT, PO_POXKIAGN_XMLP_PKG.return_type(:C_MIN_QUOTE, plc3.displayed_field, pol.market_price, plc2.displayed_field, pol.list_price_per_unit, plc1.displayed_field) C_PRICE_TYPE FROM po_lines pol , po_line_types plt , po_headers poh , per_people_f ppf , mtl_categories mca , po_document_types_all_tl T , po_document_types_all_b B , po_line_locations pll , hr_locations_no_join hrl , po_vendors pov , po_lookup_codes plc , po_lookup_codes plc1 , po_lookup_codes plc2 , po_lookup_codes plc3 , po_system_parameters psp1 WHERE poh.type_lookup_code in ('STANDARD','BLANKET','PLANNED') AND pol.po_header_id = poh.po_header_id AND pol.po_line_id = pll.po_line_id (+) AND pll.ship_to_location_id = hrl.location_id (+) AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND ppf.business_group_id + 0 = :business_group_id AND trunc(poh.creation_date) BETWEEN nvl(:P_start_date_from,poh.creation_date - 1) AND nvl(:P_start_date_to,poh.creation_date + 1) AND plc.lookup_code = poh.type_lookup_code AND plc.lookup_type = 'PO TYPE' AND mca.category_id = pol.category_id AND ppf.full_name = nvl(:P_buyer,ppf.full_name) AND ppf.person_id = poh.agent_id AND plt.line_type_id = pol.line_type_id AND plt.order_type_lookup_code != 'AMOUNT' AND pov.vendor_id = poh.vendor_id AND B.document_type_code in ('PO', 'PA') AND B.document_subtype = poh.type_lookup_code AND plc1.lookup_type = 'LINE PRICE TYPE' AND plc1.lookup_code = 'LIST' AND plc2.lookup_type = 'LINE PRICE TYPE' AND plc2.lookup_code = 'MARKET' AND plc3.lookup_type = 'LINE PRICE TYPE' AND plc3.lookup_code = 'QUOTE' 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 &P_WHERE_CAT GROUP BY &P_FLEX_CAT , poh.segment1 , ppf.full_name , psp1.manual_po_num_type , poh.segment1 , poh.segment1 , poh.creation_date , T.type_name , poh.user_hold_flag , pol.line_num , pol.item_id , plt.line_type , pol.item_description , pol.unit_meas_lookup_code , pol.quantity , pol.market_price , pol.list_price_per_unit , poh.rate , pol.unit_price , plc1.displayed_field , plc2.displayed_field , plc3.displayed_field , plt.order_type_lookup_code , pll.ship_to_organization_id , pll.ship_to_location_id , pll.promised_date , pll.need_by_date , pll.shipment_num , pll.quantity , 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') , PO_POXKIAGN_XMLP_PKG.get_quantity(pll.quantity, pol.quantity), PO_POXKIAGN_XMLP_PKG.return_list(plt.order_type_lookup_code, :C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, poh.rate), -- commented by Atul -- PO_POXKIAGN_XMLP_PKG.return_amt_list(:C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, :C_QUANTITY, poh.rate), --PO_POXKIAGN_XMLP_PKG.return_amt_act(:C_QUANTITY, pol.unit_price, poh.rate), PO_POXKIAGN_XMLP_PKG.return_amt_saved(:C_AMOUNT_LIST, :C_AMOUNT_ACTUAL), PO_POXKIAGN_XMLP_PKG.return_discount(:C_AMOUNT_LIST, :C_AMOUNT_ACTUAL), PO_POXKIAGN_XMLP_PKG.return_type(:C_MIN_QUOTE, plc3.displayed_field, pol.market_price, plc2.displayed_field, pol.list_price_per_unit, plc1.displayed_field) ORDER BY Dummy ,C_FLEX_CAT_DISP ,PO_number ,PO_type ,On_hold ,Buyer ,decode(psp1.manual_po_num_type, 'NUMERIC',null, poh.segment1) ,line ,Line_type ,Item_description ,Item_id ,Shipment_num ,:orderby_clause ,pol.line_num ,pll.shipment_num Y PO POXKIAGN_XML AR PO تقرير تحليل المدخرات (حسب الفئة) (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل المدخرات (بواسطة الفئة) Application: المشتريات Source: تقرير تحليل المدخرات (حسب الفئة) (بتنسيق XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG D PO Ersparnisanalyse nach Kategorie Imported from BI Publisher Description: Ersparnisanalyse nach Kategorie Application: Einkauf Source: Ersparnisanalyse nach Kategorie (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG E PO Informe Análisis de Ahorro por Comprador Imported from BI Publisher Description: Análisis de Ahorro por Categoría Application: Purchasing Source: Informe Análisis de Ahorro por Comprador (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG F PO Analyse des économies (par catégorie) Imported from BI Publisher Description: Analyse des économies (par catégorie) Application: Purchasing Source: Analyse des économies (par catégorie) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG I PO Rapporto Analisi risparmi (per categoria) Imported from BI Publisher Description: Rapporto Analisi risparmi (per categoria) Application: Purchasing Source: Rapporto Analisi risparmi (per categoria) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG JA PO 削減分析レポート(カテゴリ別) Imported from BI Publisher Description: 削減分析レポート(カテゴリ別) Application: Purchasing Source: 削減分析レポート(カテゴリ別)(XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG KO PO 절감 분석 보고서(범주별) Imported from BI Publisher Description: 절감 분석 보고서(범주별) Application: Purchasing Source: 절감 분석 보고서(범주별)(XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG PTB PO Relatório de Análise de Economia(por Categoria) Imported from BI Publisher Description: Relatório de Análise de Economia(por Categoria) Application: Compra Source: Relatório de Análise de Economia(por Categoria) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG RU PO Отчет об анализе экономии по категориям Imported from BI Publisher Description: Отчет об анализе экономии по категориям Application: Закупки Source: Отчет об анализе экономии по категориям (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG S PO Besparingsanalys (per kategori) Imported from BI Publisher Description: Besparingsanalys (per kategori) Application: Purchasing Source: Besparingsanalys (per kategori) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG TR PO Tasarruf Analizi Raporu (Kategori bazında) Imported from BI Publisher Description: Satın Alma Performans Raporu(Kategori bazında) Application: Satın Alma Yönetimi Source: Tasarruf Analizi Raporu (Kategori bazında) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG US PO Savings Analysis Report(by Category) Imported from BI Publisher Description: Savings Analysis Report(by Category) Application: Purchasing Source: Savings Analysis Report(by Category) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG ZHS PO 节省分析报表（按类别） Imported from BI Publisher Description: 节省分析报表（按类别） Application: 采购管理系统 Source: 节省分析报表（按类别）(XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG BI Publisher &p_flex_cat &p_where_cat :business_group_id :c_amount_actual :c_amount_list :c_min_quote :lp_struct_num :no :operating_unit :orderby_clause :p_base_currency :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_orderby :p_orderby_cat :p_orderby_disp :p_qty_precision :p_start_date_from :p_start_date_to :p_struct_num :p_title :p_where_cat :yes 1 -30 :p_base_currency LOV Oracle PO_SRS_BASE_CURRENCY Y select gsb.currency_code id, gsb.currency_code value, null description from gl_sets_of_books gsb,financials_system_parameters fsp where gsb.set_of_books_id=fsp.set_of_books_id order by value,description SELECT GSB.CURRENCY_CODE FROM GL_SETS_OF_BOOKS GSB, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID Y US P_BASE_CURRENCY P_BASE_CURRENCY 2 -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 结构编号 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_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 采购员姓名 采购员姓名 6 30 :p_start_date_from Date AR تواريخ التكوين من تاريخ بداية التقرير D Von Erstellungsdatum Startdatum Auswertung E De Fecha de Creación Fecha de Inicio del Informe F Dates de création - Du Date de début de l'état I Date creazione - Da Data inizio rapporto JA 作成日:自 レポート開始日 KO 생성 일자: 부터 보고서 시작일자 PTB Datas de Criação - De Data Inicial do Relatório RU Даты создания с Начальная дата отчета S Från skapandedatum Startdatum för rapport TR Oluşturma Tarihleri, İlk Rapor Başlangıç Tarihi US Creation Dates From Report Start Date ZHS 创建日期自 报表起始日期 7 40 :p_start_date_to Date AR إلى تاريخ النهاية D Bis Enddatum E A Fecha de Finalización F Au Date de fin I A Data fine JA 至 終了日 KO 까지 종료 일자 PTB Até Data Final RU По Конечная дата S Till Slutdatum TR Son Bitiş Tarihi US To End Date ZHS 至 终止日期 8 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 类别自 类别自 9 60 :p_category_to Char AR إلى 2 الفئات إلى D Bis 2 Bis Kategorie E A 2 A Categoría F A Catégories - A I A 2 Categorie - A JA 至 2 カテゴリ:至 KO 까지 2 범주: 까지 PTB Até 2 Categorias - Até RU По 2 Категории по S Till 2 Till kategorier TR Son 2 Kategoriler: Son US To 2 Categories To ZHS 至 2 类别至 10 70 :p_orderby LOV Oracle PO_SRS_POXKIAGN_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 ('PO NUMBER','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 排序依据 排序依据 11 80 :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 动态精确度选项 数量精确度