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）限制的操作单元。 82288223F3D43869E053B46B63588994 select x.operating_unit, x.requisition_number, x.requisition_type, x.requisition_date, x.created_by, x.preparer, x.cancelled_date, x.cancelled_by, x.cancelled_reason -- line &lp_line_cols from ( select -- header mgoat.organization_name operating_unit, prh.segment1 requisition_number, t.type_name requisition_type, trunc(prh.creation_date) requisition_date, nvl(papf3.full_name,fu.user_name || ' (' || fu.description || ')') created_by, papf.full_name preparer, trunc(pah.action_date) cancelled_date, papf2.full_name cancelled_by, pah.note cancelled_reason, -- line prl.line_num line_number, mc.concatenated_segments category, msi.concatenated_segments item, prl.item_revision item_revision, prl.item_description line_description, prl.unit_meas_lookup_code uom, prl.quantity quantity, prl.unit_price unit_price, papf4.full_name requestor, trunc(prl.cancel_date) line_cancelled_date, prl.cancel_reason line_cancelled_reason, -- decode(psp1.manual_req_num_type, 'NUMERIC' ,null, prh.segment1) ord_sort_1, decode(psp1.manual_req_num_type, 'NUMERIC' ,to_number(prh.segment1), null) ord_sort_2 from po_requisition_headers_all prh, fnd_user fu, per_all_people_f papf, per_all_people_f papf2, per_all_people_f papf3, po_action_history pah, po_document_types_all_tl t, po_document_types_all_b b, po_system_parameters_all psp1, mo_glob_org_access_tmp mgoat, -- financials_system_params_all fspa, (select prl.* from po_requisition_lines_all prl where :p_show_lines = 'Y' ) prl, per_all_people_f papf4, mtl_categories_kfv mc, mtl_system_items_vl msi where 1=1 and prh.org_id = psp1.org_id and prh.org_id = mgoat.organization_id and pah.object_id = prh.requisition_header_id and pah.object_type_code = 'REQUISITION' and pah.action_code = 'CANCEL' and prh.type_lookup_code = b.document_subtype 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 nvl(prh.contractor_requisition_flag, 'N') <> 'Y' and papf.person_id = prh.preparer_id and papf2.person_id = pah.employee_id and fu.user_id = prh.created_by and papf3.person_id(+) = fu.employee_id -- and fspa.org_id = prh.org_id and prl.requisition_header_id(+)= prh.requisition_header_id and nvl(prl.modified_by_agent_flag,'N') = 'N' and mc.category_id(+) = prl.category_id and msi.inventory_item_id(+) = prl.item_id and nvl(msi.organization_id,fspa.inventory_organization_id) = fspa.inventory_organization_id and papf4.person_id(+) = prl.to_person_id -- and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and decode(hr_general.get_xbg_profile,'Y', papf.business_group_id , hr_general.get_business_group_id) = papf.business_group_id and trunc(sysdate) between papf2.effective_start_date and papf2.effective_end_date and decode(hr_general.get_xbg_profile,'Y', papf2.business_group_id , hr_general.get_business_group_id) = papf2.business_group_id and trunc(sysdate) between papf3.effective_start_date (+) and papf3.effective_end_date (+) and decode(hr_general.get_xbg_profile,'Y', papf3.business_group_id(+) , hr_general.get_business_group_id) = papf3.business_group_id(+) and trunc(sysdate) between papf4.effective_start_date (+) and papf4.effective_end_date (+) and decode(hr_general.get_xbg_profile,'Y', papf4.business_group_id(+) , hr_general.get_business_group_id) = papf4.business_group_id(+) ) x order by x.ord_sort_1, x.ord_sort_2, x.line_number Y PO POXRQCRQ_XML AR PO تقرير طلبات الشراء الملغاة (بتنسيق XML) Application: المشتريات Source: تقرير طلبات الشراء الملغاة (بتنسيق XML) Short Name: POXRQCRQ_XML DB package: PO_POXRQCRQ_XMLP_PKG D PO Anforderungen - storniert Application: Einkauf Source: Anforderungen - storniert (XML) Short Name: POXRQCRQ_XML DB package: PO_POXRQCRQ_XMLP_PKG F PO Etat des demandes d'approvisionnement annulées Application: Purchasing Source: Etat des demandes d'approvisionnement annulées (XML) Short Name: POXRQCRQ_XML DB package: PO_POXRQCRQ_XMLP_PKG US PO Cancelled Requisitions Application: Purchasing Source: Cancelled Requisition Report (XML) Short Name: POXRQCRQ_XML DB package: PO_POXRQCRQ_XMLP_PKG ZHS PO 已取消的申请报表 Application: 采购管理系统 Source: 已取消的申请报表 (XML) Short Name: POXRQCRQ_XML DB package: PO_POXRQCRQ_XMLP_PKG Enginatics &lp_line_cols 1=1 :operating_unit :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_flex_item :p_item_struct_num :p_orderby :p_orderby_displayed :p_preparer_from :p_preparer_to :p_qty_precision :p_requestor_from :p_requestor_to :p_show_lines :p_title :qty_precision 1 -10 1=1 exists (select 'Requestor exists' from po_requisition_lines_all porl, per_all_people_f papf3 where porl.requisition_header_id = prh.requisition_header_id and porl.to_person_id = papf3.person_id and papf3.full_name between nvl(:p_requestor_from, papf3.full_name) and nvl(:p_requestor_to,papf3.full_name) and decode(hr_general.get_xbg_profile,'Y', papf3.business_group_id , hr_general.get_business_group_id) = papf3.business_group_id ) Char select 'Y' from dual where :$flex$.Requestor_From is not null or :$flex$.Requestor_To is not null US Requestor Where Clause 2 10 :p_show_lines LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Show Requisition Lines 3 &lp_line_cols -- N US Show Requisition Lines 4 &lp_line_cols , x.line_number, x.category, x.item, x.item_revision, x.line_description, x.uom, x.quantity, x.unit_price, x.requestor, x.line_cancelled_date, x.line_cancelled_reason Y US Show Requisition Lines 5 20 1=1 mgoat.organization_name=:p_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)) AR العنوان D Titel F Titre US Operating Unit ZHS 标题 6 30 1=1 papf.full_name>=:p_preparer_from LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR المعدون من D Von Bearbeiter F Emetteurs - De US Preparer From ZHS 编制人自 7 40 1=1 papf.full_name<=:p_preparer_to LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name :$flex$.Preparer_From AR إلى D Bis F A US Preparer To ZHS 至 8 50 :p_requestor_from LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR الطالبون من D Von Anforderer F Demandeurs - De US Requestor From ZHS 申请人自 9 60 :p_requestor_to LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name :$flex$.Requestor_From AR إلى D Bis F A US Requestor To ZHS 至 10 70 1=1 pah.action_date>=:p_cancel_date_from Date US Cancelled Date From 11 80 1=1 pah.action_date<:p_cancel_date_to+1 Date last_day(:$flex$.Cancelled_Date_From) US Cancelled Date To 12 90 1=1 prh.creation_date>=:p_creation_date_from Date AR تواريخ تكوين طلب الشراء من D Von Erstellungsdatum Anforderung F Dates de création des D.A. - Du US Creation Date From ZHS 申请创建日期自 13 100 1=1 prh.creation_date<:p_creation_date_to+1 Date last_day(:$flex$.Creation_Date_From) AR إلى D Bis F Au US Creation Date To ZHS 至 :$flex$.Cancelled_Date_From Cancelled Date From Y Cancelled Date To :$flex$.Creation_Date_From Creation Date From Y Creation Date To :$flex$.Preparer_From Preparer From Preparer To :$flex$.Requestor_From Requestor From Requestor To :$flex$.Requestor_From Requestor From Requestor Where Clause :$flex$.Requestor_To Requestor To Requestor Where Clause