ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 0B22DF18E239D64AE0630100007FBD85 INV Organization Code (including master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where 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) 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 order by ood.organization_code US All active inventory organization codes, restricted to the current user's org access view 4F6BD8FAAAFF4676E0630100007F438A select mp.organization_code organization, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, micgbk.concatenated_segments catalog_group, micg.description catalog_description, xxen_util.meaning(msiv.catalog_status_flag,'YES_NO',0) catalog_complete, mde.element_sequence, mde.element_name, mdev.element_value, mde.description element_description, xxen_util.meaning(mde.required_element_flag,'YES_NO',0) required, xxen_util.meaning(mdev.default_element_flag,'YES_NO',0) default_value from mtl_descr_element_values mdev, mtl_system_items_vl msiv, mtl_parameters mp, mtl_item_catalog_groups_b_kfv micgbk, mtl_item_catalog_groups micg, mtl_descriptive_elements mde where mdev.inventory_item_id=msiv.inventory_item_id and msiv.organization_id=mp.organization_id and msiv.item_catalog_group_id=micgbk.item_catalog_group_id and mde.item_catalog_group_id=micgbk.item_catalog_group_id and micg.item_catalog_group_id=micgbk.item_catalog_group_id and mdev.element_name=mde.element_name and 1=1 order by mp.organization_code, msiv.concatenated_segments, mde.element_sequence Y US INV Item Catalog Descriptive Elements Report showing item catalog group descriptive elements with their values, descriptions, required and default flags Enginatics Nidec changes 1=1 1 10 1=1 mp.organization_code=:organization_code LOV INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where 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) 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 order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code 2 20 1=1 micgbk.concatenated_segments=:catalog_group LOV custom Y select micgbk.concatenated_segments value, micgbk.description from mtl_item_catalog_groups_b_kfv micgbk where nvl(micgbk.inactive_date,sysdate)>=sysdate order by micgbk.concatenated_segments US Catalog Group 3 30 1=1 msiv.concatenated_segments=: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 US Item 4 40 1=1 xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3)=:item_type LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Item Type 5 50 1=1 mde.element_name=:element_name LOV custom Y select distinct mde.element_name value, mde.description from mtl_descriptive_elements mde order by mde.element_name US Element Name 6 60 1=1 mdev.element_value=:element_value LOV custom Y Y select distinct mdev.element_value value, null description from mtl_descr_element_values mdev where mdev.element_value is not null order by mdev.element_value US Element Value 7 70 1=1 xxen_util.meaning(msiv.catalog_status_flag,'YES_NO',0)=:catalog_complete 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 US Catalog Complete