ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDE9E79D2E0530100007F1FF2 FND Responsibility Name Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US 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 6237AC4408194A72E0530100007FEC65 select oav.organization_code, oav.organization_name, (select xxen_util.meaning('Y','YES_NO',0) from mtl_parameters mp where oav.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id) is_master_org, fav.application_name application, frv.responsibility_name responsibility, oa.comments, xxen_util.user_name(oa.created_by) created_by, xxen_util.client_time(oa.creation_date) creation_date, xxen_util.user_name(oa.last_updated_by) last_updated_by, xxen_util.client_time(oa.last_update_date) last_update_date from org_access_view oav, org_access oa, fnd_responsibility_vl frv, fnd_application_vl fav where 1=1 and oav.organization_id=oa.organization_id(+) and oav.responsibility_id=oa.responsibility_id(+) and oav.resp_application_id=oa.resp_application_id(+) and oav.responsibility_id=frv.responsibility_id and oav.resp_application_id=frv.application_id and oav.resp_application_id=fav.application_id order by oav.organization_code, oav.organization_name, fav.application_name, frv.responsibility_name Y US INV Organization Access Inventory organization access for all responsibilities, either through hr security profile or individual org_access assignment. Enginatics 1=1 1 10 1=1 oav.organization_code=:organization_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 F Code de l'organisation US Organization Code 2 20 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name F Nom de l'application US Application Name 3 30 1=1 frv.responsibility_name=:responsibility LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name F Nom de la responsabilité US Responsibility Name