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.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_DBI_DENORM_RES_GROUPS_S

Line 279: 'Z-TOP-MANAGER-GROUPS', jtf_rs_dbi_denorm_res_groups_s.NEXTVAL, 'N',

275: VALUES (' * ', group_id, TO_NUMBER(-9999),
276: group_id, TO_NUMBER(0),
277: start_date_active, end_date_active,
278: user_id, resource_id,
279: 'Z-TOP-MANAGER-GROUPS', jtf_rs_dbi_denorm_res_groups_s.NEXTVAL, 'N',
280: 'A', l_sysdate, l_user_id ,'Y'
281: , l_sysdate, l_user_id, usage)
282: INTO /*+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING */ jtf_rs_dbi_denorm_res_groups
283: (VALUE,

Line 303: '0-FIRST-TIME-PARENT-GROUPS' , jtf_rs_dbi_denorm_res_groups_s.nextval

299: ,last_update_date, last_updated_by, usage )
300: VALUES ( ' ', group_id , TO_NUMBER(-1111) , group_id ,
301: TO_NUMBER(0) , start_date_active , end_date_active ,
302: user_id , resource_id ,
303: '0-FIRST-TIME-PARENT-GROUPS' , jtf_rs_dbi_denorm_res_groups_s.nextval
304: ,'N' , 'A' ,l_sysdate, l_user_id, 'Y'
305: , l_sysdate, l_user_id, usage)
306: SELECT /*+ use_hash(g x usg) parallel(g) parallel(x) parallel(usg)*/
307: x.resource_id, x.user_id, x.group_id

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

361: , d1.group_id id,
362: TO_NUMBER(-1111) current_id, d1.actual_parent_id parent_id,
363: d1.denorm_level , d1.start_date_active start_date,
364: d1.end_date_active end_date, n1.user_id ,n1.resource_id ,
365: '0-FIRST-TIME-CHILD-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval
366: ,'N' mem_flag , 'A' mem_status
367: ,l_sysdate, l_user_id
368: ,DECODE(d1.active_flag,'Y','Y','N')
369: ,l_sysdate, l_user_id, usg.usage

Line 411: jtf_rs_dbi_denorm_res_groups_s.nextval

407: , d1.group_id id, d2.group_id current_id,
408: d1.actual_parent_id parent_id, d1.denorm_level,
409: d1.start_date_active start_date, d1.end_date_active end_date,
410: n1.user_id, n1.resource_id, 'A-PARENT' debug_column,
411: jtf_rs_dbi_denorm_res_groups_s.nextval
412: ,'N' mem_flag , 'A' mem_status
413: ,l_sysdate, l_user_id
414: ,DECODE(d1.active_flag,'Y','Y','N')
415: ,l_sysdate, l_user_id, usg.usage

Line 461: jtf_rs_dbi_denorm_res_groups_s.nextval

457: , d1.group_id id, d1.group_id current_id,
458: d1.actual_parent_id parent_id, d1.denorm_level,
459: d1.start_date_active start_date, d1.end_date_active end_date,
460: n1.user_id, n1.resource_id, 'C-SELF' debug_column,
461: jtf_rs_dbi_denorm_res_groups_s.nextval
462: ,'N' mem_flag , 'A' mem_status
463: ,l_sysdate, l_user_id
464: ,DECODE(d1.active_flag,'Y','Y','N')
465: ,l_sysdate, l_user_id, usg.usage

Line 506: , jtf_rs_dbi_denorm_res_groups_s.nextval

502: ,d1.group_id id,
503: d1.actual_parent_id current_id, d1.actual_parent_id parent_id,
504: d1.denorm_level, d1.start_date_active start_date,
505: d1.end_date_active end_date, n1.user_id, n1.resource_id, 'D-CHILD' debug_column
506: , jtf_rs_dbi_denorm_res_groups_s.nextval
507: ,'N' mem_flag , 'A' mem_status
508: ,l_sysdate, l_user_id
509: ,DECODE(d1.active_flag,'Y','Y','N')
510: ,l_sysdate, l_user_id, usg.usage

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

551: usage )
552: SELECT Decode(x.mem_status,'I','----[ ','----')value,
553: x.resource_id||'.'||x.group_id id_for_grp_mem, x.group_id current_id,
554: x.group_id parent_id, to_number(100) denorm_level,
555: 'E-SELF-GROUP-MEMBERS' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id
556: ,x.resource_id grp_mem_resource_id, 'Y' mem_flag, x.mem_status
557: ,l_sysdate, l_user_id
558: ,'Y' active_grp_rel_only
559: ,l_sysdate, l_user_id, x.usage

Line 628: '1-GROUP-MEMBER-LOGIN' debug_column ,jtf_rs_dbi_denorm_res_groups_s.NEXTVAL,

624: active_grp_rel_only, last_update_date, last_updated_by, usage )
625: SELECT ' * ' VALUE, group_id id, resource_id||'.'||group_id id_for_grp_mem,
626: TO_NUMBER(-7777) current_id, group_id parent_id, TO_NUMBER(0) denorm_level,
627: START_DATE , end_date, resource_id, user_id, resource_id grp_mem_resource_id,
628: '1-GROUP-MEMBER-LOGIN' debug_column ,jtf_rs_dbi_denorm_res_groups_s.NEXTVAL,
629: 'N' mem_flag , 'A' mem_status ,l_sysdate, l_user_id, 'Y' active_grp_rel_only
630: ,l_sysdate, l_user_id, usage
631: FROM (
632: SELECT /*+ use_hash(gm rrl rol res usg) parallel(gm) parallel(rrl) parallel(rol) parallel(res) parallel(usg)*/