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 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）限制的操作单元。 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 56159E4BDC1F4175E0536209825EEEA7 select nvl2(pasl.item_id,'Item','Commodity') type, mck.concatenated_segments commodity, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(pasl.vendor_business_type,'ASL_VENDOR_BUSINESS_TYPE',201) business, decode(pasl.vendor_business_type,'MANUFACTURER',null,aps.segment1) supplier_number, decode(pasl.vendor_business_type,'MANUFACTURER',mm.manufacturer_name,aps.vendor_name) supplier, assa.vendor_site_code supplier_site, haouv3.name operating_unit, pas.status, xxen_util.meaning(pasl.disable_flag,'YES_NO',0) disabled, pasl.primary_vendor_item supplier_item, mm1.manufacturer_name manufacturer, pasl.review_by_date review_by, mp1.organization_code owning_organization_code, haouv1.name owning_organization, xxen_util.meaning(decode(pasl.using_organization_id,-1,'Y','N'),'YES_NO',0) global, mp2.organization_code using_organization_code, haouv2.name using_organization, xxen_util.user_name(pasl.created_by) created_by, xxen_util.client_time(pasl.creation_date) creation_date, xxen_util.user_name(pasl.last_updated_by) last_updated_by, xxen_util.client_time(pasl.last_update_date) last_update_date, pasl.comments, paa.purchasing_unit_of_measure purchasing_uom, xxen_util.meaning(paa.release_generation_method,'DOC GENERATION METHOD',201) release_method, paa.price_update_tolerance, paa.country_of_origin_code country_of_origin, --source documents &document_cols --supplier scheduling xxen_util.meaning(paa.enable_plan_schedule_flag,'YES_NO',0) enable_planning_schedules, xxen_util.meaning(paa.enable_ship_schedule_flag,'YES_NO',0) enable_shipping_schedules, ppx.full_name scheduler, xxen_util.meaning(paa.enable_autoschedule_flag,'YES_NO',0) enable_autoschedule, cbp1.bucket_pattern_name plan_bucket_pattern, cbp2.bucket_pattern_name ship_bucket_pattern, xxen_util.meaning(paa.plan_schedule_type,'PLAN_SCHEDULE_SUBTYPE',201) plan_schedule_type, xxen_util.meaning(paa.ship_schedule_type,'SHIP_SCHEDULE_SUBTYPE',201) ship_schedule_type, xxen_util.meaning(paa.enable_authorizations_flag,'YES_NO',0) enable_authorizations, &authorization_cols --planning constraints paa.delivery_calendar supplier_capacity_calendar, paa.processing_lead_time, &supplier_capacity_cols &supplier_tolerance_cols --inventory paa.min_order_qty minimum_order_quantity, paa.fixed_lot_multiple, xxen_util.meaning(paa.enable_vmi_flag,'YES_NO',0) vmi_enabled, xxen_util.meaning(paa.enable_vmi_auto_replenish_flag,'YES_NO',0) vmi_auto_replenish, decode(paa.vmi_replenishment_approval,'SUPPLIER_OR_BUYER','Supplier or Buyer',initcap(paa.vmi_replenishment_approval)) vmi_replenishment_approval, decode(paa.replenishment_method,1,'Min - Max Quantities',2,'Min - Max Days',3,'Min Qty and Fixed Order Qty',4,'Min Days and Fixed Order Qty',paa.replenishment_method) vmi_replenishment_method, paa.vmi_min_days vmi_minimum_days, paa.vmi_max_days vmi_maximum_days, paa.vmi_min_qty, paa.vmi_max_qty, paa.forecast_horizon vmi_forecast_horizon_days, paa.fixed_order_quantity, xxen_util.meaning(paa.consigned_from_supplier_flag,'YES_NO',0) consigned_from_supplier, paa.consigned_billing_cycle, paa.last_billing_date, xxen_util.meaning(paa.consume_on_aging_flag,'YES_NO',0) consume_on_aging, paa.aging_period from po_approved_supplier_list pasl, mtl_parameters mp1, mtl_parameters mp2, hr_all_organization_units_vl haouv1, hr_all_organization_units_vl haouv2, hr_all_organization_units_vl haouv3, mtl_system_items_vl msiv, mtl_categories_kfv mck, ap_suppliers aps, (select assa.* from ap_supplier_sites_all assa where assa.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)) assa, mtl_manufacturers mm, po_asl_statuses pas, po_approved_supplier_list pasl1 , mtl_manufacturers mm1, (select padv.* from po_asl_documents_v padv where '&document_enable'='Y') padv, po_headers_all pha, po_asl_attributes paa, per_people_x ppx, chv_bucket_patterns cbp1, chv_bucket_patterns cbp2, (select ca.* from chv_authorizations ca where '&authorization_enable'='Y') ca, (select psic.* from po_supplier_item_capacity psic where '&supplier_capacity_enable'='Y') psic, (select psit.* from po_supplier_item_tolerance psit where '&supplier_tolerance_enable'='Y') psit where 1=1 and pasl.owning_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 pasl.owning_organization_id=mp1.organization_id and pasl.owning_organization_id=haouv1.organization_id and pasl.using_organization_id=mp2.organization_id(+) and pasl.using_organization_id=haouv2.organization_id(+) and pasl.owning_organization_id=msiv.organization_id(+) and pasl.item_id=msiv.inventory_item_id(+) and pasl.category_id=mck.category_id(+) and pasl.vendor_id=aps.vendor_id(+) and pasl.vendor_site_id=assa.vendor_site_id(+) and (pasl.vendor_site_id is not null and assa.vendor_site_code is not null or pasl.vendor_site_id is null and assa.vendor_site_code is null) and assa.org_id=haouv3.organization_id(+) and pasl.manufacturer_id=mm.manufacturer_id(+) and pasl.asl_status_id=pas.status_id and pasl.manufacturer_asl_id=pasl1.asl_id(+) and pasl1.manufacturer_id=mm1.manufacturer_id(+) and pasl.asl_id=padv.asl_id(+) and pasl.using_organization_id=padv.using_organization_id(+) and pasl.asl_id=paa.asl_id(+) and padv.document_header_id=pha.po_header_id(+) and pasl.using_organization_id=paa.using_organization_id(+) and paa.scheduler_id=ppx.person_id(+) and paa.plan_bucket_pattern_id=cbp1.bucket_pattern_id(+) and paa.ship_bucket_pattern_id=cbp2.bucket_pattern_id(+) and pasl.asl_id=ca.reference_id(+) and pasl.using_organization_id=ca.using_organization_id(+) and ca.reference_type(+)='ASL' and pasl.asl_id=psic.asl_id(+) and pasl.using_organization_id=psic.using_organization_id(+) and pasl.asl_id=psit.asl_id(+) and pasl.using_organization_id=psit.using_organization_id(+) order by mp1.organization_code, mck.concatenated_segments, msiv.concatenated_segments, decode(pasl.vendor_business_type,'MANUFACTURER',mm.manufacturer_name,aps.vendor_name), assa.vendor_site_code, mp2.organization_code Y AR PO Approved Supplier List قائمة الموردين المعتمدين وتفاصيل السمات مثل المستندات المصدر وجدولة الموردين وقيود التخطيط وسمات المخزون. D PO Approved Supplier List Genehmigte Lieferantenliste und Attributdetails wie Quelldokumente, Lieferantenterminierung, Planungsbeschränkungen und Bestandsattribute. E PO Approved Supplier List Lista de proveedores aprobados y detalles de atributos como documentos de origen, programación de proveedores, restricciones de planificación y atributos de inventario. F PO Approved Supplier List Liste des fournisseurs approuvés et détails des attributs tels que les documents sources, l'ordonnancement des fournisseurs, les contraintes de planification et les attributs des stocks. I PO Approved Supplier List Elenco dei fornitori approvati e dettagli degli attributi come documenti di origine, programmazione dei fornitori, vincoli di pianificazione e attributi di inventario. JA PO Approved Supplier List 承認されたサプライヤーのリストと、ソース文書、サプライヤーのスケジューリング、計画制約、在庫属性などの属性の詳細。 KO PO Approved Supplier List 승인 된 공급자 목록 및 출처 문서, 공급자 스케줄링, 계획 제약 및 재고 속성과 같은 속성 세부 사항. PTB PO Approved Supplier List Lista de fornecedores aprovados e detalhes de atributos tais como documentos de origem, programação de fornecedores, restrições de planejamento e atributos de inventário. RU PO Approved Supplier List Утвержденный список поставщиков и атрибуты детали, такие как исходные документы, планирование поставщиков, ограничения планирования и атрибуты запасов. S PO Approved Supplier List Godkänd leverantörslista och attributinformation såsom källdokument, leverantörsschema, planeringsbegränsningar och inventeringsattribut. TR PO Approved Supplier List Onaylanmış tedarikçi listesi ve kaynak belgeler, tedarikçi planlaması, planlama kısıtlamaları ve envanter özellikleri gibi özellik ayrıntıları. US PO Approved Supplier List Approved supplier list and attribute details such as source documents, supplier scheduling, planning constraints and inventory attributes. ZHS PO Approved Supplier List 经批准的供应商名单和属性细节，如源文件、供应商排产、计划约束和库存属性。 Enginatics &authorization_cols &authorization_enable &document_cols &document_enable &supplier_capacity_cols &supplier_capacity_enable &supplier_tolerance_cols &supplier_tolerance_enable 1=1 1 10 1=1 haouv3.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)) F Unité d'exploitation US Operating Unit 2 20 1=1 mp1.organization_code=:owning_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 F Code de l'organisation propriétaire US Owning Organization Code 3 30 1=1 (mp2.organization_code =:using_organization_code or (pasl.using_organization_id = -1 and pasl.item_id is null) or (pasl.using_organization_id = -1 and pasl.item_id is not null and exists (select null from mtl_system_items_b msib, mtl_parameters mp3 where mp3.organization_id = msib.organization_id and msib.inventory_item_id = pasl.item_id and mp3.organization_code = :using_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 Utilisation du code de l'organisation US Using Organization Code 4 40 1=1 msiv.concatenated_segments=:item LOV custom Y Y select distinct msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where (msiv.inventory_item_id,msiv.organization_id) in ( select pasl.item_id, pasl.owning_organization_id from po_approved_supplier_list pasl where :$flex$.owning_organization_code is null or pasl.owning_organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.owning_organization_code) or pasl.using_organization_id=-1 -- global ) order by msiv.concatenated_segments F Article US Item 5 50 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_item_categories mic, mtl_category_sets mcs, mtl_categories_kfv mck where mck.concatenated_segments=:category and mck.structure_id=mcs.structure_id and mck.category_id=mic.category_id and mcs.category_set_id=mic.category_set_id ) LOV custom Y select distinct mcv.category_concat_segs value, mcv.description from mtl_categories_v mcv where mcv.category_id in ( select pasl.category_id from po_approved_supplier_list pasl where :$flex$.owning_organization_code is null or pasl.owning_organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.owning_organization_code) or pasl.using_organization_id=-1 -- global ) order by mcv.category_concat_segs F Catégorie US Category 6 60 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 7 70 &document_enable Y 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 F Afficher les documents US Show Documents 8 &document_cols padv.sequence_num document_sequence, padv.document_type_dsp document_type, padv.document_num document_number, padv.line_num document_line, xxen_util.meaning(pha.global_agreement_flag,'YES_NO',0) global_agreement, decode(pha.global_agreement_flag,'Y',(select haouv.name from hr_all_organization_units_vl haouv where padv.org_id=haouv.organization_id)) document_owning_org, padv.document_status_dsp document_status, padv.effective_from, padv.effective_to, Y F Afficher les documents US Show Documents 9 80 &authorization_enable Y 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 F Afficher les autorisations US Show Authorizations 10 &authorization_cols ca.authorization_sequence sequence, xxen_util.meaning(ca.authorization_code,'AUTHORIZATION_TYPE',201) authorization, ca.timefence_days, Y F Afficher les autorisations US Show Authorizations 11 90 &supplier_capacity_enable Y 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 F Afficher la capacité des fournisseurs US Show Supplier Capacity 12 &supplier_capacity_cols psic.from_date, psic.to_date, psic.capacity_per_day, Y F Afficher la capacité des fournisseurs US Show Supplier Capacity 13 100 &supplier_tolerance_enable Y 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 F Afficher la tolérance du fournisseur US Show Supplier Tolerance 14 &supplier_tolerance_cols psit.number_of_days tolerance_days_in_advance, psit.tolerance tolerance_percentage, Y F Afficher la tolérance du fournisseur US Show Supplier Tolerance :$flex$.operating_unit Operating Unit Owning Organization Code :$flex$.operating_unit Operating Unit Supplier :$flex$.operating_unit Operating Unit Using Organization Code :$flex$.owning_organization_code Owning Organization Code Category :$flex$.owning_organization_code Owning Organization Code Item