-- 職責清單
-- Responsibilities
select --FR.APPLICATION_ID,FR.RESPONSIBILITY_ID,
FR.RESPONSIBILITY_NAME,
FA.APPLICATION_NAME,
FR.RESPONSIBILITY_KEY,
FR.DESCRIPTION,
FR.START_DATE,
FR.END_DATE,
DECODE(FR.DATA_GROUP_ID,0,'Standard','Multiple Reporting Currencies') AS DATA_GROUP_NAME,
-- FR.DATA_GROUP_APPLICATION_ID,
DGFA.APPLICATION_NAME AS "DATA_GROUP_APPLICATION",
-- FR.MENU_ID,
FM.MENU_NAME,
FRG.REQUEST_GROUP_NAME,
-- FR.GROUP_APPLICATION_ID,
gfa.application_name as "REQUEST_GROUP_APPLICATION"
-- FR.REQUEST_GROUP_ID
--FR.*
from apps.FND_RESPONSIBILITY_VL FR,
apps.fnd_application_vl FA,
apps.fnd_application_vl DGFA,
apps.fnd_application_vl GFA,
apps.FND_MENUS_VL FM,
apps.FND_REQUEST_GROUPS FRG
where FR.APPLICATION_ID = FA.APPLICATION_ID
AND FR.MENU_ID = FM.MENU_ID
AND FR.DATA_GROUP_APPLICATION_ID = DGFA.APPLICATION_ID
AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
and FR.GROUP_APPLICATION_ID = gfa.application_id
AND FR.responsibility_NAME LIKE '%DG%'
ORDER BY FR.APPLICATION_ID