ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 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 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US C6E085D4700B51A9E05362FB09050512 select x.*, case when x.cat_set_control_level = xxen_util.meaning(1,'ITEM_CONTROL_LEVEL_GUI',700) and x.multi_item_cat_assign_allowed is null and x.mast_cat_set_item_assign_count > 1 then xxen_util.meaning('Y','YES_NO',0) else null end cat_set_control_level_violated from ( select mcsv.category_set_name category_set_name, mcsv.description category_set_description, msiv.concatenated_segments item, msiv.description item_description, mp2.organization_code master_organization, mp.organization_code organization, mck.concatenated_segments category, mcv.description category_description, -- mcsv.structure_name cat_set_flex_structure, mcsv.control_level_disp cat_set_control_level, (select mck2.concatenated_segments from mtl_categories_kfv mck2 where mck2.category_id = mcsv.default_category_id) cat_set_default_category, xxen_util.yes(mcsv.validate_flag) enforce_valid_categories, xxen_util.yes(mcsv.mult_item_cat_assign_flag) multi_item_cat_assign_allowed, (select count(*) from mtl_category_set_valid_cats mcsvc where mcsv.category_set_id = mcsvc.category_set_id) cat_set_valid_category_count, (select count(*) from mtl_categories_b mcb where mcsv.structure_id = mcb.structure_id) cat_set_category_count, -- (select count(distinct mic2.category_id) from mtl_parameters mp2, mtl_item_categories mic2, mtl_system_items_b msib where mp2.master_organization_id = mp.master_organization_id and mic2.organization_id = mp2.organization_id and mic2.category_set_id = mcsv.category_set_id and mic2.inventory_item_id = msiv.inventory_item_id and msib.organization_id = mic2.organization_id and msib.inventory_item_id = mic2.inventory_item_id ) mast_cat_set_item_assign_count from mtl_parameters mp, mtl_parameters mp2, mtl_system_items_vl msiv, mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_item_categories mic, mtl_categories_v mcv where 1=1 and mic.organization_id = mp.organization_id and mp.master_organization_id = mp2.organization_id and mic.category_id = mck.category_id and mic.category_id = mcv.category_id and mic.category_set_id = mcsv.category_set_id and msiv.organization_id = mic.organization_id and mic.inventory_item_id = msiv.inventory_item_id ) x where 2=2 order by x.category_set_name, x.item, x.master_organization, x.organization, x.category Y INV AR INV تقرير فئات الأصناف (بتنسيق XML) Imported from BI Publisher Description: تقرير فئات الأصناف Application: المخازن Source: تقرير فئات الأصناف (بتنسيق XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG D INV Artikelkategorien Imported from BI Publisher Description: Artikelkategorien Application: Lager Source: Artikelkategorien (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG E INV Categorías de Artículos Imported from BI Publisher Description: Categorías de Artículos Application: Inventory Source: Categorías de Artículos (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG F INV Etat des catégories d'articles Imported from BI Publisher Description: Etat des catégories d'articles Application: Inventory Source: Etat des catégories d'articles (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG I INV Rapporto Categorie articoli Imported from BI Publisher Description: Rapporto Categorie articoli Application: Inventory Source: Rapporto Categorie articoli (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG JA INV 品目カテゴリ・レポート Imported from BI Publisher Description: 品目カテゴリ・レポート Application: Inventory Source: 品目カテゴリ・レポート(XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG KO INV 품목 범주 보고서 Imported from BI Publisher Description: 품목 범주 보고서 Application: Inventory Source: 품목 범주 보고서(XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG PTB INV Relatório de categorias de item Imported from BI Publisher Description: Relatório de categorias de item Application: Inventário Source: Relatório de categorias de item (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG RU INV Отчет о категориях позиций Imported from BI Publisher Description: Отчет о категориях позиций Application: Запасы Source: Отчет о категориях позиций (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG S INV Artikelkategorier - rapport Imported from BI Publisher Description: Artikelkategorier - rapport Application: Inventory Source: Artikelkategorier - rapport (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG TR INV Kalem kategorileri raporu Imported from BI Publisher Description: Kalem kategorileri raporu Application: Stok Yönetimi Source: Kalem kategorileri raporu (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG US INV Item Category Assignment Imported from BI Publisher Description: Item categories report Application: Inventory Source: Item categories report (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG ZHS INV 物料类别报表 Imported from BI Publisher Description: 物料类别报表 Application: 库存管理系统 Source: 物料类别报表 (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG BI Publisher Enginatics 1=1 2=2 1 20 1=1 mcsv.category_set_name = :p_cat_set_name 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 select category_set_name from mtl_default_sets_view where functional_area_id = 1 AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie di categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conj. Categorias RU Набор катег. Набор катег. S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 2 30 1=1 mp.organization_code = :p_org_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 select mp2.organization_code from mtl_parameters mp, mtl_parameters mp2 where mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') and mp2.organization_id = mp.master_organization_id AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Code Organization ZHS 组织 组织 3 40 1=1 mck.concatenated_segments >= :p_cat_lo LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs AR الفئات من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégorie - De I Categorie - Da Categoria (min) JA カテゴリ:自 カテゴリ:下位 KO 범주: 부터 범주 하한 PTB Categorias - De Categoria - Inferior RU Категории с Категория с S Från kategorier Från kategori TR Kategoriler - İlk Kategori Alt Değeri US Category From Category Low ZHS 类别自 类别下限 4 50 1=1 mck.concatenated_segments <= :p_cat_hi LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs :$flex$.Category_From AR إلى الفئة إلى D Bis Bis Kategorie E A Categoría Superior F A Catégorie - A I A Categoria (max) JA 至 カテゴリ:上位 KO 까지 범주 상한 PTB Até Categoria - Superior RU По Категория по S Till Till kategori TR Son Kategori Üst Değeri US Category To Category High ZHS 至 类别上限 5 60 1=1 msiv.concatenated_segments >= :p_item_lo 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 AR الأصناف من صنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Article - De I Articoli - Da Articolo - Minimo JA 品目:自 品目:下位 KO 품목: 부터 품목 하한 PTB Itens - De Item Inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem Alt Değeri US Item From Item Low ZHS 物料自 物料下限 6 70 1=1 msiv.concatenated_segments <= :p_item_hi 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 :$flex$.Item_From AR إلى 2 صنف إلى D Bis 2 Bis Artikel E A 2 A Artículo F A 2 Article - A I A 2 Articolo - Massimo JA 至 2 品目:上位 KO 까지 2 품목 상한 PTB Até 2 Item Superior RU По 2 Позиция по S Till 2 Till artikel TR Son 2 Kalem Üst Değeri US Item To Item High ZHS 至 2 物料上限 7 80 2=2 (x.cat_set_control_level = xxen_util.meaning(1,'ITEM_CONTROL_LEVEL_GUI',700) and x.multi_item_cat_assign_allowed is null and x.mast_cat_set_item_assign_count > 1 ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Cat. Set Control Level Violated :$flex$.Category_From Category From Category To :$flex$.Item_From Item From Item To :$flex$.category_set Category Set Category From :$flex$.category_set Category Set Category To :$flex$.organization_code Organization Code Category Set