Oracle Ebs-sql (SYS-8): Responsibility definition details. SQL

SELECT DISTINCT fa.application_short_name module,
B.responsibility_name responsibility name, Fa.application_name application product,
B.responsibility_key Responsibility keyword, b.description description,
DECODE (b.data_group_id, 0, ' standard ', ') data sets,
Fa3.application_name Data Set Application products, Fmv.user_menu_name menu,
Frg.request_group_name Request Group,
Fa2.application_name Request Group App Product
From APPS.FND_APPLICATION_VL FA,
APPS.FND_RESPONSIBILITY_VL B,
APPS.FND_MENUS_VL FMV,
Applsys.fnd_request_groups FRG,
APPS.FND_APPLICATION_VL Fa3,
APPS.FND_APPLICATION_VL FA2
WHERE B.responsibility_name in (SELECT col
From Able_test)
and b.application_id = fa.application_id
and b.menu_id = fmv.menu_id (+)
and b.data_group_application_id = fa3.application_id (+)
and b.request_group_id = frg.request_group_id (+)
and frg.application_id = fa2.application_id (+)