ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 8E2FF36EDF2A79D2E0530100007F1FF2 INV Subinventory Y select msi.secondary_inventory_name value, msi.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msi where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msi.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msi.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or xxen_util.contains(:$flex$.organization_code,mp.organization_id)='Y' ) and mp.organization_id=msi.organization_id order by mp.organization_code, msi.secondary_inventory_name US 8E2FF36EDEB479D2E0530100007F1FF2 INV Transaction Action Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_TRANSACTION_ACTION' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDEB679D2E0530100007F1FF2 INV Transaction Source Type Y select mtst.transaction_source_type_name value, mtst.description from mtl_txn_source_types mtst order by transaction_source_type_name US 8E2FF36EDEB579D2E0530100007F1FF2 INV Transaction Type Y select mtt.transaction_type_name value, mtt.description from mtl_transaction_types mtt order by mtt.transaction_type_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 71DFD35D9F3815CCE0530100007FE431 select x.count, &proj_cols2 &org_cols2 &item_cols2 &show_subinv_cols2 &category_columns x.transaction_action, x.transaction_type, x.source_type, x.transaction_action_id, x.transaction_type_id, x.transaction_source_type_id from ( select count(*) count, &proj_cols &org_cols &item_cols &show_subinv_cols xxen_util.meaning(mmt.transaction_action_id,'MTL_TRANSACTION_ACTION',700) transaction_action, mtt.transaction_type_name transaction_type, mtst.transaction_source_type_name source_type, mmt.transaction_action_id, mmt.transaction_type_id, mmt.transaction_source_type_id from mtl_material_transactions mmt, mtl_transaction_types mtt, mtl_txn_source_types mtst, (select msiv.* from mtl_system_items_vl msiv where '&show_item'='Y') msiv, &mtl_subinventory mtl_parameters mp, mtl_parameters mp2, pa_projects_all ppa, pa_tasks pt, pa_projects_all ppa2, pa_tasks pt2, pa_projects_all ppa3, pa_tasks pt3 where 1=1 and mmt.transaction_type_id=mtt.transaction_type_id and mtt.transaction_source_type_id=mtst.transaction_source_type_id(+) and mmt.organization_id=msiv.organization_id(+) and mmt.inventory_item_id=msiv.inventory_item_id(+) and mmt.organization_id=mp.organization_id(+) and mmt.transfer_organization_id=mp2.organization_id(+) and mmt.project_id=ppa.project_id(+) and mmt.task_id=pt.task_id(+) and mmt.source_project_id=ppa2.project_id(+) and mmt.source_task_id=pt2.task_id(+) and mmt.to_project_id=ppa3.project_id(+) and mmt.to_task_id=pt3.task_id(+) group by &proj_group_cols &org_group_by &item_group_by &subinv_group_by mtt.transaction_type_name, mtst.transaction_source_type_name, mmt.transaction_action_id, mmt.transaction_type_id, mmt.transaction_source_type_id order by count(*) desc )x Y AR INV Material Transactions Summary تقرير موجز عن حركة عنصر المخزون بما في ذلك نوع المعاملة ونوع المصدر ومعرف المعاملة. D INV Material Transactions Summary Zusammenfassender Bericht über die Bewegung von Inventarobjekten einschließlich Transaktionstyp, Quellentyp und Transaktions-IDs. E INV Material Transactions Summary Informe resumido del movimiento de artículos de inventario, incluyendo el tipo de transacción, el tipo de origen y los identificadores de transacción. F INV Material Transactions Summary Rapport sommaire des mouvements d'articles en stock, y compris le type de transaction, le type de source et les ID de transaction. I INV Material Transactions Summary Report di riepilogo dei movimenti degli articoli dell'inventario, inclusi il tipo di transazione, il tipo di fonte e l'ID della transazione. JA INV Material Transactions Summary 棚卸資産の取引タイプ、仕入元タイプ、取引IDを含む棚卸資産の動きをまとめて報告します。 KO INV Material Transactions Summary 거래 유형, 출처 유형 및 거래 ID를 포함한 재고 항목 이동에 대한 요약 보고서입니다. PTB INV Material Transactions Summary Relatório resumido do movimento de itens de inventário, incluindo tipo de transação, tipo de fonte e identificação da transação. RU INV Material Transactions Summary Сводный отчет о движении товарно-материальных ценностей, включая тип транзакции, тип источника и идентификатор транзакции. S INV Material Transactions Summary Sammanfattningsrapport om varulagerrörelse inklusive transaktionstyp, källtyp och transaktions-ID. TR INV Material Transactions Summary İşlem türü, kaynak türü ve işlem kimlikleri dahil Envanter kalemi hareketinin özet raporu. US INV Material Transactions Summary Summary report of Inventory item movement including transaction type, source type, and transaction ID’s. ZHS INV Material Transactions Summary 存货项目移动的汇总报告，包括交易类型、来源类型和交易ID。 Enginatics &category_columns &item_cols &item_cols2 &item_group_by &mtl_subinventory &org_cols &org_cols2 &org_group_by &proj_cols &proj_cols2 &proj_group_cols &show_item &show_subinv_cols &show_subinv_cols2 &subinv_group_by 1=1 1 10 &show_item Y LOV custom Y select x.value, x.description from ( select 'Item' value, 'per transaction type and item' description from dual union all select 'Organization' value, 'per transaction type and organization' description from dual union all select 'Project' value, 'per transaction type and project' description from dual union all select 'Item and Organization' value, 'per transaction type, item and organization' description from dual union all select 'Item and Project' value, 'per transaction type, item and project' description from dual union all select 'Organization and Project' value, 'per transaction type, organization and project' description from dual union all select 'Item, Organization and Project' value, 'per transaction type, item, organization and project' description from dual ) x order by x.value Item% F Niveau US Level 2 &item_cols msiv.concatenated_segments item, msiv.description item_description, msiv.inventory_item_id, msiv.organization_id, xxen_util.meaning(msiv.inventory_asset_flag,'YES_NO',0) inventory_asset, sum(mmt.primary_quantity) primary_quantity, Item% F Niveau US Level 3 &item_cols2 x.item, x.item_description, x.inventory_asset, x.primary_quantity, Item% US Level 4 &item_group_by msiv.concatenated_segments, msiv.inventory_asset_flag, msiv.inventory_item_id, msiv.organization_id, msiv.description, Item% F Niveau US Level 5 &org_cols mp.organization_code, mp2.organization_code transfer_organization_code, %Organization% F Niveau US Level 6 &org_cols2 x.organization_code, x.transfer_organization_code, %Organization% US Level 7 &org_group_by mp.organization_code, mp2.organization_code, %Organization% US Level 8 &proj_cols ppa.segment1 project_number, pt.task_number, ppa.name project_name, pt.task_name, ppa2.segment1 source_project_number, pt2.task_number source_task_number, ppa2.name source_project_name, pt2.task_name source_task_name, ppa3.segment1 to_project_number, pt3.task_number to_task_number, ppa3.name to_project_name, pt3.task_name to_task_name, %Project% US Level 9 &proj_cols2 x.project_number, x.task_number, x.project_name, x.task_name, x.source_project_number, x.source_task_number, x.source_project_name, x.source_task_name, x.to_project_number, x.to_task_number, x.to_project_name, x.to_task_name, %Project% US Level 10 &proj_group_cols ppa.segment1, pt.task_number, ppa.name, pt.task_name, ppa2.segment1, pt2.task_number, ppa2.name, pt2.task_name, ppa3.segment1, pt3.task_number, ppa3.name, pt3.task_name, %Project% US Level 11 30 1=1 msiv.concatenated_segments like :item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item 12 &item_cols msiv.concatenated_segments item, msiv.description item_description, msiv.inventory_item_id, msiv.organization_id, xxen_util.meaning(msiv.inventory_asset_flag,'YES_NO',0) inventory_asset, sum(mmt.primary_quantity) primary_quantity, F Article US Item 13 &item_cols2 x.item, x.item_description, x.inventory_asset, x.primary_quantity, US Item 14 &item_group_by msiv.concatenated_segments, msiv.inventory_asset_flag, msiv.inventory_item_id, msiv.organization_id, msiv.description, F Article US Item 15 &show_item Y F Article US Item 16 40 1=1 mmt.organization_id=msi.organization_id(+) and mmt.subinventory_code = msi.secondary_inventory_name(+) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Subinventory 17 &mtl_subinventory mtl_secondary_inventories msi, US Show Subinventory 18 &show_subinv_cols mmt.subinventory_code, US Show Subinventory 19 &show_subinv_cols2 x.subinventory_code, US Show Subinventory 20 &subinv_group_by mmt.subinventory_code, US Show Subinventory 21 45 1=1 msi.asset_inventory(+) <> 2 LOV custom Y select 'N' id, xxen_util.meaning('N','YES_NO',0) value, null description from dual where :$flex$.show_subinventory='Y' US Include Expense Subinventory 22 47 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV custom Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.level like 'Item%' and (:$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) ) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) US Category Set 1 23 48 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV custom Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.level like 'Item%' and (:$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) ) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) US Category Set 2 24 49 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV custom Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.level like 'Item%' and (:$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) ) order by mcsv.category_set_name US Category Set 3 25 50 1=1 mmt.transaction_date>=sysdate-:days Number select 30 from dual where :$flex$.transaction_date_from is null F Transaction dans les jours US Transaction within Days 26 60 1=1 mmt.transaction_date>=:trx_date_from Date F Date de la transaction Du US Transaction Date From 27 70 1=1 mmt.transaction_date<:trx_date_to+1 Date last_day(:$flex$.transaction_date_from)+1-1/86400 F Date de la transaction au US Transaction Date To 28 80 1=1 mtst.transaction_source_type_name=:source_type_id LOV INV Transaction Source Type 8E2FF36EDEB679D2E0530100007F1FF2 Y select mtst.transaction_source_type_name value, mtst.description from mtl_txn_source_types mtst order by transaction_source_type_name F Type de source US Source Type 29 90 1=1 mtst.transaction_source_type_name<>:exclude_source_type LOV INV Transaction Source Type 8E2FF36EDEB679D2E0530100007F1FF2 Y select mtst.transaction_source_type_name value, mtst.description from mtl_txn_source_types mtst order by transaction_source_type_name F Exclure le type de source US Exclude Source Type 30 100 1=1 mmt.transaction_action_id=xxen_util.lookup_code(:action,'MTL_TRANSACTION_ACTION',700) LOV INV Transaction Action 8E2FF36EDEB479D2E0530100007F1FF2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_TRANSACTION_ACTION' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning US Action 31 110 1=1 mmt.transaction_action_id<>xxen_util.lookup_code(:exclude_action,'MTL_TRANSACTION_ACTION',700) LOV INV Transaction Action 8E2FF36EDEB479D2E0530100007F1FF2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_TRANSACTION_ACTION' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning F Action d'exclusion US Exclude Action 32 120 1=1 mtt.transaction_type_name=:transaction_type LOV INV Transaction Type 8E2FF36EDEB579D2E0530100007F1FF2 Y select mtt.transaction_type_name value, mtt.description from mtl_transaction_types mtt order by mtt.transaction_type_name F Type de transaction US Transaction Type 33 130 1=1 mtt.transaction_type_name<>:exclude_transaction_type LOV INV Transaction Type 8E2FF36EDEB579D2E0530100007F1FF2 Y select mtt.transaction_type_name value, mtt.description from mtl_transaction_types mtt order by mtt.transaction_type_name F Exclure le type de transaction US Exclude Transaction Type 34 140 1=1 mmt.created_by=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Créé par US Created By 35 150 1=1 mmt.transaction_action_id not in (24,30) and --Cost update, WIP scrap transaction (mmt.logical_transaction=2 or mmt.logical_transaction is null) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Exclure les transactions logiques US Exclude Logical Transactions 36 200 1=1 mp.organization_code=:organization_code LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code F Code de l'organisation US Organization Code 37 210 1=1 mmt.subinventory_code=:subinventory LOV INV Subinventory 8E2FF36EDF2A79D2E0530100007F1FF2 Y select msi.secondary_inventory_name value, msi.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msi where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msi.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msi.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or xxen_util.contains(:$flex$.organization_code,mp.organization_id)='Y' ) and mp.organization_id=msi.organization_id order by mp.organization_code, msi.secondary_inventory_name F Sous-inventaire US Subinventory :$flex$.level Level Category Set 1 :$flex$.level Level Category Set 2 :$flex$.level Level Category Set 3 :$flex$.organization_code Organization Code Category Set 1 :$flex$.organization_code Organization Code Category Set 2 :$flex$.organization_code Organization Code Category Set 3 :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Subinventory :$flex$.show_subinventory Show Subinventory Include Expense Subinventory :$flex$.transaction_date_from Transaction Date From Y Transaction Date To :$flex$.transaction_date_from Transaction Date From Y Transaction within Days