ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF8E3869E053B46B63588994Y select fg.grantee_key as AssignedThrough,fg.instance_type,fm.menu_name "menu_name" , UMX_W3H_UTL.getObjectDetails(fm.menu_name) "Permissions", fo.obj_name ,decode( decode (sign(sysdate - nvl (wf.start_date, sysdate - 1)), 1,decode (sign (nvl(wf.expiration_date, sysdate + 1) - sysdate), 1, 'ACTIVE', 'INACTIVE'),-1, 'INACTIVE', 'ACTIVE'),'INACTIVE',fnd_message.get_string('FND','W3H_NO_ACCESSIBILITY'), decode ( (fg.start_date-sysdate)-abs(fg.start_date-sysdate) ,0,fnd_message.get_string('FND','W3H_NO_ACCESSIBILITY'), decode((nvl(fg.end_date,sysdate+1)-sysdate)-abs((nvl(fg.end_date,sysdate+1)-sysdate)),0, fnd_message.get_string('FND','W3H_YES_ACCESSIBILITY'),fnd_message.get_string('FND','W3H_NO_ACCESSIBILITY')) ) ) "Accessibility" from fnd_grants fg,fnd_objects fo, fnd_menus fm,wf_local_roles wf where fg.object_id=fo.object_id and fm.menu_id=fg.menu_id and wf.name=fg.grantee_key and fg.grantee_key= :PARAM1 and fo.obj_name = :ObjName union all select fg.grantee_key as AssignedThrough,fg.instance_type,fm.menu_name "menu_name" , UMX_W3H_UTL.getObjectDetails(fm.menu_name) "Permissions", fo.obj_name ,decode( decode (sign(sysdate - nvl (wf.start_date, sysdate - 1)), 1,decode (sign (nvl(wf.expiration_date, sysdate + 1) - sysdate), 1, 'ACTIVE', 'INACTIVE'),-1, 'INACTIVE', 'ACTIVE'),'INACTIVE',fnd_message.get_string('FND','W3H_NO_ACCESSIBILITY'), decode ( (fg.start_date-sysdate)-abs(fg.start_date-sysdate) ,0,fnd_message.get_string('FND','W3H_NO_ACCESSIBILITY'), decode((nvl(fg.end_date,sysdate+1)-sysdate)-abs((nvl(fg.end_date,sysdate+1)-sysdate)),0, fnd_message.get_string('FND','W3H_YES_ACCESSIBILITY'),fnd_message.get_string('FND','W3H_NO_ACCESSIBILITY')) ) ) "Accessibility" from fnd_grants fg,fnd_objects fo, fnd_menus fm,wf_local_roles wf where fg.object_id=fo.object_id and fm.menu_id=fg.menu_id and wf.name=fg.grantee_key and fg.grantee_key in ( select super_name from wf_role_hierarchies where enabled_flag='Y' connect by prior super_name=sub_name and prior enabled_flag='Y' start with sub_name= :PARAM1 ) and fo.obj_name = :ObjName FND W3H_Role_Objects AR FND W3H_Role_Objects Application: مكتبة وحدات التطبيقات Source: Short Name: W3H_Role_Objects DB package: D FND W3H_Role_Objects Application: Basisbibliothek Source: Short Name: W3H_Role_Objects DB package: US FND W3H_Role_Objects Application: Application Object Library Source: Short Name: W3H_Role_Objects DB package: ZHS FND W3H_Role_Objects Application: 应用对象程序库 Source: Short Name: W3H_Role_Objects DB package: BI Publisher :objname :param1