DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on FND_MENUS

Line 79: , fnd_menus fmu

75: IS SELECT DISTINCT fmu.menu_name Privilege
76: , fgs.instance_pk1_value ResourceID
77: , jrt.resource_name ResourceName
78: FROM fnd_grants fgs
79: , fnd_menus fmu
80: , fnd_objects fos
81: , jtf_rs_resource_extns_tl jrt
82: WHERE fgs.object_id = fos.object_id -- grants joint to object
83: AND fgs.menu_id = fmu.menu_id -- grants joint to menus

Line 105: , fnd_menus fmu

101: IS SELECT DISTINCT DECODE(fmu.menu_name,'JTF_CAL_ADMIN_ACCESS','JTF_CAL_FULL_ACCESS',FMU.MENU_NAME) Privilege
102: , fgs.instance_pk1_value ResourceID
103: , jrt.group_name ResourceName
104: FROM fnd_grants fgs
105: , fnd_menus fmu
106: , fnd_objects fos
107: , jtf_rs_groups_tl jrt
108: WHERE fgs.object_id = fos.object_id -- grants joint to object
109: AND fgs.menu_id = fmu.menu_id -- grants joint to menus

Line 1776: , fnd_menus fmu

1772: b_resource_type VARCHAR2
1773: ) IS
1774: SELECT fmu.menu_name
1775: FROM fnd_grants fgs
1776: , fnd_menus fmu
1777: , fnd_objects fos
1778: WHERE fgs.object_id = fos.object_id
1779: AND fgs.menu_id = fmu.menu_id
1780: AND fos.obj_name = 'CAC_CAL_RESOURCES'