ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 9B9627743E84607DE053BB6B635805FB INV Operating Unit Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 AR جميع وحدات التشغيل المرتبطة بمؤسسة مخزون غير رئيسية نشطة D Alle Betriebseinheiten, die mit einer aktiven Nicht-Master-Inventarisierungsorganisation verbunden sind E Todas las unidades operativas relacionadas con una organización de inventario no maestra activa F Toutes les unités opérationnelles liées à un organisme d'inventaire non maître actif I Tutte le unità operative legate a un'organizzazione di inventario non master attiva JA アクティブな非マスターインベントリ組織に関連するすべてのオペレーティング・ユニット KO 활성 비 마스터 재고 조직과 관련된 모든 운영 단위 PTB Todas as unidades operacionais relacionadas a uma organização ativa de inventário não-mestre RU Все операционные единицы, относящиеся к действующей организации, не являющейся ведущим поставщиком инвентарных запасов. S Alla operativa enheter relaterade till en aktiv organisation som inte är huvudlager TR Etkin bir ana envanter organizasyonu ile ilgili tüm işletim birimleri US All operating units related to an active non master inventory organization ZHS 与在用的非总清单组织有关的所有业务单位： 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 31BBF4BFDD100AD9E06362FB090507AE with org_group as( select ood.organization_id, maag.assignment_group_id, ood.organization_name, gsob.currency_code, cur.precision std_precision, nvl(cur.extended_precision, cur.precision) ext_precision from org_organization_definitions ood, hr_operating_units hou, gl_sets_of_books gsob, mtl_abc_assignment_groups maag, fnd_currencies cur where 1=1 and ood.organization_id=maag.organization_id and hou.organization_id=ood.operating_unit and ood.set_of_books_id =gsob.set_of_books_id and gsob.currency_code=cur.currency_code(+) ) select og.currency_code, mif.item_number, mif.description, macl.abc_class_name, maco.sequence_number, round(nvl(maco.compile_quantity,0),2) quantity, round(nvl(maco.compile_value,0),og.ext_precision) usage_value, mif.primary_uom_code as "UOM" from mtl_item_flexfields mif, mtl_abc_assignments maa, mtl_abc_classes macl, mtl_abc_compiles maco, mtl_abc_assignment_groups maag, org_group og where maa.inventory_item_id=mif.item_id and maa.abc_class_id=macl.abc_class_id and maag.assignment_group_id=maa.assignment_group_id and maa.inventory_item_id=maco.inventory_item_id and maag.compile_id=maco.compile_id and macl.organization_id=mif.organization_id and maco.organization_id=mif.organization_id and maag.organization_id=mif.organization_id and og.organization_id=mif.organization_id and og.assignment_group_id=maa.assignment_group_id union select og.currency_code, mif.item_number, mif.description, macl.abc_class_name, null sequence_number, 0 quantity, 0 usage_value, mif.primary_uom_code as "UOM" from mtl_item_flexfields mif, mtl_abc_classes macl, mtl_abc_assignment_groups maag, mtl_abc_assignments maa, org_group og where not exists (select * from mtl_abc_compiles maco where maco.organization_id=macl.organization_id and maa.inventory_item_id=maco.inventory_item_id and maag.compile_id=maco.compile_id ) and maa.inventory_item_id =mif.item_id and maa.abc_class_id=macl.abc_class_id and maag.assignment_group_id=maa.assignment_group_id and macl.organization_id=mif.organization_id and maag.organization_id=mif.organization_id and og.organization_id=mif.organization_id and og.assignment_group_id=maa.assignment_group_id Y INV INVARAAS_XML AR INV تقرير تخصيصات ABC (بتنسيق XML) Imported from BI Publisher Description: تقرير تخصيصات ABC Application: المخازن Source: تقرير تخصيصات ABC (بتنسيق XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG D INV ABC-Zuordnungen Imported from BI Publisher Description: ABC-Zuordnungen Application: Lager Source: ABC-Zuordnungen (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG E INV Asignaciones ABC Imported from BI Publisher Description: Asignaciones ABC Application: Inventory Source: Asignaciones ABC (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG F INV Etat Affectations ABC Imported from BI Publisher Description: Etat Affectations ABC Application: Inventory Source: Etat Affectations ABC (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG I INV Rapporto Assegnazioni ABC Imported from BI Publisher Description: Rapporto Classificazioni ABC Application: Inventory Source: Rapporto Assegnazioni ABC (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG JA INV ABC割当レポート Imported from BI Publisher Description: ABC割当レポート Application: Inventory Source: ABC割当レポート(XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG KO INV ABC 지정 보고서 Imported from BI Publisher Description: ABC 지정 보고서 Application: Inventory Source: ABC 지정 보고서(XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG PTB INV Relatório de atribuições ABC Imported from BI Publisher Description: Relatório de atribuições ABC Application: Inventário Source: Relatório de atribuições ABC (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG RU INV Отчет о назначениях ABC Imported from BI Publisher Description: Отчет о назначениях ABC Application: Запасы Source: Отчет о назначениях ABC (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG S INV ABC-tilldelningar - rapport Imported from BI Publisher Description: ABC-tilldelningar - rapport Application: Inventory Source: ABC-tilldelningar - rapport (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG TR INV ABC atamalar raporu Imported from BI Publisher Description: ABC atamalar raporu Application: Stok Yönetimi Source: ABC atamalar raporu (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG US INV ABC assignments Imported from BI Publisher Description: ABC assignments report Application: Inventory Source: ABC assignments report (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG ZHS INV ABC 分配报表 Imported from BI Publisher Description: ABC 分配报表 Application: 库存管理系统 Source: ABC 分配报表 (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG BI Publisher Enginatics R12 only 1=1 :group_id :org_id :p_cbo_flag :p_conc_request_id :p_qty_precision :p_sort_id :p_trace_flag :qty_precision :sort_order_clause 1 -10 :debugflag Char N US DebugFlag Debug Flag 2 5 1=1 hou.name=:p_operating_unit LOV INV Operating Unit 9B9627743E84607DE053BB6B635805FB Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit Operating Unit 3 10 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 nvl(fnd_profile.value('MFG_ORGANIZATION_ID'),(select min(oav.organization_id) from org_access_view oav where oav.responsibility_id=fnd_global.resp_id and oav.resp_application_id=fnd_global.resp_appl_id)) from dual Y US Organization Code Organization Code 4 20 1=1 maag.assignment_group_id=:group_id LOV custom Y select assignment_group_id id, assignment_group_name value, null description from mtl_parameters mp, mtl_abc_assignment_groups maag where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and maag.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 maag.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=maag.organization_id order by assignment_group_name Y US ABC Group ABC Group 5 30 :p_sort_id LOV Oracle INV_SRS_ABC_SORT_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_ABC_SORT_OPTION' and enabled_flag='Y' order by lookup_code Y US Sort Option Sort Option :$flex$.operating_unit Operating Unit Organization Code :$flex$.organization_code Organization Code ABC Group Sort By Item+ MRUGESH.POOJARY 4 ABC_CLASS_NAME 1 CURRENCY_CODE 3 DESCRIPTION 2 ITEM_NUMBER 1 7 QUANTITY 6 SEQUENCE_NUMBER 2 5 UOM 8 USAGE_VALUE S Site Sort by Quantity MRUGESH.POOJARY 4 ABC_CLASS_NAME 1 CURRENCY_CODE 3 DESCRIPTION 2 ITEM_NUMBER 7 QUANTITY 1 6 SEQUENCE_NUMBER 2 5 UOM 8 USAGE_VALUE S Site Sort by Sequence Number MRUGESH.POOJARY 4 ABC_CLASS_NAME 1 CURRENCY_CODE 3 DESCRIPTION 2 ITEM_NUMBER 7 QUANTITY 6 SEQUENCE_NUMBER 1 5 UOM 8 USAGE_VALUE S Site Sort by Usage Value MRUGESH.POOJARY 4 ABC_CLASS_NAME 1 CURRENCY_CODE 3 DESCRIPTION 2 ITEM_NUMBER 7 QUANTITY 6 SEQUENCE_NUMBER 2 5 UOM 8 USAGE_VALUE 1 S Site Sort By Item+