Request for List of Application wise Seeded Responsibilities for Oracle E- Business Suite

The Application wise Seeded Responsibilities for R12.2 Version and request to include the following information:

Responsibility Name

Description

User_Menu_Name

Menu_Desc

Responsibility_Key

Application_Short_Name

Application_Name

Menu Name

 

 

 

1)SELECT DISTINCT

    –fu.user_name,

    frt.responsibility_name,

    frt.description,

    fmt.user_menu_name,

    fmt.description menu_desc,

—    furg.start_date,

—    furg.end_date,

    fr.responsibility_key,

    fa.application_short_name,

    fat.application_name

FROM

    –fnd_user_resp_groups_direct     furg,

    –applsys.fnd_user                fu,

    applsys.fnd_responsibility_tl   frt,

    applsys.fnd_responsibility      fr,

    applsys.fnd_application_tl      fat,

    applsys.fnd_application         fa,

    applsys.fnd_menus_tl            fmt

WHERE 1 = 1

    –AND furg.user_id = fu.user_id

    –AND furg.responsibility_id = frt.responsibility_id

    AND fr.responsibility_id = frt.responsibility_id

    AND fa.application_id = fat.application_id

    AND fr.application_id = fat.application_id

    AND fr.menu_id = fmt.menu_id

    –AND fu.end_date IS NULL

    –AND furg.end_date IS NULL

ORDER BY

    fat.application_name,

    –fu.user_name,

    frt.responsibility_name;

 

 

 

2)SELECT

    fu.user_name,

    frt.responsibility_name,

    frt.description,

    fmt.user_menu_name,

    fmt.description menu_desc,

    furg.start_date,

    furg.end_date,

    fr.responsibility_key,

    fa.application_short_name,

    fat.application_name

FROM

    fnd_user_resp_groups_direct     furg,

    applsys.fnd_user                fu,

    applsys.fnd_responsibility_tl   frt,

    applsys.fnd_responsibility      fr,

    applsys.fnd_application_tl      fat,

    applsys.fnd_application         fa,

    applsys.fnd_menus_tl            fmt

WHERE

    furg.user_id = fu.user_id

    AND furg.responsibility_id = frt.responsibility_id

    AND fr.responsibility_id = frt.responsibility_id

    AND fa.application_id = fat.application_id

    AND fr.application_id = fat.application_id

    AND fr.menu_id = fmt.menu_id

    AND fu.end_date IS NULL

    AND furg.end_date IS NULL

ORDER BY

    fat.application_name,

    fu.user_name,

    frt.responsibility_name;

 

 

 

 

 

 

 

 

 

 

 

 

Leave a Comment

Your email address will not be published.