ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 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. 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）限制的操作单元。 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$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 8E2FF36EDEF379D2E0530100007F1FF2 INV Item (master) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Any item from item master org, including non costing enabled B8DD9131FE72F277E0530100007F06F8 INV Item Description (master) Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Inventory item descriptions restricted to the accessible inventory organizations only. 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code 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 mp.organization_id<>mp.master_organization_id and ( ood.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 not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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 (:$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 AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 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 8E2FF36EDEDB79D2E0530100007F1FF2 PA Project Number Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_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 ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A803B308ACE0530100007FEB91 select gl.name ledger, haouv.name operating_unit, ood.organization_code org, xxen_util.client_time(mmt.transaction_date) transaction_date, (select gp.period_name from gl_periods gp where mmt.transaction_date>=gp.start_date and mmt.transaction_date<gp.end_date+1 and gl.period_set_name=gp.period_set_name and gl.accounted_period_type=gp.period_type and gp.adjustment_period_flag='N') period, to_number(to_char(mmt.transaction_date,'yyyy')) year, to_number(to_char(mmt.transaction_date,'ww')) week, msiv.concatenated_segments item, msiv.description item_desc, &category_columns xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, xxen_util.meaning(msiv.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, nvl(mtln.transaction_quantity,mmt.transaction_quantity) transaction_quantity, mmt.transaction_uom, nvl(mtln.primary_quantity,mmt.primary_quantity) primary_quantity, msiv.primary_uom_code primary_uom, nvl(mtln.secondary_transaction_quantity,mmt.secondary_transaction_quantity) secondary_quantity, mmt.secondary_uom_code secondary_uom, mmt.actual_cost, mmt.actual_cost*abs(nvl(mtln.primary_quantity,mmt.primary_quantity)) transaction_value, mmt.subinventory_code subinventory, coalesce(inv_project.get_locator(mmt.locator_id,mmt.organization_id),(select milk.concatenated_segments from mtl_item_locations_kfv milk where mmt.locator_id=milk.inventory_location_id and mmt.organization_id=milk.organization_id)) locator, decode(inv_check_product_install.check_cse_install,'Y',nvl(hl.clli_code,substr(hl.city,1,10)||substr(hl.location_id,1,10)),substr(hl.city,1,10)||substr(hl.location_id,1,10)) location, mmt.revision, &lot_columns mmt.transfer_subinventory, coalesce(inv_project.get_locator(mmt.transfer_locator_id,mmt.transfer_organization_id),(select milk.concatenated_segments from mtl_item_locations_kfv milk where mmt.transfer_locator_id=milk.inventory_location_id and mmt.transfer_organization_id=milk.organization_id)) transfer_locator, mp2.organization_code transfer_org, mp3.organization_code||'-'||haouv3.name owning_party, mp4.organization_code||'-'||haouv4.name planning_party, mtst.transaction_source_type_name source_type, case when mmt.transaction_source_type_id=6 then mgd.segment1 --Account Alias when mmt.transaction_source_type_id in (2,8,12) then mso.segment1||'.'||mso.segment2||'.'||mso.segment3 --Sales Order, Internal Order, RMA when mmt.transaction_source_type_id=11 then ccu.description --Cost Update when mmt.transaction_source_type_id=9 then mcch.cycle_count_header_name --Cycle Count when mmt.transaction_source_type_id=3 then gcck.concatenated_segments --Account when mmt.transaction_source_type_id=13 or mmt.transaction_source_type_id>100 then mmt.transaction_source_name --Inventory when mmt.transaction_source_type_id=10 then mpi.physical_inventory_name --Physical Inventory when mmt.transaction_source_type_id=1 then pha.segment1 --PO when mmt.transaction_source_type_id=16 then okhab.contract_number --Project Contracts when mmt.transaction_source_type_id=7 then prha.segment1 --Requisition when mmt.transaction_source_type_id=5 then we.wip_entity_name --WIP Job or Schedule when mmt.transaction_source_type_id=4 then mtrh.request_number --Move Order end source, aps.vendor_name, aps.segment1 vendor_number, mtt.transaction_type_name transaction_type, xxen_util.meaning(mmt.transaction_action_id,'MTL_TRANSACTION_ACTION',700) transaction_action, ppa.segment1 project_number, pt.task_number task_number, ppa.name project_name, pt.task_name 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, mtr.reason_name reason, mtr.description reason_description, mmt.source_line_id, mmt.transaction_id, mmt.rcv_transaction_id receiving_transaction_id, xxen_util.user_name(mmt.created_by) created_by, xxen_util.client_time(mmt.creation_date) creation_date, sum(nvl(mtln.transaction_quantity,mmt.transaction_quantity)) over (partition by mmt.inventory_item_id order by mmt.transaction_date,mmt.transaction_id) sum_transaction_quantity from gl_ledgers gl, hr_all_organization_units_vl haouv, org_organization_definitions ood, mtl_material_transactions mmt, mtl_transaction_types mtt, mtl_txn_source_types mtst, mtl_system_items_vl msiv, mtl_parameters mp2, hz_locations hl, mtl_parameters mp3, mtl_parameters mp4, hr_all_organization_units_vl haouv3, hr_all_organization_units_vl haouv4, mtl_transaction_reasons mtr, mtl_generic_dispositions mgd, mtl_sales_orders mso, cst_cost_updates ccu, mtl_cycle_count_headers mcch, gl_code_combinations_kfv gcck, mtl_physical_inventories mpi, po_headers_all pha, ap_suppliers aps, okc_k_headers_all_b okhab, po_requisition_headers_all prha, wip_entities we, mtl_txn_request_headers mtrh, (select mtln.* from mtl_transaction_lot_numbers mtln where '&show_lots'='Y') mtln, 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 gl.ledger_id=ood.set_of_books_id and haouv.organization_id=ood.operating_unit and mmt.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) and ood.organization_id=mmt.organization_id and mmt.transaction_type_id=mtt.transaction_type_id and mmt.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.transfer_organization_id=mp2.organization_id(+) and mmt.ship_to_location_id=hl.location_id(+) and mmt.owning_organization_id=mp3.organization_id(+) and mmt.owning_organization_id=haouv3.organization_id(+) and mmt.planning_organization_id=mp4.organization_id(+) and mmt.planning_organization_id=haouv4.organization_id(+) and mmt.reason_id=mtr.reason_id(+) and decode(mmt.transaction_source_type_id,6,mmt.transaction_source_id)=mgd.disposition_id(+) and decode(mmt.transaction_source_type_id,6,mmt.organization_id)=mgd.organization_id(+) and case when mmt.transaction_source_type_id in (2,8,12) then mmt.transaction_source_id end=mso.sales_order_id(+) and decode(mmt.transaction_source_type_id,11,mmt.transaction_source_id)=ccu.cost_update_id(+) and decode(mmt.transaction_source_type_id,9,mmt.transaction_source_id)=mcch.cycle_count_header_id(+) and decode(mmt.transaction_source_type_id,3,mmt.transaction_source_id)=gcck.code_combination_id(+) and decode(mmt.transaction_source_type_id,10,mmt.transaction_source_id)=mpi.physical_inventory_id(+) and decode(mmt.transaction_source_type_id,10,mmt.organization_id)=mpi.organization_id(+) and decode(mmt.transaction_source_type_id,1,mmt.transaction_source_id)=pha.po_header_id(+) and pha.vendor_id=aps.vendor_id(+) and decode(mmt.transaction_source_type_id,16,mmt.transaction_source_id)=okhab.id(+) and decode(mmt.transaction_source_type_id,7,mmt.transaction_source_id)=prha.requisition_header_id(+) and decode(mmt.transaction_source_type_id,5,mmt.transaction_source_id)=we.wip_entity_id(+) and decode(mmt.transaction_source_type_id,4,mmt.transaction_source_id)=mtrh.header_id(+) and mmt.transaction_id=mtln.transaction_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(+) order by haouv.name, ood.organization_code, msiv.concatenated_segments, mmt.transaction_date desc, mmt.transaction_id desc Y AR INV Material Transactions تقرير مفصل عن حركات المخزون مع الصنف والكمية الأساسية والكمية الثانوية ونوع الحركة ومعرف المعاملة وإجمالي كمية المعاملة D INV Material Transactions Detailbericht zu Bestandstransaktionen mit Artikel, primärer Menge, sekundärer Menge, Transaktionstyp, Transaktions-ID und Gesamtmenge der Transaktion E INV Material Transactions Informe detallado de las transacciones de inventario con el artículo, la cantidad principal, la cantidad secundaria, el tipo de transacción, el ID de la transacción y la cantidad total de la transacción F INV Material Transactions Rapport détaillé des transactions d'inventaire avec l'article, la quantité primaire, la quantité secondaire, le type de transaction, l'ID de la transaction et la quantité totale de la transaction I INV Material Transactions Rapporto dettagliato delle transazioni di inventario con articolo, quantità primaria, quantità secondaria, tipo di transazione, ID della transazione e quantità totale della transazione JA INV Material Transactions 項目、一次在庫、二次在庫、取引タイプ、取引ID、総取引数量の在庫取引の詳細レポート KO INV Material Transactions 품목, 1 차 수량, 2 차 수량, 거래 유형, 거래 ID 및 총 거래 수량에 대한 재고 거래 상세 보고서 PTB INV Material Transactions Relatório detalhado das transações de inventário com item, qtd primária, qtd secundária, tipo de transação, ID da transação e qtd total da transação RU INV Material Transactions Подробный отчет об операциях с инвентарными запасами с указанием позиции, первичных qty, вторичных qty, типа операции, идентификатора операции и общей суммы операции qty S INV Material Transactions Detaljrapport om lagertransaktioner med artikel, primärt antal, sekundärt antal, transaktionstyp, transaktions-ID och totalt transaktionsantal TR INV Material Transactions Kalem, birincil miktar, ikincil miktar, işlem türü, işlem kimliği ve toplam işlem miktarı ile stok işlemlerinin ayrıntılı raporu US INV Material Transactions Detail report of Inventory transactions with item, primary qty, secondary qty, transaction type, transaction ID and total transaction qty ZHS INV Material Transactions 存货交易的详细报告，包括项目、主要数量、次要数量、交易类型、交易ID和总交易数量。 Enginatics &category_columns &lot_columns &show_lots 1=1 1 -10 1=1 (mmt.organization_id,mmt.inventory_item_id) in ( select distinct xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) organization_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) inventory_item_id from xxen_report_run_param_values xrrpv where xrrpv.parameter_id in (select xrpv.parameter_id from xxen_report_parameters_v xrpv where xrpv.parameter_name='organization_id|inventory_item_id') and xrrpv.run_id=:run_id ) Char F organisation_id|inventory_item_id US organization_id|inventory_item_id 2 10 1=1 haouv.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 US Operating Unit 3 20 1=1 ood.organization_code=:organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 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 mp.organization_id<>mp.master_organization_id and ( ood.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 not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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 (:$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 select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Code de l'organisation US Organization Code 4 30 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 5 40 1=1 msiv.concatenated_segments like :item LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments F Article US Item 6 50 1=1 upper(msiv.description) like upper(:item_descr) LOV INV Item Description (master) B8DD9131FE72F277E0530100007F06F8 Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments F Description de l'article ne tient pas compte de la casse et autorise les caractères de remplacement US Item Description case insensitive and allows wildcards 7 60 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$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 8 70 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$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 9 80 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$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 xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 10 90 1=1 mmt.transaction_date>=sysdate-:days Number select 1 from dual where :$flex$.transaction_date_from is null F Transaction dans les jours US Transaction within Days 11 100 1=1 mmt.transaction_date>=:trx_date_from Date F Date de la transaction Du US Transaction Date From 12 110 1=1 mmt.transaction_date<:trx_date_to+1 Date trunc(:$flex$.transaction_date_from)+1-1/86400 F Date de la transaction au US Transaction Date To 13 120 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 14 130 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 15 140 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 16 150 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 17 160 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 18 170 1=1 aps.vendor_name=:vendor_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 19 180 1=1 ppa.segment1=:project LOV PA Project Number 8E2FF36EDEDB79D2E0530100007F1FF2 Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_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 ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc US Project 20 190 &show_lots Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Lots d'exposition US Show Lots 21 &lot_columns mtln.lot_number, F Lots d'exposition US Show Lots 22 200 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 23 210 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 24 220 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 :$flex$.operating_unit Operating Unit Organization Code :$flex$.operating_unit Operating Unit Project :$flex$.operating_unit Operating Unit Supplier :$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 Subinventory :$flex$.organization_code Organization Code Supplier :$flex$.transaction_date_from Transaction Date From Y Transaction Date To :$flex$.transaction_date_from Transaction Date From Y Transaction within Days