ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF8B3869E053B46B63588994Y select * from ( select fg.grantee_key AS RoleName, fg.name AS GrantName, fnd_message.get_STRING('FND','W3H_YES_ACCESSIBILITY') AS Accessibility, (select user_name from fnd_user where user_id=fg.created_by) AS GrantCreatedBy, fg.creation_date AS GrantCreationDate, (select user_name from fnd_user where user_id=fg.last_updated_by) AS GrantUpdatedBy, fg.last_update_date AS GrantUpdateDate from fnd_objects fo,fnd_grants fg where fo.object_id=fg.object_id and fg.start_date <= sysdate and (sysdate <= fg.end_date or fg.end_date is null) and fo.obj_name= :PARAM1 and fg.grantee_type='GROUP' union all select fg.grantee_key AS RoleName,fg.name "Grant Name", fnd_message.get_STRING('FND','W3H_NO_ACCESSIBILITY') AS Accessibility, (select user_name from fnd_user where user_id=fg.created_by) AS GrantCreatedBy, fg.creation_date AS GrantCreationDate, (select user_name from fnd_user where user_id=fg.last_updated_by) AS GrantUpdatedBy, fg.last_update_date AS GrantUpdateDate from fnd_objects fo,fnd_grants fg where fo.object_id=fg.object_id and (sysdate < fg.start_date or sysdate > fg.end_date) and fo.obj_name= :PARAM1 and fg.grantee_type='GROUP' ) &PARAM2 FND W3H_Object_RolesResp AR FND W3H_Object_RolesResp Application: مكتبة وحدات التطبيقات Source: Short Name: W3H_Object_RolesResp DB package: D FND W3H_Object_RolesResp Application: Basisbibliothek Source: Short Name: W3H_Object_RolesResp DB package: US FND W3H_Object_RolesResp Application: Application Object Library Source: Short Name: W3H_Object_RolesResp DB package: ZHS FND W3H_Object_RolesResp Application: 应用对象程序库 Source: Short Name: W3H_Object_RolesResp DB package: BI Publisher &param2 :param1