How to to find out the existing version for Oracle GRC

AACG : 8.6.4.x and above releases

Front End:
- Login to the AACG Application
- Click on the Idle Icon on the right top corner
- a pop-up message will contains the version

Or

Backend :
Run : select * from grc_sys_version;


CCG : 5.5.x and above

Front End:
- Login to the CCG Application
- Click on Help > About Products
- Release Number will give you the version details, and the Patch history will give the list of critical patches which are applied on the instance

Or

Backend :
Run : select * from am_product_patches order by patch_start_date desc;

PCG : 7.x and above

Front End:
- Login to the EBS Application
- GRC Controls Responsibility, Navigator select Administration, and then Install History.

Or

Backend :
Run : select * from la_install_history order by install_time desc;

Operating unit and responsibility name identifying based in query in oracle

Query responsibilities given the OU name

/* Formatted on 10/13/2015 5:19:16 PM (QP5 v5.240.12305.39446) */
  SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME
    FROM apps.fnd_profile_options_vl fpo,
         apps.fnd_responsibility_vl frv,
         apps.fnd_profile_option_values fpov,
         apps.hr_organization_units hou
   WHERE     hou.NAME = :p_ou_name
         AND fpov.profile_option_value = TO_CHAR (hou.organization_id)
         AND fpo.profile_option_id = fpov.profile_option_id
         AND fpo.user_profile_option_name = 'MO: Operating Unit'
         AND frv.responsibility_id = fpov.level_value
ORDER BY frv.responsibility_name

Query OU given the responsibilities name

/* Formatted on 10/13/2015 5:19:05 PM (QP5 v5.240.12305.39446) */
  SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME
    FROM apps.hr_organization_units hou,
         apps.fnd_profile_options_vl fpo,
         apps.fnd_profile_option_values fpov,
         apps.fnd_responsibility_vl frv
   WHERE     frv.responsibility_name = :p_resp_name
         AND fpov.level_value = frv.responsibility_id
         AND fpo.profile_option_id = fpov.profile_option_id
         AND fpo.user_profile_option_name = 'MO: Operating Unit'
         AND fpov.profile_option_id = fpo.profile_option_id
         AND hou.organization_id = TO_NUMBER (fpov.profile_option_value)
ORDER BY frv.responsibility_name

GRC Control table name in oracle apps

select * from GRC_WORKLIST_TL -- Control Name

select * from GRC_CTRL_CCM_CONTROL_V -- control name active or inactive

select * from GRC_ENT_ENTITLEMENT_B  -- Entitlement Name

GRC JOB detail

select * from GRC_JOB

Current running job.

select * from GRC_JOB_VL  where trunc(creation_date) = trunc(sysdate) and END_DATE is null