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）限制的操作单元。 073449E52472116DE06362FB0905DDABY SELECT pll.shipment_num||'-'||pod.distribution_num Distribution , decode(plt.order_type_lookup_code, 'AMOUNT',NULL,pll.price_override) Unit_Price , pll.promised_date Promised_Date , pol.unit_meas_lookup_code Unit , ROUND (DECODE (POL.order_type_lookup_code, 'RATE', POD.amount_ordered, 'FIXED PRICE', POD.amount_ordered, POD.quantity_ordered), :p_qty_precision) Quantity_Amount_Ordered , ROUND (DECODE (POL.order_type_lookup_code, 'RATE', POD.amount_billed, 'FIXED PRICE', POD.amount_billed, POD.quantity_billed), :p_qty_precision) Quantity_Amount_Billed , ROUND (DECODE (POL.order_type_lookup_code, 'RATE', POD.amount_delivered, 'FIXED PRICE', POD.amount_delivered, POD.quantity_delivered), :p_qty_precision) Quantity_Amount_Delivered , DECODE (POL.order_type_lookup_code, 'RATE', (NVL(POD.amount_ordered, 0) - NVL(POD.amount_billed, 0)) / DECODE (NVL(POD.amount_ordered, 0), 0, 1, POD.amount_ordered), 'FIXED PRICE', (NVL(POD.amount_ordered, 0) - NVL(POD.amount_billed, 0)) / DECODE (NVL(POD.amount_ordered, 0), 0, 1, POD.amount_ordered), (NVL(POD.quantity_ordered, 0) - NVL(POD.quantity_billed, 0)) / DECODE (NVL(POD.quantity_ordered, 0), 0, 1, POD.quantity_ordered)) * 100 Percent_Unbilled , DECODE (POL.order_type_lookup_code, 'RATE', POD.amount_ordered - NVL(POD.amount_cancelled, 0)- NVL(POD.amount_billed, 0), 'FIXED PRICE', POD.amount_ordered - NVL(POD.amount_cancelled, 0)- NVL(POD.amount_billed, 0), (POD.quantity_ordered - NVL(POD.quantity_cancelled, 0)- NVL(POD.quantity_billed, 0)) * PLL.price_override) C_AMOUNT_OPEN_INV , plc.displayed_field Open_For , pll.po_line_id po_line_id2 , nvl(pll.po_release_id,-1) release_id , &company_name_lex Company_name_Q4 , &cost_center_lex Cost_Center_Q4 FROM po_line_locations pll , po_distributions pod , po_lines pol , po_lookup_codes plc , po_line_types plt , gl_code_combinations glcc WHERE pod.line_location_id = pll.line_location_id AND pol.po_line_id = pod.po_line_id AND pol.line_type_id = plt.line_type_id AND nvl(pll.closed_code,'OPEN') not in ('CLOSED', 'FINALLY CLOSED') AND nvl(pol.closed_code,'OPEN') not in ('CLOSED', 'FINALLY CLOSED') AND pll.shipment_type in ('STANDARD','BLANKET','SCHEDULED') AND nvl(pll.closed_code,'OPEN') = plc.lookup_code AND plc.lookup_type = 'DOCUMENT STATE' AND nvl(pll.cancel_flag,'N') = 'N' AND nvl(pol.cancel_flag,'N') = 'N' AND &company_name_lex = :company_name_q3 AND &cost_center_lex = :cost_center_q3 AND glcc.code_combination_id = pod.code_combination_id and pll.po_line_id=:po_line_id and nvl ( pll.po_release_id , - 1 )=:release_id1 ORDER BY pll.shipment_num, pod.distribution_num PO POXPOPAR_XML AR PO تقرير أوامر الشراء المفتوحة (حسب مركز التكلفة) (بتنسيق XML) Imported from BI Publisher Description: تقرير أوامر الشراء المفتوحة (حسب مركز التكلفة) Application: المشتريات Source: تقرير أوامر الشراء المفتوحة (حسب مركز التكلفة) (بتنسيق XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG D PO Bestellungen - offen nach Kostenstelle Imported from BI Publisher Description: Bestellungen - offen nach Kostenstelle Application: Einkauf Source: Bestellungen - offen nach Kostenstelle (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG E PO Informe Pedidos Abiertos por Centro de Coste Imported from BI Publisher Description: Pedidos Abiertos por Centro de Coste Application: Purchasing Source: Informe Pedidos Abiertos por Centro de Coste (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG F PO Etat des commandes en cours, par centre de coûts Imported from BI Publisher Description: Etat des commandes en cours, par centre de coûts Application: Purchasing Source: Etat des commandes en cours, par centre de coûts (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG I PO Rapporto Ordini di acquisto aperti (per centro di costo) Imported from BI Publisher Description: Rapporto Ordini di acquisto aperti (per centro di costo) Application: Purchasing Source: Rapporto Ordini di acquisto aperti (per centro di costo) (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG JA PO オープン発注レポート(コスト・センター別) Imported from BI Publisher Description: オープン発注レポート(コスト・センター別) Application: Purchasing Source: オープン発注レポート(コスト・センター別)(XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG KO PO 개설 구매발주 보고서(비용 부서별) Imported from BI Publisher Description: 개설 구매발주 보고서(원가중심점별) Application: Purchasing Source: 개설 구매발주 보고서(비용 부서별)(XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG PTB PO Relatório de Ordens de Compra em Aberto(por Centro de Custo) Imported from BI Publisher Description: Abrir Relatório de Ordens de Compra(por Centro de Custo) Application: Compra Source: Relatório de Ordens de Compra em Aberto(por Centro de Custo) (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG RU PO Отчет об открытых заказах на приобретение по местам возникновения затрат Imported from BI Publisher Description: Отчет об открытых заказах на приобретение по местам возникновения затрат Application: Закупки Source: Отчет об открытых заказах на приобретение по местам возникновения затрат (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG S PO Öppna inköpsorder per kostnadsställe - rapport Imported from BI Publisher Description: Öppna inköpsorder per kostnadsställe - rapport Application: Purchasing Source: Öppna inköpsorder per kostnadsställe - rapport (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG TR PO Açık Satın Alma Siparişleri Raporu (Maliyet Merkezi bazında) Imported from BI Publisher Description: Açık Satın Alma Siparişleri Raporu(Maliyet Merkezi bazında) Application: Satın Alma Yönetimi Source: Açık Satın Alma Siparişleri Raporu (Maliyet Merkezi bazında) (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG US PO Open Purchase Orders Report(by Cost Center) Imported from BI Publisher Description: Open Purchase Orders Report(by Cost Center) Application: Purchasing Source: Open Purchase Orders Report(by Cost Center) (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG ZHS PO 打开的采购订单报表（按成本中心） Imported from BI Publisher Description: 打开采购订单报表（按成本中心） Application: 采购管理系统 Source: 打开的采购订单报表（按成本中心）(XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG BI Publisher 1=1 :c_company_title :c_industry_code :format_mask :operating_unit :p_company_from :p_company_to :p_conc_request_id :p_costcenter_from :p_costcenter_to :p_flex_item :p_item_struct_num :p_orderby :p_orderby_displayed :p_qty_precision :p_title :where_clause 1 -10 :debugflag Char N AR علامة معالجة الأخطاء علامة معالجة الأخطاء D DebugFlag Debug-Kennzeichen E Depurar Depurar F Indicateur Diagnostic Indicateur Diagnostic I Flag Debug Flag Debug JA デバッグ・フラグ デバッグ・フラグ KO 디버그 플래그 디버그 플래그 PTB DebugFlag Indicador de Depuração RU Флаг отладки Флаг отладки S DebugFlag Debug Flag TR Hata Ayıklama İşareti Hata Ayıklama İşareti US DebugFlag Debug Flag ZHS 调试标志 调试标志 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_company_from LOV Oracle PO_SRS_COMPANIES Y select fnd_val.flex_value id, fnd_val.flex_value value, fnd_val.description description from fnd_segment_attribute_values fnd_seg,financials_system_parameters po,gl_sets_of_books gl,fnd_id_flex_segments fnd_id,fnd_flex_value_sets fnd_val_sets,fnd_flex_values_vl fnd_val where gl.set_of_books_id=po.set_of_books_id and fnd_seg.attribute_value='Y' and fnd_seg.segment_attribute_type='GL_BALANCING' and fnd_seg.id_flex_code='GL#' and fnd_seg.id_flex_num=gl.chart_of_accounts_id and fnd_id.id_flex_code='GL#' and fnd_id.id_flex_num=fnd_seg.id_flex_num and fnd_id.application_column_name= fnd_seg.application_column_name and fnd_id.flex_value_set_id= fnd_val_sets.flex_value_set_id and fnd_val_sets.flex_value_set_id= fnd_val.flex_value_set_id and fnd_val.summary_flag='N' order by value,description AR الشركات من الشركات من D Von Firma Von Firma E De Compañía De Compañía F Sociétés - De Sociétés - De I Aziende - Da Società - Da JA 会社:自 会社:自 KO 회사 From 회사 From PTB Empresas - De Empresas - De RU Компании с Компании с S Från företag Företag från TR Şirketler: İlk Şirketler: İlk US Companies From Companys From ZHS 公司自 公司自 5 30 :p_company_to LOV Oracle PO_SRS_COMPANIES Y select fnd_val.flex_value id, fnd_val.flex_value value, fnd_val.description description from fnd_segment_attribute_values fnd_seg,financials_system_parameters po,gl_sets_of_books gl,fnd_id_flex_segments fnd_id,fnd_flex_value_sets fnd_val_sets,fnd_flex_values_vl fnd_val where gl.set_of_books_id=po.set_of_books_id and fnd_seg.attribute_value='Y' and fnd_seg.segment_attribute_type='GL_BALANCING' and fnd_seg.id_flex_code='GL#' and fnd_seg.id_flex_num=gl.chart_of_accounts_id and fnd_id.id_flex_code='GL#' and fnd_id.id_flex_num=fnd_seg.id_flex_num and fnd_id.application_column_name= fnd_seg.application_column_name and fnd_id.flex_value_set_id= fnd_val_sets.flex_value_set_id and fnd_val_sets.flex_value_set_id= fnd_val.flex_value_set_id and fnd_val.summary_flag='N' order by value,description AR إلى الشركات إلى D Bis Bis Firma E A A Compañía F A Sociétés - A I A Società - A JA 至 会社:至 KO 까지 회사 To PTB Até Empresas - Até RU По Компании по S Till Företag till TR Son Şirketler: Son US To Companys To ZHS 至 公司自 6 40 :p_costcenter_from LOV Oracle PO_SRS_COST_CENTERS Y select fnd_val.flex_value id, fnd_val.flex_value value, fnd_val.description description from fnd_segment_attribute_values fnd_seg,financials_system_parameters po,gl_sets_of_books gl,fnd_id_flex_segments fnd_id,fnd_flex_value_sets fnd_val_sets,fnd_flex_values_vl fnd_val where gl.set_of_books_id=po.set_of_books_id and fnd_seg.attribute_value='Y' and fnd_seg.segment_attribute_type='FA_COST_CTR' and fnd_seg.id_flex_code='GL#' and fnd_seg.id_flex_num=gl.chart_of_accounts_id and fnd_id.id_flex_code='GL#' and fnd_id.id_flex_num=fnd_seg.id_flex_num and fnd_id.application_column_name= fnd_seg.application_column_name and fnd_id.flex_value_set_id= fnd_val_sets.flex_value_set_id and fnd_val_sets.flex_value_set_id= fnd_val.flex_value_set_id and fnd_val.summary_flag='N' order by value,description AR مراكز التكلفة من مراكز التكلفة من D Von Kostenstelle Von Kostenstelle E De Centro de Coste De Centro de Coste F Centres de coûts - De Centres de coûts - De I Centri di costo - Da Centri di costo - Da JA コスト・センター:自 コスト・センター:自 KO 비용 부서 From 비용 부서 From PTB Centros de Custo - De Centros de Custo - De RU Места возникновения затрат с Места возникновения затрат с S Från kostnadsställen Från kostnadsställen TR Maliyet Merkezleri: İlk Maliyet Merkezleri: İlk US Cost Centers From Cost Centers From ZHS 成本中心自 成本中心自 7 50 :p_costcenter_to LOV Oracle PO_SRS_COST_CENTERS Y select fnd_val.flex_value id, fnd_val.flex_value value, fnd_val.description description from fnd_segment_attribute_values fnd_seg,financials_system_parameters po,gl_sets_of_books gl,fnd_id_flex_segments fnd_id,fnd_flex_value_sets fnd_val_sets,fnd_flex_values_vl fnd_val where gl.set_of_books_id=po.set_of_books_id and fnd_seg.attribute_value='Y' and fnd_seg.segment_attribute_type='FA_COST_CTR' and fnd_seg.id_flex_code='GL#' and fnd_seg.id_flex_num=gl.chart_of_accounts_id and fnd_id.id_flex_code='GL#' and fnd_id.id_flex_num=fnd_seg.id_flex_num and fnd_id.application_column_name= fnd_seg.application_column_name and fnd_id.flex_value_set_id= fnd_val_sets.flex_value_set_id and fnd_val_sets.flex_value_set_id= fnd_val.flex_value_set_id and fnd_val.summary_flag='N' order by value,description AR إلى 2 مراكز التكلفة إلى D Bis 2 Bis Kostenstelle E A 2 A Centro de Coste F A 2 Centres de coûts - A I A 2 Centri costo - A JA 至 2 コスト・センター:至 KO 까지 2 비용 부서 To PTB Até 2 Centros de Custo - Até RU По 2 Места возникновения затрат по S Till 2 Kostnadsställen till TR Son 2 Maliyet Merkezleri: Son US To 2 Cost Centers To ZHS 至 2 成本中心至 8 60 :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 动态精确度选项 数量精确度 9 70 :p_orderby LOV Oracle PO_SRS_POXPOPAR_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 ('COMPANY','COST CENTER') order by displayed_field Y 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 排序依据 排序依据