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）限制的操作单元。 4DA78907EE5B27A7E0630100007F7D2D select haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, (select pps.project_status_name from pa_project_statuses pps where pps.project_status_code=ppa.project_status_code) project_status, ppa.project_type, pt.task_number, pt.task_name, peia.expenditure_type, pet.expenditure_category, (select psl.meaning from pa_system_linkages psl where psl.function=peia.system_linkage_function) expenditure_type_class, (select pts.user_transaction_source from pa_transaction_sources pts where pts.transaction_source=peia.transaction_source) transaction_source, peia.expenditure_item_date, pea.expenditure_group, nvl(ppx.npw_number,ppx.employee_number) employee_number, ppx.full_name employee, we.wip_entity_name job, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) wip_entity_type, msiv.concatenated_segments assembly, msiv.description assembly_description, nvl(wri.class_code,wdj.class_code) accounting_class, xxen_util.meaning(wt.transaction_type,'WIP_TRANSACTION_TYPE',700) wip_transaction_type, wt.transaction_date wip_transaction_date, wt.operation_seq_num wip_operation_seq, bd.department_code wip_department, wt.resource_seq_num wip_resource_seq, br.resource_code wip_resource, br.description wip_resource_description, mtt.transaction_type_name inv_transaction_type, mmt.transaction_date inv_transaction_date, msiv2.concatenated_segments inv_item, msiv2.description inv_item_description, mmt.transaction_quantity inv_quantity, mmt.transaction_uom inv_uom, peia.quantity, peia.denom_currency_code currency, peia.denom_raw_cost raw_cost, peia.denom_burdened_cost burdened_cost, peia.acct_raw_cost, peia.acct_burdened_cost, peia.orig_transaction_reference, peia.expenditure_item_id from pa_expenditure_items_all peia, pa_expenditures_all pea, pa_expenditure_types pet, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl haouv, per_people_x ppx, wip_transactions wt, wip_entities we, wip_discrete_jobs wdj, wip_repetitive_items wri, mtl_system_items_vl msiv, bom_departments bd, bom_resources br, mtl_material_transactions mmt, mtl_transaction_types mtt, mtl_system_items_vl msiv2 where 1=1 and peia.project_id=ppa.project_id and peia.task_id=pt.task_id(+) and peia.expenditure_id=pea.expenditure_id and peia.expenditure_type=pet.expenditure_type and peia.org_id=haouv.organization_id and haouv.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) and pea.incurred_by_person_id=ppx.person_id(+) and case when peia.system_linkage_function='WIP' and peia.transaction_source='Work In Process' then to_number(peia.orig_transaction_reference default null on conversion error) end=wt.transaction_id(+) and coalesce(wt.wip_entity_id,decode(mmt.transaction_source_type_id,5,mmt.transaction_source_id))=we.wip_entity_id(+) and coalesce(wt.wip_entity_id,decode(mmt.transaction_source_type_id,5,mmt.transaction_source_id))=wdj.wip_entity_id(+) and coalesce(wt.organization_id,mmt.organization_id)=wdj.organization_id(+) and wt.wip_entity_id=wri.wip_entity_id(+) and wt.organization_id=wri.organization_id(+) and wt.line_id=wri.line_id(+) and we.primary_item_id=msiv.inventory_item_id(+) and we.organization_id=msiv.organization_id(+) and wt.department_id=bd.department_id(+) and peia.wip_resource_id=br.resource_id(+) and case when peia.system_linkage_function in ('WIP','INV') and peia.transaction_source<>'Work In Process' then to_number(peia.orig_transaction_reference default null on conversion error) end=mmt.transaction_id(+) and mmt.transaction_type_id=mtt.transaction_type_id(+) and mmt.inventory_item_id=msiv2.inventory_item_id(+) and mmt.organization_id=msiv2.organization_id(+) order by haouv.name, ppa.segment1, pt.task_number, peia.expenditure_item_date Y PA :Date_From is not null or :Date_To is not null or :Project is not null US PA Project Expenditure Items with WIP and INV Detail Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and inventory item information. Please enter at least a date range or project Enginatics 1=1 1 10 1=1 haouv.name=: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)) US Operating Unit 2 20 1=1 ppa.segment1=:project_number LOV custom Y Y select ppa.segment1 value, ppa.name description from pa_projects_all ppa where (:$flex$.operating_unit is null or ppa.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) order by ppa.segment1 US Project 3 30 1=1 pt.task_number=:task_number LOV custom Y select pt.task_number value, pt.task_name description from pa_tasks pt, pa_projects_all ppa where ppa.segment1=:$flex$.project and ppa.project_id=pt.project_id order by pt.task_number US Task 4 40 1=1 peia.expenditure_item_date>=:date_from DateTime US Date From 5 50 1=1 peia.expenditure_item_date<:date_to+1 DateTime :$flex$.date_from US Date To 6 60 1=1 peia.expenditure_type=:expenditure_type LOV custom Y select pet.expenditure_type value, pet.description from pa_expenditure_types pet where nvl(pet.end_date_active,sysdate)>=sysdate order by pet.expenditure_type US Expenditure Type 7 70 1=1 peia.system_linkage_function=:expenditure_type_class LOV custom Y select psl.function id, psl.meaning value, null description from pa_system_linkages psl order by psl.meaning US Expenditure Type Class 8 80 1=1 we.wip_entity_name=:job LOV custom Y Y select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) description from wip_entities we order by we.creation_date desc US Job 9 90 1=1 ppx.full_name=:employee LOV custom Y Y select ppx.full_name value, nvl(ppx.npw_number,ppx.employee_number) description from per_people_x ppx order by ppx.full_name US Employee :$flex$.date_from Date From Y Date To :$flex$.operating_unit Operating Unit Project :$flex$.project Project Task