DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_REPORT_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 307: jtf_rs_resource_extns_vl ext,

303: g1.group_id
304: from
305: jtf_rs_groups_vl g2,
306: jtf_rs_groups_vl g3,
307: jtf_rs_resource_extns_vl ext,
308: jtf_objects_vl lkp ,
309: fnd_user fnd,
310: jtf_rs_group_members_aud gm,
311: jtf_rs_group_members mem,

Line 359: jtf_rs_resource_extns_vl ext

355: jtf_objects_vl lkp,
356: jtf_rs_groups_vl g1,
357: jtf_rs_group_members_aud gm,
358: jtf_rs_group_members mem,
359: jtf_rs_resource_extns_vl ext
360: where ext.resource_id = l_res_id
361: and mem.resource_id = ext.resource_id
362: and gm.group_member_id = mem.group_member_id
363: and gm.creation_date between nvl(l_start_date,sysdate)

Line 1007: jtf_rs_resource_extns_vl res,

1003: select mem.resource_id,
1004: res.resource_name,
1005: obj.name category_name
1006: from jtf_rs_group_members mem,
1007: jtf_rs_resource_extns_vl res,
1008: jtf_objects_vl obj
1009: where mem.group_id = l_group_id
1010: and nvl(mem.delete_flag, 'N') <> 'Y'
1011: and mem.resource_id = res.resource_id

Line 1024: jtf_rs_resource_extns_vl res,

1020: obj.name category_name,
1021: rol.res_rl_start_date,
1022: rol.res_rl_end_date
1023: from jtf_rs_group_members mem,
1024: jtf_rs_resource_extns_vl res,
1025: jtf_rs_defresroles_vl rol,
1026: jtf_objects_vl obj
1027: where mem.group_id = l_group_id
1028: and nvl(mem.delete_flag, 'N') <> 'Y'

Line 1244: jtf_rs_resource_extns_vl ext,

1240: g1.group_id
1241: from
1242: jtf_rs_groups_vl g2,
1243: jtf_rs_groups_vl g3,
1244: jtf_rs_resource_extns_vl ext,
1245: jtf_objects_vl lkp ,
1246: fnd_user fnd,
1247: jtf_rs_group_members_aud gm,
1248: jtf_rs_group_members mem,