APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on JTF_RS_DBI_DENORM_RES_GROUPS_S

Line 169: 'Z-TOP-MANAGER-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id, 'N' mem_flag,

165: SELECT /*+ use_hash(g x) parallel(g) parallel(x) */
166: ' * ' VALUE, x.group_id id , TO_NUMBER(-9999) current_id,
167: x.group_id parent_id, TO_NUMBER(0) denorm_level, g.start_date_active start_date,
168: g.end_date_active end_date, x.user_id user_id, x.resource_id resource_id,
169: 'Z-TOP-MANAGER-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id, 'N' mem_flag,
170: 'A' mem_status, l_sysdate creation_date, l_user_id created_by
171: , 'Y' active_grp_rel_only
172: FROM (
173: SELECT /*+ use_hash(res mgr) parallel(res) parallel(mgr) */

Line 215: '0-FIRST-TIME-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval

211: d1.group_id id,
212: TO_NUMBER(-1111) current_id, d1.actual_parent_id parent_id,
213: d1.denorm_level , d1.start_date_active start_date,
214: d1.end_date_active end_date, n1.user_id ,n1.resource_id ,
215: '0-FIRST-TIME-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval
216: ,'N' mem_flag , 'A' mem_status
217: ,l_sysdate, l_user_id
218: ,DECODE(d1.active_flag,'Y','Y','N')
219: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1

Line 253: jtf_rs_dbi_denorm_res_groups_s.nextval

249: d1.group_id id, d2.group_id current_id,
250: d1.actual_parent_id parent_id, d1.denorm_level,
251: d1.start_date_active start_date, d1.end_date_active end_date,
252: n1.user_id, n1.resource_id, 'A-PARENT' debug_column,
253: jtf_rs_dbi_denorm_res_groups_s.nextval
254: ,'N' mem_flag , 'A' mem_status
255: ,l_sysdate, l_user_id
256: ,DECODE(d1.active_flag,'Y','Y','N')
257: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,

Line 295: jtf_rs_dbi_denorm_res_groups_s.nextval

291: , d1.group_id id, d1.group_id current_id,
292: d1.actual_parent_id parent_id, d1.denorm_level,
293: d1.start_date_active start_date, d1.end_date_active end_date,
294: n1.user_id, n1.resource_id, 'C-SELF' debug_column,
295: jtf_rs_dbi_denorm_res_groups_s.nextval
296: ,'N' mem_flag , 'A' mem_status
297: ,l_sysdate, l_user_id
298: ,DECODE(d1.active_flag,'Y','Y','N')
299: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

Line 332: , jtf_rs_dbi_denorm_res_groups_s.nextval

328: ,d1.group_id id,
329: d1.actual_parent_id current_id, d1.actual_parent_id parent_id,
330: d1.denorm_level, d1.start_date_active start_date,
331: d1.end_date_active end_date, n1.user_id, n1.resource_id, 'D-CHILD' debug_column
332: , jtf_rs_dbi_denorm_res_groups_s.nextval
333: ,'N' mem_flag , 'A' mem_status
334: ,l_sysdate, l_user_id
335: ,DECODE(d1.active_flag,'Y','Y','N')
336: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

Line 377: drg1.user_id, drg1.resource_id, 'B-PEER' DEBUG_COLUMN , jtf_rs_dbi_denorm_res_groups_s.nextval

373: /* DECODE (d1.active_flag ,'Y', ' -- ', ' -- [ ') VALUE,
374: d1.group_id id, drg1.current_id current_id,
375: d1.parent_group_id parent_id, d1.denorm_level denorm_level,
376: d1.start_date_active start_date, d1.end_date_active end_date,
377: drg1.user_id, drg1.resource_id, 'B-PEER' DEBUG_COLUMN , jtf_rs_dbi_denorm_res_groups_s.nextval
378: ,'N' mem_flag , 'A' mem_status
379: ,l_sysdate, l_user_id
380: ,DECODE(d1.active_flag,'Y','Y','N') active_grp_rel_only
381: FROM jtf_rs_groups_denorm d1,

Line 427: ''E-SELF-GROUP-MEMBERS'' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id

423: active_grp_rel_only )
424: SELECT Decode(x.mem_status,''I'',''----[ '',''----'')value,
425: x.resource_id||''.''||x.group_id id_for_grp_mem, x.group_id current_id,
426: x.group_id parent_id, to_number(100) denorm_level,
427: ''E-SELF-GROUP-MEMBERS'' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id
428: ,x.resource_id grp_mem_resource_id, ''Y'' mem_flag, x.mem_status
429: ,:l_sysdate, :l_user_id, ''Y'' active_grp_rel_only
430: FROM (
431: SELECT /*+ use_hash(gm1 rrl1 rol1) PARALLEL(gm1) PARALLEL(rrl1) PARALLEL(rol1) */

Line 517: ''F-FIRST-TIME-GROUP-MEMBERS'' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id

513: created_by )
514: SELECT Decode(x.mem_status,''I'',''--[ '',''--'')value,
515: x.grp_mem_resource_id||''.''||x.group_id id_for_grp_mem, to_number(-1111) current_id,
516: x.group_id parent_id, to_number(1) denorm_level, x.user_id, x.resource_id,
517: ''F-FIRST-TIME-GROUP-MEMBERS'' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id
518: ,x.grp_mem_resource_id, ''Y'' mem_flag, x.mem_status
519: ,:l_sysdate, :l_user_id
520: FROM (
521: SELECT /*+ use_hash(dbi mem rrl rol) PARALLEL(dbi) PARALLEL(mem) PARALLEL(rrl)