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）限制的操作单元。 C6E085D471BB51A9E05362FB09050512Y SELECT (poh.segment1) PO_NUM , (poh.segment1 || DECODE(por.release_num, NULL, '', ' - ' || por.release_num)) PO_REL_Disp , (plkc.displayed_field) Source , (pod.gl_encumbered_date) Reserved_Date , (pol.line_num) Line , (pll.shipment_num) Shipment , (pod.distribution_num) Distribution , pod.po_distribution_id Parent_join_id , pol.item_description Item_Description , nvl(pod.quantity_ordered, 0) quantity_ordered , nvl(pod.quantity_cancelled, 0) quantity_cancelled , nvl(pod.quantity_billed, 0) quantity_billed , nvl(pod.quantity_delivered,0) quantity_delivered , nvl(pll.price_override,0) price_override , nvl(pod.rate, 1) rate , pod.po_release_id po_release_id , pod.po_header_id po_header_id , pod.po_line_id po_line_id , pod.line_location_id po_line_location_id , pod.gl_encumbered_date gl_encumbered_date , pod.encumbered_amount po_enc_amount_func , pll.shipment_type po_type , (pol.unit_meas_lookup_code) Unit , poh.currency_code Currency , pod.budget_account_id ccid , (pll.price_override) Unit_Price , (poh.currency_code) C_CURRENCY_PO , pod.accrue_on_receipt_flag accrual_flag , pod.accrual_account_id accrual_ccid , pod.destination_type_code dest , nvl(pll.cancel_flag,'N') cancel , nvl(pod.nonrecoverable_tax,0) nonrecov_tax, PO_POXPOEDR_XMLP_PKG.adjusted_q_orderedformula(pll.shipment_type, pod.po_header_id, pod.po_line_id, pod.po_distribution_id, nvl ( pod.quantity_ordered , 0 )) Adjusted_q_ordered, PO_POXPOEDR_XMLP_PKG.c_amount_base_poformula(pll.shipment_type, pod.encumbered_amount, pod.accrue_on_receipt_flag, pod.po_distribution_id, :C_PRECISION) C_AMOUNT_BASE_PO, PO_POXPOEDR_XMLP_PKG.c_amount_func_poformula(:C_AMOUNT_BASE_PO, :C_CURRENCY_BASE1, poh.currency_code, nvl ( pod.rate , 1 ), :C_PRECISION) C_AMOUNT_FUNC_PO, PO_POXPOEDR_XMLP_PKG.CP_PRECISION_PO_p CP_PRECISION_PO, PO_POXPOEDR_XMLP_PKG.CP_OLD_PO_CUR_p CP_OLD_PO_CUR FROM po_distributions_all pod , po_releases_all por , po_lookup_codes plkc , po_line_locations_all pll , po_lines_all pol , po_headers_all poh , po_vendors pov WHERE pod.po_release_id = por.po_release_id (+) AND poh.po_header_id = pod.po_header_id AND pod.po_line_id = pol.po_line_id AND pod.line_location_id = pll.line_location_id AND ( nvl(pod.encumbered_flag , 'N' ) = 'Y' OR (nvl(pod.encumbered_flag, 'N') = 'N' and nvl(pll.cancel_flag, 'N') = 'Y') ) AND pod.gl_encumbered_date BETWEEN nvl(:P_encumbrance_date_from, pod.gl_encumbered_date-1) AND nvl(:P_encumbrance_date_to, pod.gl_encumbered_date+1) AND (nvl(:P_ACTIVE_ONLY, 'N') = 'N' OR (nvl(:P_ACTIVE_ONLY, 'N') = 'Y' and poh.closed_date is null)) AND pov.vendor_id(+) = poh.vendor_id AND nvl(pov.vendor_name,'A') between nvl(:P_Vendor_From,nvl(pov.vendor_name,'A') ) and nvl(:P_Vendor_To,nvl(pov.vendor_name,'A') ) AND nvl(:P_TYPE,'PO') != 'REQUISITION' AND plkc.lookup_type = 'PO HEADER' AND plkc.lookup_code = 'VENDOR' AND nvl(pod.prevent_encumbrance_flag,'N') = 'N' and nvl(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED' and nvl(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED' and pod.budget_account_id = :GL_Code_Id and pod.org_id=po_moac_utils_pvt.get_current_org_id and pod.budget_account_id=:GL_Code_Id ORDER BY poh.currency_code, poh.segment1, pol.line_num, pll.shipment_num, pod.distribution_num PO POXPOEDR_XML AR PO تقرير تفاصيل الالتزام (بتنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل الالتزام Application: المشتريات Source: تقرير تفاصيل الالتزام (بتنسيق XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG D PO Obligo - Details Imported from BI Publisher Description: Obligo - Details Application: Einkauf Source: Obligo - Details (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG E PO Detalle de Compromisos Imported from BI Publisher Description: Detalle de Compromisos Application: Purchasing Source: Detalle de Compromisos (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG F PO Etat détaillé des engagements Imported from BI Publisher Description: Etat détaillé des engagements Application: Purchasing Source: Etat détaillé des engagements (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG I PO Rapporto Dettagli impegno Imported from BI Publisher Description: Rapporto Dettagli impegno Application: Purchasing Source: Rapporto Dettagli impegno (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG JA PO 引当詳細レポート Imported from BI Publisher Description: 引当詳細レポート Application: Purchasing Source: 引当詳細レポート(XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG KO PO 예산가집행 상세 보고서 Imported from BI Publisher Description: 예산가집행 상세 보고서 Application: Purchasing Source: 예산가집행 상세 보고서(XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG PTB PO Relatório Detalhado de Empenho Imported from BI Publisher Description: Relatório Detalhado de Empenho Application: Compra Source: Relatório Detalhado de Empenho (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG RU PO Подробный отчет об обязательствах Imported from BI Publisher Description: Подробный отчет об обязательствах Application: Закупки Source: Подробный отчет об обязательствах (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG S PO Avsättningar - detaljrapport Imported from BI Publisher Description: Avsättningar - detaljrapport Application: Purchasing Source: Avsättningar - detaljrapport (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG TR PO Bütçe Sınırlama Detay Raporu Imported from BI Publisher Description: Bütçe Sınırlama Detay Raporu Application: Satın Alma Yönetimi Source: Bütçe Sınırlama Detay Raporu (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG US PO Encumbrance Detail Imported from BI Publisher Description: Encumbrance Detail Report Application: Purchasing Source: Encumbrance Detail Report (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG ZHS PO 保留款明细报表 Imported from BI Publisher Description: 保留款明细报表 Application: 采购管理系统 Source: 保留款明细报表 (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG BI Publisher :c_amount_base_po :c_currency_base1 :c_precision :cp_old_bpo_cur :cp_old_po_cur :cp_precision_bpo :cp_precision_po :gl_code_id :operating_unit :p_account_from :p_account_to :p_active_only :p_chart_of_accounts :p_conc_request_id :p_cost_center_from :p_cost_center_to :p_encumbrance_date_from :p_encumbrance_date_to :p_flex_acc :p_orderby_acc :p_qty_precision :p_struct_num :p_title :p_type :p_type_displayed :p_vendor_from :p_vendor_to :p_where_acc :qty_precision 1 -20 :p_chart_of_accounts Number select gsob.chart_of_accounts_id from gl_sets_of_books gsob, financials_system_parameters fsp where fsp.set_of_books_id = gsob.set_of_books_id Y AR P_CHART_OF_ACCOUNTS معامل افتراضي للحصول على جدول تصنيف الحسابات D P_CHART_OF_ACCOUNTS Dummy-Parameter zum Abruf des Kontenplans E P_CHART_OF_ACCOUNTS parámetro ficticio para obtener un plan de cuentas F P_CHART_OF_ACCOUNTS paramètre fictif pour obtenir le plan de comptes I P_CHART_OF_ACCOUNTS parametro fittizio per richiamare piano dei conti JA P_CHART_OF_ACCOUNTS 勘定体系を得るためのダミー・パラメータ KO P_CHART_OF_ACCOUNTS 계정 코드집을 얻기 위한 dummy 매개변수 PTB P_CHART_OF_ACCOUNTS parâmetro fictício para obter plano de contas RU P_CHART_OF_ACCOUNTS Фиктивный параметр для получения плана счетов S P_CHART_OF_ACCOUNTS Dummy-parameter för att hämta kontoplan TR P_CHART_OF_ACCOUNTS Hesap planı elde etmek için sözde parametre US P_CHART_OF_ACCOUNTS dummy parameter to get chart of accounts ZHS P_CHART_OF_ACCOUNTS 获取科目表的虚拟参数 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_account_from Char AR حسابات من حسابات من D Von Konto Von Konto E De Cuenta De Cuenta F Comptes - De Comptes - De I Conti - Da Conti - Da JA 勘定科目:自 勘定科目:自 KO 계정: From 계정: From PTB Contas - De Contas - De RU Счета с Счета с S Från konton Från konton TR Hesaplar, İlk Hesaplar, İlk US Accounts From Accounts From ZHS 帐户自 帐户自 5 30 :p_account_to Char AR إلى الحسابات إلى D Bis Bis Konto E A A Cuenta F A Comptes - A I A Conti - A JA 至 勘定科目:至 KO 까지 계정 To PTB Até Contas - Até RU По Счета по S Till Till konton TR Son Hesaplar, Son US To Accounts To ZHS 至 帐户至 6 40 :p_cost_center_from Char 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_cost_center_to Char 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_encumbrance_date_from Date AR تواريخ الالتزام من تواريخ الالتزام من D Von Obligodatum Von Obligodatum E De Fecha de Compromiso De Fecha de Compromiso F Dates d'engagement - Du Dates d'engagement - Du I Date impegno - Da Date impegno - Da JA 引当日:自 引当日:自 KO 예산 가집행 일자: 부터 예산 가집행 일자: 부터 PTB Datas de Empenho - De Datas de Empenho - De RU Даты обязательств с Даты обязательств с S Från avsättningsdatum Från avsättningsdatum TR Bütçe Sınırlama Tarihleri: İlk Bütçe Sınırlama Tarihleri: İlk US Encumbrance Dates From Encumbrance Dates From ZHS 保留款日期自 保留款日期自 9 70 :p_encumbrance_date_to Date AR إلى 3 تواريخ الالتزام إلى D Bis 3 Bis Obligodatum E A 3 A Fecha de Compromiso F Au Dates d'engagement - Au I A 3 Date impegno - A JA 至 3 予算引当日:至 KO 까지 3 예산 가집행 일자: 까지 PTB Até 3 Datas de Empenho - Até RU По 3 Даты обязательств по S Till 3 Avsättningsdatum till TR Son 3 Bütçe Sınırlama Tarihleri: Son US To 3 Encumbrance Dates To ZHS 至 3 保留款日期至 10 80 :p_type LOV Oracle PO_SRS_POXRRCVV_DOCUMENT_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='DOCUMENT TYPE' and lookup_code in ('PO','REQUISITION') order by value,description AR نوع المستند نوع المستند D Dokumentart Dokumentart E Tipo de Documento Tipo de Documento F Type de document Type de document I Tipo documento Tipo di documento JA 文書タイプ 文書タイプ KO 문서 유형 문서 유형 PTB Tipo de Documento Tipo de Documento RU Тип документа Тип документа S Dokumenttyp Dokumenttyp TR Doküman Tipi Doküman Tipi US Document Type Document Type ZHS 单据类型 单据类型 11 90 :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 供应商自 供应商自 12 100 :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 إلى 4 إلى D Bis 4 Bis E A 4 A F A 3 A I A 4 A JA 至 4 至 KO 까지 4 까지 PTB Até 4 Até RU По 4 По S Till 4 Till TR Son 4 Son US To 4 To ZHS 至 4 至 13 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 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 动态精确度选项 数量精确度