To get the Responsibility Details of Concurrent Program
=====================================

SELECT DISTINCT responsibility_name
            FROM  apps.FND_REQUEST_GROUPS frg
                , apps.FND_REQUEST_GROUP_UNITS frgu
                , apps.fnd_concurrent_programs_tl fcp
                , apps.FND_RESPONSIBILITY_VL frv
           WHERE  frg.request_group_id = frgu.request_group_id
             AND  frgu.request_unit_id = fcp.concurrent_program_id
             AND  fcp.user_concurrent_program_name = '&concurrent_program_name'
             AND  fcp.language = 'US'
             AND  frv.request_group_id = frg.request_group_id

To Get DFF Segments details:
====================
SELECT ffv.descriptive_flexfield_name "DFF   Name",
         ffv.application_table_name "Table Name",
         ffv.title "Title",
         ap.application_name "Application",
         ffc.descriptive_flex_context_code "Context Code",
         ffc.descriptive_flex_context_name "Context Name",
         ffc.description "Context Desc",
         ffc.enabled_flag "Context Enable Flag",
         att.column_seq_num "Segment Number",
         att.form_left_prompt "Segment Name",
         att.application_column_name "Column",
         fvs.flex_value_set_name "Value Set",
         att.display_flag "Displayed",
         att.enabled_flag "Enabled",
         att.required_flag "Required"
    FROM apps.fnd_descriptive_flexs_vl ffv,
         apps.fnd_descr_flex_contexts_vl ffc,
         apps.fnd_descr_flex_col_usage_vl att,
         apps.fnd_flex_value_sets fvs,
         apps.fnd_application_vl ap
   WHERE     ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
         AND ap.application_id = ffv.application_id
         AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
         AND ffv.application_id = ffc.application_id
         AND ffc.descriptive_flex_context_code =
                att.descriptive_flex_context_code
         AND fvs.flex_value_set_id = att.flex_value_set_id
         ---AND ffv.title LIKE 'Invoice'
          and ffv.application_table_name='PO_VENDOR_SITES_ALL'
    ---     AND ffc.descriptive_flex_context_code LIKE 'Give Context Code Value'
ORDER BY ffv.title,att.column_seq_num