Query to find responsibilities for a Concurrent program in EBS R12

SELECT

    frt.responsibility_name,

    frg.request_group_name,

    frgu.request_unit_type,

    frgu.request_unit_id,

    fcpt.user_concurrent_program_name

FROM

    fnd_responsibility          fr,

    fnd_responsibility_tl       frt,

    fnd_request_groups          frg,

    fnd_request_group_units     frgu,

    fnd_concurrent_programs_tl  fcpt

WHERE

        frt.responsibility_id = fr.responsibility_id

    AND frg.request_group_id = fr.request_group_id

    AND frgu.request_group_id = frg.request_group_id

    AND fcpt.concurrent_program_id = frgu.request_unit_id

    AND frt.language = userenv('LANG')

    AND fcpt.language = userenv('LANG')

    AND fcpt.user_concurrent_program_name = 'XXAP'

ORDER BY

    1,

    2,

    3,

    4;

Query to find Form Personalization in Oracle EBS R12

    SELECT ffv.form_id          ,

       ffv.form_name      ,

       ffv.user_form_name ,

       ffv.description    ,

       ffcr.sequence     ,

       ffcr.description  

  FROM fnd_form_vl             ffv,

       fnd_form_custom_rules   ffcr

 WHERE ffv.form_name = ffcr.form_name

 AND   ffv.form_name = 'APXINWKB'

 ORDER BY ffv.form_name, ffcr.sequence;

 

 SELECT

    ffcr.SEQUENCE "Seq", ffcr.description ,

    DECODE (ffcr.rule_type,

           'F', 'Form',

            'A', 'Function',

            'Other'

           ) "Level",

    ffcr.enabled "Enabled",

    ffcr.trigger_event "Trigger Event",

    ffcr.trigger_object "Trigger Object",

    ffcr.condition "Condition",

    DECODE (ffcr.fire_in_enter_query,

            'Y', 'Both',

            'N', 'Not in Enter-Query Mode',

            'O', 'Only in Enter-Query Mode',

            'Other'

           ) Mode

FROM apps.fnd_form_custom_rules ffcr

WHERE 1=1 

    AND ffcr.form_name = 'APXINWKB'

ORDER BY ffcr.SEQUENCE;

Select 

    A.Id,

    A.Form_Name ,

    A.Enabled,

    C.User_Form_Name,

    D.Application_Name ,

    A.Description,

    Ca.Action_Type,

    Ca.Enabled,

    Ca.Object_Type,

    ca.message_type,

    ca.message_text

from

    FND_FORM_CUSTOM_RULES a,

    FND_FORM b,

    FND_FORM_TL c,

    Fnd_Application_Tl D,

    Fnd_Form_Custom_Actions ca

where a.form_name = b.form_name

    And B.Form_Id = C.Form_Id

    And B.Application_Id = D.Application_Id

    and application_name ='Payables'

    And C.User_Form_Name Like '%Invoice%'  

    And A.Enabled ='Y'

    and a.id = ca.rule_id