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）限制的操作单元。 C6E085D471BC51A9E05362FB09050512Y SELECT pol.po_header_id po_header_id , poh.agent_id agent_id , pov.vendor_name Vendor , poh.segment1 PO_Number , poh.currency_code C_CURRENCY , pol.line_num Line , null C_FLEX_CAT , null C_FLEX_ITEM , pol.item_revision Rev , pol.item_description Description , pol.unit_meas_lookup_code Unit , pll.shipment_num Shipment , decode(polt.order_type_lookup_code,'AMOUNT', null,pll.price_override) Unit_Price , round(pll.quantity,:P_qty_precision) Ordered , round(pll.quantity_billed,:P_qty_precision) Billed , round(pll.quantity_received,:P_qty_precision) Received , round(pll.quantity_accepted,:P_qty_precision) Accepted , alc.displayed_field Holds_Placed , api.invoice_num Invoice_Number , api.invoice_date I_Date , aid.distribution_line_number Line1 , aid.description Description1 , round(aid.quantity_invoiced,:P_qty_precision) Invoiced , aid.unit_price Invoice_Price , api.invoice_id, DECODE(pol.category_id,null,'',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, DECODE(pol.item_id,null,'',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, PO_POXPOSMH_XMLP_PKG.c_unit_price_round(decode ( polt.order_type_lookup_code , 'AMOUNT' , null , pll.price_override ), :PARENT_CURRENCY_PRECISION) C_UNIT_PRICE_ROUND, PO_POXPOSMH_XMLP_PKG.c_invoice_price_round(aid.unit_price, :PARENT_CURRENCY_PRECISION) C_INVOICE_PRICE_ROUND FROM ap_invoices api , mtl_system_items msi , mtl_categories mca , ap_invoice_distributions aid , po_distributions pod , po_line_locations pll , po_lines pol , po_vendors pov , po_headers poh , ap_lookup_codes alc , po_line_types polt , po_system_parameters psp , ap_holds aph WHERE pol.po_line_id = pll.po_line_id AND pov.vendor_id = poh.vendor_id AND poh.po_header_id = pol.po_header_id AND pol.item_id = msi.inventory_item_id(+) AND nvl(msi.organization_id,:organization_id) = :organization_id AND pol.category_id = mca.category_id AND pll.line_location_id = pod.line_location_id AND aid.po_distribution_id = pod.po_distribution_id AND pll.line_location_id = aph.line_location_id AND api.invoice_id = aph.invoice_id AND pll.shipment_type in ('STANDARD','BLANKET','SCHEDULED') 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) AND api.invoice_date BETWEEN nvl(:P_invoice_date_from, api.invoice_date - 1) AND nvl(:P_invoice_date_to, api.invoice_date + 1) AND &P_WHERE_ITEM AND &P_WHERE_CAT AND api.invoice_id = aid.invoice_id AND aph.release_lookup_code is NULL AND (aph.hold_lookup_code = DECODE(:P_price_hold,'Y','PRICE','N','X') OR aph.hold_lookup_code = DECODE(:P_qty_ord_hold,'Y','QTY ORD','N','X') OR aph.hold_lookup_code = DECODE(:P_qty_rec_hold,'Y','QTY REC','N','X') OR aph.hold_lookup_code = DECODE(:P_quality_hold,'Y','QUALITY','N','X') OR (:P_price_hold is null AND :P_qty_ord_hold is null AND :P_qty_rec_hold is null AND :P_quality_hold is null AND aph.hold_lookup_code in ('PRICE','QTY ORD','QTY REC','QUALITY'))) AND alc.lookup_type = 'HOLD CODE' AND alc.lookup_code = aph.hold_lookup_code AND polt.line_type_id = pol.line_type_id and poh.currency_code=:Parent_Currency_code and poh.agent_id=:Parent_Employee_id /*ORDER BY decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1),null) , pol.line_num , pll.shipment_num*/ ORDER BY 1 ASC,6 ASC,7 ASC,8 ASC,9 ASC,10 ASC,2 ASC,3 ASC,4 ASC,5 ASC,11 ASC,12 ASC,13 ASC,14 ASC,15 ASC,16 ASC,17 ASC,18 ASC , decode ( psp.manual_po_num_type , 'NUMERIC' , null , poh.segment1 ) , decode ( psp.manual_po_num_type , 'NUMERIC' , to_number ( poh.segment1 ) , null ) , pol.line_num , pll.shipment_num PO POXPOSMH_XML AR PO تقرير مطابقة تقرير الإيقافات حسب المشتري (بتنسيق XML) Imported from BI Publisher Description: تقرير مطابقة تقرير الإيقافات حسب المشتري Application: المشتريات Source: تقرير مطابقة تقرير الإيقافات حسب المشتري (بتنسيق XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG D PO Einkäufer - Dokumente mit Abgleichsperren Imported from BI Publisher Description: Einkäufer - Dokumente mit Abgleichsperren Application: Einkauf Source: Einkäufer - Dokumente mit Abgleichsperren (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG E PO Informe de Retenciones de Confrontación por Comprador Imported from BI Publisher Description: Retenciones de Confrontación por Comprador Application: Purchasing Source: Informe de Retenciones de Confrontación por Comprador (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG F PO Etat des blocages pour écarts, par acheteur Imported from BI Publisher Description: Etat des blocages pour écarts, par acheteur Application: Purchasing Source: Etat des blocages pour écarts, par acheteur (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG I PO Rapporto Blocchi corrispondenti per buyer Imported from BI Publisher Description: Rapporti Blocchi per buyer corrispondenti Application: Purchasing Source: Rapporto Blocchi corrispondenti per buyer (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG JA PO 購買担当別保留照合レポート Imported from BI Publisher Description: 購買担当別保留照合レポート Application: Purchasing Source: 購買担当別保留照合レポート(XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG KO PO 구매자별 대응 보류 보고서 Imported from BI Publisher Description: 구매자별 구매송장 불일치 보류보고서 Application: Purchasing Source: 구매자별 대응 보류 보고서(XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG PTB PO Relatório de Relatórios de Retenções Correspondentes por Comprador Imported from BI Publisher Description: Relatório de Relatórios de Retenção de Vinculação por Comprador Application: Compra Source: Relatório de Relatórios de Retenções Correspondentes por Comprador (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG RU PO Отчет о блокировках согласования по покупателям Imported from BI Publisher Description: Отчет о блокировках согласования по покупателям Application: Закупки Source: Отчет о блокировках согласования по покупателям (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG S PO Matchningsspärrar per köpare - rapport Imported from BI Publisher Description: Matchningsspärrar per inköpare - rapport Application: Purchasing Source: Matchningsspärrar per köpare - rapport (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG TR PO Satın Alan Raporu Bazında Eşleşen Durdurmalar Raporu Imported from BI Publisher Description: Satın Alan Raporu bazında Eşleşen Durdurmalar Raporu Application: Satın Alma Yönetimi Source: Satın Alan Raporu Bazında Eşleşen Durdurmalar Raporu (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG US PO Matching Holds Report by Buyer Imported from BI Publisher Description: Matching Holds Report by Buyer Report Application: Purchasing Source: Matching Holds Report by Buyer Report (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG ZHS PO 匹配暂挂报表（按采购员） Imported from BI Publisher Description: 按采购员匹配暂挂报表 Application: 采购管理系统 Source: 匹配暂挂报表（按采购员）(XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG BI Publisher &p_where_cat &p_where_item :format_mask :operating_unit :org_id :organization_id :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_flex_item :p_invoice_date_from :p_invoice_date_to :p_item_from :p_item_struct_num :p_item_to :p_price_hold :p_qty_ord_hold :p_qty_precision :p_qty_rec_hold :p_quality_hold :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat :p_where_item :parent_currency_code :parent_currency_precision :parent_employee_id :price_hold :qty_ord_hold :qty_rec_hold :quality_hold 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 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 采购员姓名 采购员姓名 5 30 :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 供应商自 供应商自 6 40 :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 إلى موردون إلى D Bis Bis Lieferant E A A Proveedor F A Fournisseurs - A I A Fornitori - A JA 至 仕入先:至 KO 까지 공급자: 까지 PTB Até Fornecedores - Até RU По Поставщики по S Till Leverantörer till TR Son Tedarikçiler: Son US To Vendors To ZHS 至 供应商至 7 50 :p_invoice_date_from Date AR تواريخ الفواتير من تواريخ الفواتير من D Von Rechnungsdatum Von Rechnungsdatum E De Fecha de Factura De Fecha de Factura F Dates de facture - Du Dates de facture - Du I Date fatture - Da Date fatture - Da JA 請求日:自 請求日:自 KO 송장 일자: 부터 송장 일자: 부터 PTB Datas de NFF - De Datas de NFF - De RU Даты счетов-фактур с Даты счетов-фактур с S Från fakturadatum Från fakturadatum TR Fatura Tarihleri, İlk Fatura Tarihleri, İlk US Invoice Dates From Invoice Dates From ZHS 发票日期自 发票日期自 8 60 :p_invoice_date_to Date AR إلى 2 تواريخ الفواتير إلى D Bis 2 Bis Rechnungsdatum E A 2 A Fecha de Factura F Au Dates de facture - Au I A 2 Date fattura - A JA 至 2 請求期日 KO 까지 2 송장 일자: 까지 PTB Até 2 Datas da NFF - Até RU По 2 Даты счетов-фактур по S Till 2 Fakturadatum till TR Son 2 Fatura Tarihleri: Son US To 2 Invoice Dates 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 Kategorie E A 3 A Categoría F A 2 Catégories - A I A 3 Categorie - A JA 至 3 カテゴリ:至 KO 까지 3 범주: 까지 PTB Até 3 Categorias - Até RU По 3 Категории по S Till 3 Till kategorier TR Son 3 Kategoriler: Son US To 3 Categories To ZHS 至 3 类别至 11 90 :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 物料自 物料自 12 100 :p_item_to Char AR إلى 4 الأصناف إلى D Bis 4 Bis Artikel E A 4 A Artículo F A 3 Articles - A I A 4 Articoli - A JA 至 4 品目:至 KO 까지 4 품목: 까지 PTB Até 4 Itens - Até RU По 4 Позиции по S Till 4 Till artiklar TR Son 4 Kalemler, Son US To 4 Items To ZHS 至 4 物料至 13 110 :p_price_hold LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR إيقاف السعر إيقاف السعر D Preissperre Preissperre E Retención de Precio Retención de Precio F Blocage du prix Blocage du prix I Blocco prezzo Blocco prezzo JA 価格保留 価格保留 KO 가격 보류 가격 보류 PTB Retenção de Preço Retenção de Preço RU Блокировка цены Блокировка цены S Prisspärr Prisspärr TR Fiyat Durdurması Fiyat Durdurması US Price Hold Price Hold ZHS 价格暂挂 价格暂挂 14 120 :p_qty_ord_hold LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR إيقاف الكمية المطلوبة إيقاف الكمية المطلوبة D Sperre Bestellmenge Sperre Bestellmenge E Retención de Cantidad Pedida Retención de Cantidad Pedida F Blocage quantité commandée Blocage quantité commandée I Blocco quantità ordinata Blocco quantità ordinata JA 発注数量保留 発注数量保留 KO 주문 보류 수량 주문 보류 수량 PTB Retenção da Quantidade Recebimento Retenção da Quantidade Recebimento RU Блокировка заказанного количества Блокировка заказанного количества S Orderkvantitetsspärr Orderkvantitetsspärr TR Sipariş Miktarından Durdurma Sipariş Miktarından Durdurma US Quantity Ordered Hold Quantity Ordered Hold ZHS 订货数量暂挂 订货数量暂挂 15 130 :p_qty_rec_hold LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR إيقاف الكمية المستلمة إيقاف الكمية المستلمة D Sperre Eingangsmenge Sperre Eingangsmenge E Retención de Cantidad Recibida Retención de Cantidad Recibida F Blocage de la quantité réceptionnée Blocage de la quantité réceptionnée I Blocco quantità ricevuta Blocco quantità ricevuta JA 受入数量保留 受入数量保留 KO 입고 보류 수량 입고 보류 수량 PTB Retenção da Quantidade Solicitação Retenção da Quantidade Solicitação RU Блокировка полученного количества Блокировка полученного количества S Spärr för mottagen kvant. Spärr för mottagen kvant. TR Teslim Alınan Miktardan Durdurma Teslim Alınan Miktardan Durdurma US Quantity Received Hold Quantity Received Hold ZHS 接收数量暂挂 接收数量暂挂 16 140 :p_quality_hold LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR إيقاف الجودة إيقاف الجودة D Qualitätssperre Qualitätssperre E Retención de Calidad Retención de Calidad F Blocage de la qualité Blocage de la qualité I Blocco qualità Blocco qualità JA 品質保留 品質保留 KO 품질보류 품질보류 PTB Retenção da Qualidade Retenção da Qualidade RU Блокировка качества Блокировка качества S Kvalitetsspärr Kvalitetsspärr TR Kaliteden Durdurma Kaliteden Durdurma US Quality Hold Quality Hold ZHS 质量暂挂 质量暂挂 17 150 :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 动态精确度选项 数量精确度