how to know responsibility from user-conc-pgrm

[gags]

Hi gurus,

i know only information about concurrent program name . Then how to know responsibility for that program.

Thanks and Regards
gags

[ahmadbilal]

[quote]CREATE OR REPLACE VIEW <b>v_resp_menu</b> (responsibility_id,
responsibility_name,
LANGUAGE,
responsibility_key,
application_id,
user_menu_name,
rgid
)
AS
SELECT DISTINCT b.responsibility_id, a.responsibility_name, a.LANGUAGE,
b.responsibility_key, b.application_id, c.user_menu_name,
b.request_group_id rgid
FROM apps.fnd_responsibility_tl a,
apps.fnd_responsibility b,
apps.fnd_menus_tl c,
apps.fnd_menus d
WHERE a.responsibility_id(+) = b.responsibility_id
AND b.menu_id = c.menu_id
AND b.menu_id = d.menu_id
AND a.LANGUAGE = 'US'
/

-------------------------------------------
CREATE OR REPLACE <b>VIEW v_flex_cp_stru </b>(concurrent_program_name,
user_concurrent_program_name,
application_short_name,
column_seq_num,
param_seq,
prompt,
values_set_name
)
AS
SELECT a.concurrent_program_name AS concurrent_program_name,
a.user_concurrent_program_name AS user_concurrent_program_name,
c.application_short_name AS application_short_name,
b.column_seq_num AS column_seq_num, b.srw_param AS param_seq,
b.form_left_prompt AS prompt,
d.flex_value_set_name AS values_set_name
FROM fnd_concurrent_programs_vl a,
fnd_descr_flex_col_usage_vl b,
fnd_application c,
fnd_flex_value_sets d
WHERE a.enabled_flag = 'Y'
AND a.concurrent_program_name =
SUBSTR (b.descriptive_flexfield_name, 7, 100)
AND a.application_id = c.application_id
AND b.enabled_flag = 'Y'
--- and a.concurrent_program_id = 46174
--and UPPER(a.user_concurrent_program_name) like UPPER('%TEXT%')
AND b.flex_value_set_id = d.flex_value_set_id
----- and a.user_concurrent_program_name = 'Adjustment Journal Voucher *'
ORDER BY a.concurrent_program_id, b.column_seq_num
/


----------------------------------------------------------------------

SELECT fcpt.user_concurrent_program_name "C Programe Name",
fcpt.description "Description", exe.executable_name "ExeName",
exe.execution_file_name "Executable File Name",
DECODE (exe.execution_method_code,
'B', 'Request Set Stage Function',
'Q', 'SQL*Plus',
'H', 'Host',
'L', 'SQL*Loader',
'A', 'Spawned',
'I', 'PL/SQL Stored Procedure',
'P', 'Oracle Reports',
'S', 'Immediate',
exe.execution_method_code
) "Execution Method",
fnd.required_style "Style Required",
fnd.output_print_style "Print Style",
fnd.printer_name "Printer Name",
fnd.concurrent_program_id,
frg.request_group_name "Request Group Name",
frg.application_id r_g_applid,
f_application_name (frg.application_id) "APPLICATION NAME",
frg.request_group_id "Request Group Id",
frg.request_group_code "Request Group Code",
frg.description "Request Group Ddescription",
vrm.user_menu_name "Menu name",
vrm.responsibility_name "RESPONSIBLITY NAME",
VFCS.COLUMN_SEQ_NUM "Seq Number",
VFCS.PARAM_SEQ "Token Name",
VFCS.PROMPT "Prompt Name",
VFCS.VALUES_SET_NAME "Value Set Name",
u.User_name "User", wlr.orig_system_id "responsibility_id"
FROM applsys.fnd_executables exe,
applsys.fnd_concurrent_programs fnd,
applsys.fnd_concurrent_programs_tl fcpt,
applsys.fnd_request_groups frg,
applsys.fnd_request_group_units frgu,
apps.v_resp_menu vrm,
V_FLEX_CP_STRU VFCS,
fnd_user u,
wf_all_user_role_assignments waur,
wf_local_roles wlr
WHERE exe.executable_id = fnd.executable_id
AND fnd.concurrent_program_id = fcpt.concurrent_program_id
AND fnd.application_id = fcpt.application_id
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_group_id = vrm.rgid
and u.user_name = waur.user_name
AND waur.role_name = wlr.NAME
and wlr.orig_system_id = vrm.RESPONSIBILITY_ID
and rownum < 10
and VFCS.CONCURRENT_PROGRAM_NAME = fnd.concurrent_program_name
and fcpt.user_concurrent_program_name = 'Account Analysis - (132 Char)'--
--and upper(u.user_name) like upper(:name)
ORDER BY 1;

You can Generate This Report As U Desired (Grouping Option On your Selection)



Sample Out Put

As Follows



C Programe Name Description ExeName Executable File Name Execution Method Style Required Print Style Printer Name CONCURRENT_PROGRAM_ID Request Group Name R_G_APPLID APPLICATION NAME Request Group Id Request Group Code Request Group Ddescription Menu name RESPONSIBLITY NAME Seq Number Token Name Prompt Name Value Set Name User responsibility_id
Account Analysis - (132 Char) Account Analysis Report GLRJED GLRJED Oracle Reports N LANDSCAPE 20,127.00 AX General Ledger Supervisor 600.00 AX 835.00 AX General Ledger Supervisor AX General Ledger Supervisor General Ledger Supervisor Vision France 10 P_SET_OF_BOOKS_ID Set of Books Id GL_SRS_NULL_NUM BRUNO 51,787.00
Account Analysis - (132 Char) Account Analysis Report GLRJED GLRJED Oracle Reports N LANDSCAPE 20,127.00 AX General Ledger Supervisor 600.00 AX 835.00 AX General Ledger Supervisor AX General Ledger Supervisor AX General Ledger Supervisor 10 P_SET_OF_BOOKS_ID Set of Books Id GL_SRS_NULL_NUM ITALY 51,578.00
Account Analysis - (132 Char) Account Analysis Report GLRJED GLRJED Oracle Reports N LANDSCAPE 20,127.00 AX General Ledger Supervisor 600.00 AX 835.00 AX General Ledger Supervisor AX General Ledger Supervisor Accounting Engine General Ledger Supervisor 10 P_SET_OF_BOOKS_ID Set of Books Id GL_SRS_NULL_NUM DATAMERGE 21,629.00
Account Analysis - (132 Char) Account Analysis Report GLRJED GLRJED Oracle Reports N LANDSCAPE 20,127.00 AX General Ledger Supervisor 600.00 AX 835.00 AX General Ledger Supervisor AX General Ledger Supervisor General Ledger Supervisor Vision France 10 P_SET_OF_BOOKS_ID Set of Books Id GL_SRS_NULL_NUM FRANCE 51,787.00
Account Analysis - (132 Char) Account Analysis Report GLRJED GLRJED Oracle Reports N LANDSCAPE 20,127.00 AX General Ledger Supervisor 600.00 AX 835.00 AX General Ledger Supervisor AX General Ledger Supervisor General Ledger Supervisor Vision France 10 P_SET_OF_BOOKS_ID Set of Books Id GL_SRS_NULL_NUM ALAIN 51,787.00