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）限制的操作单元。 C6E085D471C451A9E05362FB09050512 SELECT trunc(prh.creation_date) Creation_Date , prh.segment1 Requisition_Number , papf.full_name Preparer , t.type_name Type , prh.description Description , SUM (DECODE (PRL.order_type_lookup_code, 'FIXED PRICE', NVL(PRL.amount, 0), 'RATE', NVL(PRL.amount, 0), NVL(PRL.quantity, 0) * NVL(PRL.unit_price, 0))) C_AMOUNT_REQ, PO_POXREQAC_XMLP_PKG.round_amount_sum_req(:C_AMOUNT_SUM_REQ, :C_CURRENCY_PRECISION) C_AMOUNT_SUM_REQ_ROUND, PO_POXREQAC_XMLP_PKG.round_amount_req(SUM ( DECODE ( PRL.order_type_lookup_code , 'FIXED PRICE' , NVL ( PRL.amount , 0 ) , 'RATE' , NVL ( PRL.amount , 0 ) , NVL ( PRL.quantity , 0 ) * NVL ( PRL.unit_price , 0 ) ) ), :C_CURRENCY_PRECISION) C_AMOUNT_REQ_ROUND FROM po_requisition_lines prl , po_requisition_headers prh , per_all_people_f papf , po_document_types_all_tl t , po_document_types_all_b b WHERE trunc(prh.creation_date) >= decode(:P_Creation_Date_From,'', trunc(prh.creation_date), :P_Creation_Date_From) AND trunc(prh.creation_date) <= decode(:P_Creation_Date_To,'', trunc(prh.creation_date), :P_Creation_Date_To) AND papf.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) 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 papf.person_id = prh.preparer_id AND papf.full_name = decode(:P_Preparer,'',papf.full_name, :P_Preparer) AND prh.type_lookup_code = decode(:P_Type,'',prh.type_lookup_code, :P_Type) AND prh.authorization_status <> 'SYSTEM_SAVED' AND NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prl.requisition_header_id = prh.requisition_header_id 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 = prh.org_id AND t.language = userenv('lang') AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND NVL(prl.cancel_flag, 'N') = 'N' GROUP BY prh.creation_date , papf.full_name , t.type_name , prh.description , prh.segment1 , prl.currency_code ORDER BY prh.creation_date , papf.full_name Y PO POXREQAC_XML AR PO مسجل نشاط طلب الشراء (بتنسيق XML) Imported from BI Publisher Description: مسجل نشاط طلب الشراء Application: المشتريات Source: مسجل نشاط طلب الشراء (بتنسيق XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG D PO Anforderungen - Aktivitäten Imported from BI Publisher Description: Anforderungen - Aktivitäten Application: Einkauf Source: Anforderungen - Aktivitäten (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG E PO Registro de Solicitudes Imported from BI Publisher Description: Registro de Solicitudes Application: Purchasing Source: Registro de Solicitudes (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG F PO Registre des demandes d'approvisionnement Imported from BI Publisher Description: Registre des demandes d'approvisionnement Application: Purchasing Source: Registre des demandes d'approvisionnement (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG I PO Registro attività richieste di acquisto Imported from BI Publisher Description: Registro attività richieste di acquisto Application: Purchasing Source: Registro attività richieste di acquisto (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG JA PO 購買依頼活動台帳 Imported from BI Publisher Description: 購買依頼活動台帳 Application: Purchasing Source: 購買依頼活動台帳(XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG KO PO 구매요청 활동 등록 Imported from BI Publisher Description: 구매요청 활동 등록 Application: Purchasing Source: 구매요청 활동 등록(XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG PTB PO Registro de Atividade da Requisição Imported from BI Publisher Description: Registro da Atividade de Requisição Application: Compra Source: Registro de Atividade da Requisição (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG RU PO Реестр операций по заявкам Imported from BI Publisher Description: Реестр операций по заявкам Application: Закупки Source: Реестр операций по заявкам (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG S PO Registrering av rekvisitionsaktiviteter Imported from BI Publisher Description: Register över rekvisitionsaktiviteter Application: Purchasing Source: Registrering av rekvisitionsaktiviteter (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG TR PO Talep Aktivite Kaydı Imported from BI Publisher Description: Talep Aktivitesi Kaydı Application: Satın Alma Yönetimi Source: Talep Aktivite Kaydı (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG US PO Requisition Activity Register Imported from BI Publisher Description: Requisition Activity Register Application: Purchasing Source: Requisition Activity Register (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG ZHS PO 申请活动登记表 Imported from BI Publisher Description: 申请活动登记表 Application: 采购管理系统 Source: 申请活动登记表 (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG BI Publisher :c_amount_sum_req :c_currency_precision :lp_creation_date_from :lp_creation_date_to :operating_unit :p_base_currency :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_preparer :p_title :p_type :p_type_displayed 1 -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 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_creation_date_from Date 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 Creation Dates From Creation Dates From ZHS 创建日期自 创建日期自 5 30 :p_creation_date_to Date AR إلى تواريخ التكوين إلى D Bis Bis Erstellungsdatum E A A Fecha de Creación F Au Dates de création - Au I A Date creazione - A JA 至 作成日:至 KO 까지 생성일자: 까지 PTB Até Datas de Criação - Até RU По Даты создания по S Till Till skapandedatum TR Son Oluşturma Tarihleri: Son US To Creation Dates To ZHS 至 创建日期至 6 40 :p_preparer LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR المُعِد المُعِد D Bearbeiter Bearbeiter E Preparador Preparador F Emetteur Emetteur I Preparatore Preparatore JA 作成者 作成者 KO 작성자 작성자 PTB Preparador Preparador RU Составитель Составитель S Handläggare Handläggare TR Hazırlayan Hazırlayan US Preparer Preparer ZHS 编制人 编制人 7 50 :p_type LOV Oracle PO_SRS_REQUISITION_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='REQUISITION TYPE' order by displayed_field AR نوع طلب الشراء النوع D Anforderungsart Art E Tipo de Solicitud Tipo F Type de demande d'approvisionnement Type I Tipo richiesta Tipo JA 購買依頼タイプ タイプ KO 구매요청 유형 유형 PTB Tipo Requisição Tipo RU Тип заявки Тип S Rekvisitionstyp Typ TR Talep Tipi Tip US Requisition Type Type ZHS 申请类型 类型