ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEBF79D2E0530100007F1FF2 FND Flex Value Set Y select ffvs.flex_value_set_name value, decode(ffvs.validation_type, 'D','Dependent', 'I','Independent', 'N','None', 'P','Pair', 'U','Special', 'F','Table', 'X','Translatable Independent', 'Y','Translatable Dependent' )||': '||ffvs.description description from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name not like '$FLEX$.%' order by ffvs.flex_value_set_name US 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）限制的操作单元。 8E2FF36EDEF379D2E0530100007F1FF2 INV Item (master) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments US Any item from item master org, including non costing enabled E0530100007F0001E0530100007F0001 select gsb.name company, hou.name operating_unit, pov.vendor_name, pov.segment1 vendor_number, msiv.concatenated_segments item, pol.item_description, case when pha.type_lookup_code in ('BLANKET','PLANNED') then pha.segment1||'-'||por.release_num else pha.segment1 end po_number, pll.shipment_num, nvl(pll.promised_date,pll.need_by_date) promised_date, nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0) early_receipt_date, nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0) cutoff_date, hla.location_code ship_to_location, round(pll.quantity-nvl(pll.quantity_cancelled,0),:p_qty_precision) quantity_ordered, round(nvl(pll.quantity_received,0),:p_qty_precision) quantity_received, round(pll.quantity_rejected,:p_qty_precision) quantity_rejected, round(pll.quantity-nvl(pll.quantity_cancelled,0)-nvl(pll.quantity_received,0),:p_qty_precision) quantity_open, case when nvl(pll.quantity_received,0)<pll.quantity-nvl(pll.quantity_cancelled,0) and nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0)<trunc(sysdate) then round(pll.quantity-nvl(pll.quantity_cancelled,0)-nvl(pll.quantity_received,0),:p_qty_precision) end quantity_past_due, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0))-trunc(rct.transaction_date)),1,1,0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) quantity_early, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0))-trunc(rct.transaction_date)),-1,1,0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) quantity_late, ( select round(sum( case when trunc(rct.transaction_date) between trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0)) and trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0)) then nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity) end),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) quantity_on_time, ( select round(sum(decode(pll.ship_to_location_id,rct.location_id,0,1)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) quantity_wrong_location, round(pll.quantity_rejected*100/nullif(pll.quantity-nvl(pll.quantity_cancelled,0),0),:p_qty_precision) pct_quantity_rejected, case when nvl(pll.quantity_received,0)<pll.quantity-nvl(pll.quantity_cancelled,0) and nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0)<trunc(sysdate) then round((pll.quantity-nvl(pll.quantity_cancelled,0)-nvl(pll.quantity_received,0))*100/nullif(pll.quantity-nvl(pll.quantity_cancelled,0),0),:p_qty_precision) end pct_quantity_past_due, ( select round(sum( case when trunc(rct.transaction_date) between trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0)) and trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0)) then nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity) end)*100/nullif(nvl(pll.quantity_received,0),0),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) pct_quantity_on_time, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0))-trunc(rct.transaction_date)),-1,1,0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity))*100/nullif(nvl(pll.quantity_received,0),0),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) pct_quantity_late, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0))-trunc(rct.transaction_date)),1,1,0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity))*100/nullif(nvl(pll.quantity_received,0),0),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) pct_quantity_early, ( select round(sum(decode(pll.ship_to_location_id,rct.location_id,0,1)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity))*100/nullif(nvl(pll.quantity_received,0),0),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) pct_quantity_wrong_location, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0))-trunc(rct.transaction_date)),1, trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0))-trunc(rct.transaction_date),0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) days_early, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0))-trunc(rct.transaction_date)),-1, trunc(rct.transaction_date)-trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0)),0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) days_late, ( select round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0))-trunc(rct.transaction_date)),1, trunc(nvl(pll.promised_date,pll.need_by_date)-nvl(pll.days_early_receipt_allowed,0))-trunc(rct.transaction_date),0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision)+ round(sum(decode(sign(trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0))-trunc(rct.transaction_date)),-1, trunc(rct.transaction_date)-trunc(nvl(pll.promised_date,pll.need_by_date)+nvl(pll.days_late_receipt_allowed,0)),0)* nvl(rsl.quantity_received,0)*decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity)),:p_qty_precision) from rcv_transactions rct, rcv_shipment_lines rsl where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rct.shipment_line_id=rsl.shipment_line_id ) days_total_late_or_early, ( select rct.primary_unit_of_measure from rcv_transactions rct where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rownum=1 ) primary_uom, ( select decode(rct.primary_unit_of_measure,rct.unit_of_measure,1,rct.primary_quantity/rct.quantity) from rcv_transactions rct where rct.po_line_location_id=pll.line_location_id and rct.transaction_type='RECEIVE' and rownum=1 ) conversion_rate, papf.full_name buyer, decode(pll.shipment_type,'STANDARD',pha.creation_date,por.creation_date) creation_date, pll.unit_meas_lookup_code uom, gsb.currency_code, fspa.inventory_organization_id organization_id, mck.concatenated_segments category, pll.line_location_id, pll.po_line_id, pha.po_header_id from gl_sets_of_books gsb, financials_system_params_all fspa, hr_operating_units hou, ap_suppliers pov, po_headers_all pha, po_releases_all por, po_lines_all pol, po_line_locations_all pll, mtl_system_items_vl msiv, mtl_categories_b_kfv mck, per_all_people_f papf, hr_locations_all hla where 1=1 and gsb.set_of_books_id=fspa.set_of_books_id and fspa.org_id=hou.organization_id and pha.org_id=hou.organization_id and pha.org_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) and pha.vendor_id=pov.vendor_id and pha.po_header_id=pol.po_header_id and pol.po_line_id=pll.po_line_id and pll.po_release_id=por.po_release_id(+) and pol.item_id=msiv.inventory_item_id(+) and fspa.inventory_organization_id=msiv.organization_id(+) and pol.category_id=mck.category_id(+) and pha.agent_id=papf.person_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 pll.ship_to_location_id=hla.location_id(+) and nvl(pll.cancel_flag,'N')='N' and pll.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and pha.type_lookup_code in ('STANDARD','BLANKET','PLANNED') and pol.order_type_lookup_code in ('QUANTITY','AMOUNT') and (pll.promised_date is not null or pll.need_by_date is not null) and exists (select null from rcv_transactions rct where rct.transaction_type='RECEIVE' and rct.po_header_id=pha.po_header_id and rct.po_line_id=pol.po_line_id and rct.po_line_location_id=pll.line_location_id) order by pov.vendor_name, pov.segment1, msiv.concatenated_segments, pol.item_description, po_number, pll.shipment_num Initial version - converted from Oracle BI Publisher POXSERPR_XML data definition Y PO POXSERPR_XML :Operating_Unit is not null AR PO تقرير تحليل أداء خدمة المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل أداء خدمة المورد Application: المشتريات Source: تقرير تحليل أداء خدمة المورد (بتنسيق XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG D PO Lieferanten - Analyse Serviceleistungen Imported from BI Publisher Description: Lieferanten - Analyse Serviceleistungen Application: Einkauf Source: Lieferanten - Analyse Serviceleistungen (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG E PO Informe Análisis de Servicios de Proveedores Imported from BI Publisher Description: Informe de análisis de servicios de proveedores Application: Purchasing Source: Informe Análisis de Servicios de Proveedores (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG F PO Analyse des performances de service par fournisseur Imported from BI Publisher Description: Analyse des performances de service par fournisseur Application: Purchasing Source: Analyse des performances de service par fournisseur (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG I PO Rapporto Analisi prestazioni assistenza fornitore Imported from BI Publisher Description: Rapporto Analisi prestazioni assistenza fornitore Application: Purchasing Source: Rapporto Analisi prestazioni assistenza fornitore (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG JA PO 仕入先サービス実績分析レポート Imported from BI Publisher Description: 仕入先サービス実績分析レポート Application: Purchasing Source: 仕入先サービス実績分析レポート(XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG KO PO 공급자 서비스 성과 분석 보고서 Imported from BI Publisher Description: 공급자 서비스 비교 분석 보고서 Application: Purchasing Source: 공급자 서비스 성과 분석 보고서(XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG PTB PO Relatório de Análise de Desempenho de Serviço do Fornecedor Imported from BI Publisher Description: Relat. de Análise de Serviços de Fornecedor Application: Compra Source: Relatório de Análise de Desempenho de Serviço do Fornecedor (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG RU PO Аналитический отчет об обслуживании поставщиком Imported from BI Publisher Description: Аналитический отчет об обслуживании поставщиком Application: Закупки Source: Аналитический отчет об обслуживании поставщиком (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG S PO Analys av serviceprestation för leverantör - rapport Imported from BI Publisher Description: Analys av serviceprestation för leverantör - rapport Application: Purchasing Source: Analys av serviceprestation för leverantör - rapport (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG TR PO Tedarikçi Hizmeti Performans Analizi Raporu Imported from BI Publisher Description: Tedarikçi Hizmeti Performans Analizi Raporu Application: Satın Alma Yönetimi Source: Tedarikçi Hizmeti Performans Analizi Raporu (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG US PO Vendor Service Performance Analysis Imported from BI Publisher Application: Purchasing Source: Vendor Service Performance Analysis Report (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG Please enter Operating Unit ZHS PO 供应商服务表现分析报表 Imported from BI Publisher Description: 供应商服务表现分析报表 Application: 采购管理系统 Source: 供应商服务表现分析报表 (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG BI Publisher Enginatics R12 only 1=1 :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_detail_summary :p_drive_off_headers :p_drive_off_vendors :p_flex_item :p_get_precision :p_item_from :p_item_struct_num :p_item_to :p_qty_precision :p_struct_num :p_title :p_vendor_from :p_vendor_query :p_vendor_to :p_where_cat :p_where_item :qty_precision 1 10 1=1 hou.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y 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 Operating Unit ZHS 标题 标题 2 20 1=1 pov.vendor_name>=:vendor_from LOV custom Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) order by aps.vendor_name, aps.vendor_id 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 Vendor From ZHS 物料自 物料自 3 30 1=1 pov.vendor_name<=:vendor_to LOV custom Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) order by aps.vendor_name, aps.vendor_id :$flex$.vendor_from 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 Vendor To ZHS 至 物料至 4 40 1=1 papf.full_name=:buyer LOV FND Flex Value Set 8E2FF36EDEBF79D2E0530100007F1FF2 Y select ffvs.flex_value_set_name value, decode(ffvs.validation_type, 'D','Dependent', 'I','Independent', 'N','None', 'P','Pair', 'U','Special', 'F','Table', 'X','Translatable Independent', 'Y','Translatable Dependent' )||': '||ffvs.description description from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name not like '$FLEX$.%' order by ffvs.flex_value_set_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 Buyer ZHS 供应商自 供应商自 5 50 1=1 decode(pll.shipment_type,'STANDARD',trunc(pha.creation_date),trunc(por.creation_date))>=:creation_date_from Date AR إلى 2 موردون إلى D Bis 2 Bis Lieferant E A 2 A Proveedor F A 2 Fournisseurs - A I A 2 Fornitori - A JA 至 2 仕入先:至 KO 까지 2 공급자: 까지 PTB Até 2 Fornecedores - Até RU По 2 Поставщики по S Till 2 Leverantörer till TR Son 2 Tedarikçiler: Son US Creation Date From ZHS 至 2 供应商至 6 60 1=1 decode(pll.shipment_type,'STANDARD',trunc(pha.creation_date),trunc(por.creation_date))<=:creation_date_to Date :$flex$.creation_date_from 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 Creation Date To ZHS 类别自 类别自 7 70 1=1 msiv.concatenated_segments>=:item_from LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments AR إلى 3 الفئات إلى D Bis 3 Bis Kategorie E A 3 A Categoría F A 3 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 Item From ZHS 至 3 类别至 8 80 1=1 msiv.concatenated_segments<=:item_to LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments :$flex$.item_from 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 Item To ZHS 采购员姓名 采购员姓名 9 90 1=1 mck.concatenated_segments>=:category_from LOV custom Y select mcbk.concatenated_segments value, mct.description from mtl_categories_b_kfv mcbk, mtl_categories_tl mct, mtl_default_sets_view mdsv where mdsv.functional_area_id=2 and mcbk.structure_id=mdsv.structure_id and mcbk.category_id=mct.category_id and mct.language=userenv('lang') order by mcbk.concatenated_segments AR تواريخ التكوين من تواريخ التكوين من D Von Erstellungsdatum Von Erstellungsdatum E De Fecha de Creación De Fecha de Creación F Dates de création - Du Dates de création - Du I Date creazione - Da Date creazione - Da JA 作成日:自 作成日:自 KO 생성 일자: 부터 생성 일자: 부터 PTB Datas de Criação - De Datas de Criação - De RU Даты создания с Даты создания с S Från skapandedatum Från skapandedatum TR Oluşturma Tarihleri, İlk Oluşturma Tarihleri, İlk US Category From ZHS 创建日期自 创建日期自 10 100 1=1 mck.concatenated_segments<=:category_to LOV custom Y select mcbk.concatenated_segments value, mct.description from mtl_categories_b_kfv mcbk, mtl_categories_tl mct, mtl_default_sets_view mdsv where mdsv.functional_area_id=2 and mcbk.structure_id=mdsv.structure_id and mcbk.category_id=mct.category_id and mct.language=userenv('lang') order by mcbk.concatenated_segments :$flex$.category_from AR إلى 4 تواريخ التكوين إلى D Bis 4 Bis Erstellungsdatum E A 4 A Fecha de Creación F Au Dates de création - Au I A 4 Date creazione - A JA 至 4 作成日:至 KO 까지 4 생성일자: 까지 PTB Até 4 Datas de Criação - Até RU По 4 Даты создания по S Till 4 Till skapandedatum TR Son 4 Oluşturma Tarihleri: Son US Category To ZHS 至 4 创建日期至 11 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 nvl(fnd_profile.value('REPORT_QUANTITY_PRECISION'),2) Y AR التفاصيل تفاصيل أو إجمالي D Details Details oder Übersicht E Detalle Detalle o Resumen F Détail Détail ou synthèse I Dettaglio Dettaglio o sintetico JA 詳細 詳細または要約 KO 상세내역 상세내역 혹은 요약 PTB Detalhe Detalhe ou Sumário RU Подробный Подробный или сводный S Detalj Detalj eller översikt TR Detay Detay veya Özet US Quantity Precision ZHS 详细信息 明细或汇总 :$flex$.category_from Category From Category To :$flex$.creation_date_from Creation Date From Y Creation Date To :$flex$.item_from Item From Item To :$flex$.operating_unit Operating Unit Vendor From :$flex$.operating_unit Operating Unit Vendor To :$flex$.vendor_from Vendor From Vendor To