eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_VIEW_PVT dependencies on FND_GRANTS

Line 78: FROM fnd_grants fgs

74: ****************************************************************/
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

Line 104: FROM fnd_grants fgs

100: *****************************************************************************/
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

Line 1775: FROM fnd_grants fgs

1771: b_resource_id NUMBER,
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

Line 1939: FROM fnd_grants fgs

1935: ( b_ResourceID
1936: , 'RS_EMPLOYEE'
1937: , TO_NUMBER(fgs.instance_pk1_value)
1938: ) Prefix*/
1939: FROM fnd_grants fgs
1940: , fnd_objects fos
1941: , jtf_rs_group_usages rgu
1942: WHERE fgs.object_id = fos.object_id -- grants joint to object
1943: AND fos.obj_name = 'JTF_TASK_RESOURCE'