Wednesday, 16 August 2017

How to find the secuity profile id by using the Organization Id in R12 ?

select           psp.SECURITY_PROFILE_ID
                   ,psp.BUSINESS_GROUP_ID
                   ,psp.ORGANIZATION_ID
                   ,psp.SECURITY_PROFILE_NAME
from per_Security_profiles psp
        ,per_security_organizations pso
        ,hr_operating_units hou
where 1=1
and psp.SECURITY_PROFILE_ID = pso.SECURITY_PROFILE_ID
and pso.organization_id = hou.organization_id
and hou.organization_id = 202
and psp.BUSINESS_GROUP_ID = 81;

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...