DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_TEAM_USAGES

Line 385: jtf_rs_team_usages tu,

381: min(t.team_id) team_id,
382: tres.category resource_category
383: FROM jtf_rs_team_members tm,
384: jtf_rs_teams_b t,
385: jtf_rs_team_usages tu,
386: jtf_rs_role_relations trr,
387: jtf_rs_roles_b tr,
388: jtf_rs_resource_extns tres,
389: (

Line 452: jtf_rs_team_usages tu,

448: (
449: SELECT tm.team_resource_id group_id, t.team_id team_id
450: FROM jtf_rs_team_members tm,
451: jtf_rs_teams_b t,
452: jtf_rs_team_usages tu,
453: jtf_rs_role_relations trr,
454: jtf_rs_roles_b tr,
455: jtf_rs_resource_extns tres
456: WHERE tm.team_id = t.team_id