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）限制的操作单元。 C6E085D471CA51A9E05362FB09050512Y SELECT prl.item_revision Rev , null C_FLEX_ITEM , null C_FLEX_CAT , prh.segment1 Req_Number , prl.line_num Line , prl.deliver_to_location_id Location_id , prl.need_by_date Need_by_date , prl.creation_date Order_by_date , papf1.full_name Requestor , prl.unit_meas_lookup_code Unit , decode(plt.order_type_lookup_code, 'AMOUNT',null,prl.quantity) Quantity , decode(plt.order_type_lookup_code, 'AMOUNT',null,prl.unit_price) Price , DECODE (PLT.order_type_lookup_code, 'FIXED PRICE', PRL.amount, 'RATE', PRL.amount, PRL.quantity * PRL.unit_price) Amount , prl.note_to_agent Note_to_buyer , prl.suggested_vendor_name Suggested_vendor , decode(prl.blanket_po_header_id, NULL,NULL, poh.segment1||'-'||prl.blanket_po_line_num) Suggested_Blanket_PO , papf2.full_name Suggested_Buyer , T.type_name Suggested_Document_Type , prl.item_description Description , msi.inventory_item_id item_id, 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, NVL2(prl.item_id,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'),NULL) C_FLEX_ITEM_DISP, PO_POXRQUNI_XMLP_PKG.locationformula(prl.deliver_to_location_id) Location FROM per_all_people_f papf1 , per_all_people_f papf2 , po_headers poh , po_line_types plt , mtl_system_items msi , mtl_categories mca , po_requisition_lines prl , po_requisition_headers prh , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T, PO_DOCUMENT_TYPES_ALL_B B WHERE prl.line_location_id is NULL AND nvl(prl.reqs_in_pool_flag,'Y') = 'Y' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED' AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.cancel_flag,'N') = 'N' AND prl.source_type_code = 'VENDOR' AND prh.authorization_status = 'APPROVED' AND prh.requisition_header_id = prl.requisition_header_id AND NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND msi.inventory_item_id (+) = prl.item_id AND nvl(msi.organization_id ,nvl(:c_organization_id,-1)) = nvl(:c_organization_id,-1) AND mca.category_id (+) = prl.category_id AND prl.deliver_to_location_id = nvl(:p_location_id,prl.deliver_to_location_id) AND papf1.person_id (+) = prl.to_person_id AND B.document_subtype(+) = prl.document_type_code AND nvl(B.document_type_code, 'PA') in ('QUOTATION','PA') 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 (+)= prl.ORG_ID AND T.LANGUAGE(+) = USERENV('LANG') AND papf1.full_name = nvl(:P_requestor, papf1.full_name) AND papf2.person_id (+) = prl.suggested_buyer_id AND trunc(sysdate) between papf1.effective_start_date(+) AND papf1.effective_end_date (+) AND decode(hr_security.view_all,'Y','TRUE', hr_security.show_record('PER_ALL_PEOPLE_F', papf1.person_id(+),papf1.person_type_id(+),papf1.employee_number(+),papf1.applicant_number(+) ,papf1.npw_number(+) ))='TRUE' AND decode(hr_general.get_xbg_profile,'Y',papf1.business_group_id(+),hr_general.get_business_group_id)=papf1.business_group_id(+) AND trunc(sysdate) between papf2.effective_start_date (+) AND papf2.effective_end_date (+)AND decode(hr_security.view_all,'Y','TRUE', hr_security.show_record('PER_ALL_PEOPLE_F', papf2.person_id(+),papf2.person_type_id(+),papf2.employee_number(+),papf2.applicant_number(+) ,papf2.npw_number(+) ))='TRUE' AND decode(hr_general.get_xbg_profile,'Y',papf2.business_group_id(+),hr_general.get_business_group_id)=papf2.business_group_id(+) AND prl.line_type_id = plt.line_type_id AND prl.blanket_po_header_id = poh.po_header_id (+) AND ( nvl(prl.suggested_vendor_name,' ') BETWEEN nvl(:P_suggested_vendor_from, nvl(prl.suggested_vendor_name,' ')) AND nvl(:P_suggested_vendor_to, nvl(prl.suggested_vendor_name,' '))) AND (nvl(prl.need_by_date, DECODE(:P_needby_date_from,'1900/01/01', sysdate,:P_needby_date_from-1)) >= nvl(:P_needby_date_from,nvl(prl.need_by_date,sysdate-1))) AND (nvl(prl.need_by_date, DECODE(:P_need_by_date_to,'9999/01/01', sysdate,:P_need_by_date_to+1)) <= nvl(:P_need_by_date_to, nvl(prl.need_by_date,sysdate+1))) AND &P_WHERE_CAT AND ((decode(psp.manual_req_num_type,'NUMERIC',decode(rtrim(prh.segment1,'0123456789'),NULL, to_number(prh.segment1),-1),null) BETWEEN decode(psp.manual_req_num_type,'NUMERIC', to_number(nvl(:p_req_num_from,decode(rtrim(prh.segment1,'0123456789'), NULL,to_number(prh.segment1),-1))),null) AND decode(psp.manual_req_num_type,'NUMERIC', to_number(nvl(:p_req_num_to,decode(rtrim(prh.segment1,'0123456789'), NULL,to_number(prh.segment1),-1))),null)) OR (prh.segment1 BETWEEN decode(psp.manual_req_num_type,'ALPHANUMERIC', nvl(:P_req_num_from,prh.segment1),null) AND decode(psp.manual_req_num_type,'ALPHANUMERIC', nvl(:P_req_num_to,prh.segment1),null))) ORDER BY 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') , 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'), prl.creation_date, prl.requisition_line_id PO POXRQUNI_XML AR PO تقرير إجراء طلب شراء المشتري المطلوب (بتنسيق XML) Imported from BI Publisher Description: تقرير إجراء طلب شراء المشتري المطلوب Application: المشتريات Source: تقرير إجراء طلب شراء المشتري المطلوب (بتنسيق XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG D PO Anforderungen - ausstehende Vorgänge Imported from BI Publisher Description: Anforderungen - ausstehende Vorgänge Application: Einkauf Source: Anforderungen - ausstehende Vorgänge (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG E PO Informe Solicitudes Pendientes del Comprador Imported from BI Publisher Description: Informe Solicitudes Pendientes del Comprador Application: Purchasing Source: Informe Solicitudes Pendientes del Comprador (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG F PO Etat des actions à réaliser sur D.A. par acheteur Imported from BI Publisher Description: Etat des actions à réaliser sur D.A. par acheteur Application: Purchasing Source: Etat des actions à réaliser sur D.A. par acheteur (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG I PO Rapporto Azione obbligatoria per richiesta di acquisto del buyer Imported from BI Publisher Description: Rapporto Azione obbligatoria per richiesta di acquisto del buyer Application: Purchasing Source: Rapporto Azione obbligatoria per richiesta di acquisto del buyer (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG JA PO 購買担当別購買依頼処理指定レポート Imported from BI Publisher Description: 購買担当別購買依頼処理指定レポート Application: Purchasing Source: 購買担当別購買依頼処理指定レポート(XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG KO PO 구매자의 구매요청 조치 필수 보고서 Imported from BI Publisher Description: 구매자 구매요청 실행 요구 보고서 Application: Purchasing Source: 구매자의 구매요청 조치 필수 보고서(XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG PTB PO Relatório da Ação Necessária de Requisição do Comprador Imported from BI Publisher Description: Relatório Necessário da Ação de Requisição do Comprador Application: Compra Source: Relatório da Ação Necessária de Requisição do Comprador (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG RU PO Отчет о необходимых действиях по заявкам покупателей Imported from BI Publisher Description: Отчет о необходимых действиях по заявкам покупателей Application: Закупки Source: Отчет о необходимых действиях по заявкам покупателей (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG S PO Inköpsrekvisitioner att åtgärda - rapport Imported from BI Publisher Description: Inköpsrekvisitioner att åtgärda - rapport Application: Purchasing Source: Inköpsrekvisitioner att åtgärda - rapport (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG TR PO Satın Alanın Talep Eylemi için Gerekli Rapor Imported from BI Publisher Description: Satın Alan için Gerekli Talep Eylemi Raporu Application: Satın Alma Yönetimi Source: Satın Alanın Talep Eylemi için Gerekli Rapor (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG US PO Buyer's Requisition Action Required Imported from BI Publisher Description: Buyer's Requisition Action Required Report Application: Purchasing Source: Buyer's Requisition Action Required Report (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG ZHS PO 采购员请购活动报表 Imported from BI Publisher Description: 采购员请购活动报表 Application: 采购管理系统 Source: 采购员请购活动报表 (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG BI Publisher &p_where_cat :c_organization_id :format_mask :operating_unit :p_base_currency :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_flex_item :p_item_struct_num :p_location :p_location_id :p_need_by_date_to :p_need_by_date_to1 :p_needby_date_from :p_needby_date_from1 :p_print_price_history :p_print_price_history_1 :p_print_price_history_disp :p_qty_precision :p_req_num_from :p_req_num_to :p_requestor :p_struct_num :p_suggested_vendor_from :p_suggested_vendor_to :p_title :p_where_cat 1 -30 :p_struct_num Number SELECT STRUCTURE_ID FROM MTL_DEFAULT_SETS_VIEW WHERE FUNCTIONAL_AREA_ID = 2 Y US P_STRUCT_NUM P_STRUCT_NUM 2 -20 :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 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_suggested_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 vorgeschlagener Lieferant Von vorgeschlagener Lieferant E De Proveedor Propuesto De Proveedor Propuesto F Fournisseurs proposés - De Fournisseurs proposés - De I Fornitori consigliati - Da Fornitori consigliati - Da JA 提示仕入先:自 提示仕入先:自 KO 제안된 공급자: 부터 제안된 공급자: 부터 PTB Fornecedores Sugeridos - De Fornecedores Sugeridos - De RU Предложенные поставщики с Предложенные поставщики с S Föreslagna leverantörer från Föreslagna leverantörer från TR Önerilen Tedarikçiler: İlk Önerilen Tedarikçiler: İlk US Suggested Vendors From Suggested Vendors From ZHS 建议供应商自 建议供应商自 6 30 :p_suggested_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 E A A F A A I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 7 40 :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 类别自 类别自 8 50 :p_category_to Char AR إلى 2 إلى D Bis 2 Bis E A 2 A F A 2 A I A 2 A JA 至 2 至 KO 까지 2 까지 PTB Até 2 Até RU По 2 По S Till 2 Till TR Son 2 Son US To 2 To ZHS 至 2 至 9 60 :p_needby_date_from Date AR مطلوب في تواريخ من مطلوب في تواريخ من D Von Bedarfsdatum Von Bedarfsdatum E De Fecha Requerida De Fecha Requerida F Dates de besoin - Du Dates de besoin - Du I Date limite - Da Date limite - Da JA 希望入手日:自 希望入手日:自 KO 납품 요청 일자: 부터 납품 요청 일자: 부터 PTB Datas da Necessidade - De Datas da Necessidade - De RU Требуемые даты поставки с Требуемые даты поставки с S Behovsdatum från Behovsdatum från TR Gereksinim Tarihi: İlk Gereksinim Tarihi: İlk US Need By Dates From Need By Dates From ZHS 需要日期自 需要日期自 10 70 :p_need_by_date_to Date AR إلى 3 مطلوب في تواريخ إلى D Bis 3 Bis Bedarfsdatum E A 3 A Fecha Requerida F Au Dates de besoin - Au I A 3 Necessario il - A JA 至 3 希望入手期日 KO 까지 3 납기 요청일자 To PTB Até 3 Datas da Necessidade - Até RU По 3 Требуемые даты поставки по S Till 3 Behovsdatum till TR Son 3 Gereksinim Tarihi: Son US To 3 Need By Dates To ZHS 至 3 需要日期至 11 80 :p_location LOV Oracle PO_SRS_LOCATION Y select location_code id, location_code value, null description from hr_locations order by location_code AR الموقع الموقع D Standort Standort E Ubicación Ubicación F Lieu Lieu I Ubicazione Ubicazione JA 事業所 事業所 KO 위치 위치 PTB Local Local RU Расположение Расположение S Adress Adress TR Yerleşim Yerleşim US Location Location ZHS 地点 地点 12 90 :p_requestor LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR الطالب الطالب D Anforderer Anforderer E Solicitante Solicitante F Demandeur Demandeur I Richiedente Richiedente JA 依頼者 依頼者 KO 요청자 요청자 PTB Solicitante Solicitante RU Автор запроса Автор запроса S Beställare Beställare TR İstek Sahibi İstek Sahibi US Requester Requester ZHS 申请人 申请人 13 100 :p_req_num_from LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR أرقام طلب الشراء من أرقام طلب الشراء من D Von Anforderungsnummer Von Anforderungsnummer E De Número de Solicitud De Número de Solicitud F Numéros de demande d'approvisionnement - De Numéros de demande d'appro - De I Numeri RdA - Da Numeri RdA - Da JA 購買依頼番号:自 購買依頼番号:自 KO 구매요청 번호: 부터 구매요청 번호: 부터 PTB Números da Requisição - De Números de Requisição - De RU Номера заявок с Номера заявок с S Från rekvisitionsnummer Från rek.nummer TR Talep Numaraları, İlk Talep Numaraları: İlk US Requisition Numbers From Req Numbers From ZHS 申请编号自 申请编号自 14 110 :p_req_num_to LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR إلى 4 أرقام طلب الشراء إلى D Bis 4 Bis Anforderungsnummer E A 4 A Número de Solicitud F A 3 Numéros de demande d'appro - A I A 4 Numeri richieste di acquisto - A JA 至 4 購買依頼番号:至 KO 까지 4 구매요청 번호: 까지 PTB Até 4 Números de Requisição - Até RU По 4 Номера заявок по S Till 4 Till rek.nummer TR Son 4 Talep Numaraları: Son US To 4 Req Numbers To ZHS 至 4 申请编号至 15 120 :p_print_price_history 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 Preishistorie drucken Preishistorie drucken E Imprimir Historial Precios Imprimir Historial Precios F Imprimer l'historique des prix Imprimer l'historique des prix I Stampa cronologia prezzi Stampa cronologia prezzi JA 価格履歴の印刷 価格履歴の印刷 KO 가격 내역 인쇄 가격 내역 인쇄 PTB Impr. Hist. Preços Impr. Hist. Preços RU Печать истории цен Печать истории цен S Skriv ut prishistorik Skriv ut prishistorik TR Fiyat Tarihçesi Yazdır Fiyat Tarihçesi Yazdır US Print Price History Print Price History ZHS 打印价格历史记录 打印价格历史记录 16 130 :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 动态精确度选项 数量精确度