ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 624852BBC96B1052E0530100007FF101Y select msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, xxen_util.meaning(mild.default_type,'MTL_DEFAULT_LOCATORS',700) default_type, milk.subinventory_code subinventory, nvl(inv_project.get_locator(milk.inventory_location_id,milk.organization_id),milk.concatenated_segments) locator, milk.description locator_description, mp.organization_code, haouv.name organization, xxen_util.user_name(mild.created_by) created_by, xxen_util.client_time(mild.creation_date) creation_date, xxen_util.user_name(mild.last_updated_by) last_updated_by, xxen_util.client_time(mild.last_update_date) last_update_date from hr_all_organization_units_vl haouv, mtl_parameters mp, mtl_item_loc_defaults mild, mtl_system_items_vl msiv, mtl_item_locations_kfv milk where 1=1 and mp.organization_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and haouv.organization_id=mild.organization_id and mp.organization_id=mild.organization_id and mild.inventory_item_id=msiv.inventory_item_id and mild.organization_id=msiv.organization_id and mild.organization_id=milk.organization_id and mild.locator_id=milk.inventory_location_id order by msiv.concatenated_segments, mp.organization_code, default_type Added inv organization security US INV Item Default Transaction Locators Master data report of Inventory Items and the default locators for shipping, receiving or move order receipt transactions Enginatics 1=1 1 10 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 2 20 1=1 mild.subinventory_code=:subinventory_code LOV custom Y select msi.secondary_inventory_name value, msi.description from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_code=:$flex$.organization_code and mp.organization_id=msi.organization_id order by msi.secondary_inventory_name F Sous-inventaire US Subinventory 3 30 1=1 mp.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