DBA Data[Home] [Help]

APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on JTF_RS_DBI_MGR_GROUPS_S

Line 127: jtf_rs_dbi_mgr_groups_s.nextval, x.resource_id, x.user_id, x.group_id

123: INTO jtf_rs_dbi_mgr_groups
124: (dbi_mgr_id, resource_id, user_id, group_id,
125: creation_date, created_by )
126: SELECT /*+ use_hash(x) parallel(x) */
127: jtf_rs_dbi_mgr_groups_s.nextval, x.resource_id, x.user_id, x.group_id
128: , l_sysdate, l_user_id
129: FROM (
130: SELECT /*+ use_hash(res mgr) parallel(res) parallel(mgr) */
131: DISTINCT mgr.resource_id, res.user_id, mgr.group_id