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.SR_UWQ_INTEG dependencies on CS_SR_UWQ_NODES_B

Line 430: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

426: l_res_cat_enum_flag varchar2(1);
427:
428: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
429: data_source
430: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
431: where uwq_b.node_id = uwq_tl.node_id
432: and uwq_tl.language = userenv('LANG')
433: and parent_id = l_node_id
434: and node_query='CURSOR' and enabled_flag='Y';

Line 439: from cs_sr_uwq_nodes_b uwq_b

435:
436: cursor node_cursor is select 'Node ',
437: node_view,where_clause,data_source,level,node_query,cursor_sql,
438: uwq_b.node_id,res_cat_enum_flag
439: from cs_sr_uwq_nodes_b uwq_b
440: where node_id > 9999 and node_query='SINGLE' and enabled_flag='Y'
441: and ( parent_id is null or parent_id > 9999 )
442: start with uwq_b.parent_id is null
443: connect by prior uwq_b.node_id = uwq_b.parent_id;

Line 448: from cs_sr_uwq_nodes_b uwq_b

444:
445: cursor seed_cursor is select 'Node',
446: node_view,where_clause,data_source,node_query,cursor_sql,
447: uwq_b.node_id,res_cat_enum_flag,level,nvl(parent_id,-1)
448: from cs_sr_uwq_nodes_b uwq_b
449: where enabled_flag='Y'
450: --where node_id < 1000 and enabled_flag='Y'
451: and node_query = 'SINGLE'
452: start with uwq_b.parent_id is null

Line 527: select where_clause into l_parent_where_clause from cs_sr_uwq_nodes_b

523: -- condition of the parent.
524:
525: begin
526: l_parent_where_clause := null;
527: select where_clause into l_parent_where_clause from cs_sr_uwq_nodes_b
528: where node_id=l_parent_id ;
529: exception
530: when NO_DATA_FOUND then
531: l_parent_where_clause :=' incident_id = -1 ';

Line 562: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

558: select node_label,node_view,cursor_key_col,data_source,
559: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
560: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
561: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
562: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
563: where uwq_b.node_id = uwq_tl.node_id
564: and uwq_tl.language = userenv('LANG')
565: and parent_id = l_node_id and enabled_flag='Y'
566: and node_query = 'CURSOR' ;

Line 705: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all

701: end if; -- End of if at cursor_sql is not null
702: end loop; -- End of loop for cur_seed_cursor
703:
704: --- Start of personalized single,cursor nodes.
705: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all
706: -- personalized nodes.
707:
708: open node_cursor;
709: loop

Line 754: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

750: , res_cat_enum_flag
751: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
752: l_node_query,l_cursor_sql,l_node_id
753: , l_res_cat_enum_flag
754: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
755: where uwq_b.node_id = uwq_tl.node_id
756: and uwq_tl.language = userenv('LANG')
757: and parent_id = l_node_id and enabled_flag='Y'
758: and node_query = 'CURSOR' ;

Line 989: insert into cs_sr_uwq_nodes_b

985: else
986: l_node_id := p_node_id;
987: end if;
988:
989: insert into cs_sr_uwq_nodes_b
990: (node_id,
991: node_view,
992: data_source,
993: media_type_id,

Line 1090: from cs_sr_uwq_nodes_b where node_id = p_node_id;

1086: begin
1087: l_object_version_number := p_object_version_number;
1088:
1089: select object_version_number into l_object_version_number
1090: from cs_sr_uwq_nodes_b where node_id = p_node_id;
1091:
1092: if l_object_version_number = p_object_version_number then
1093:
1094: update cs_sr_uwq_nodes_b set

Line 1094: update cs_sr_uwq_nodes_b set

1090: from cs_sr_uwq_nodes_b where node_id = p_node_id;
1091:
1092: if l_object_version_number = p_object_version_number then
1093:
1094: update cs_sr_uwq_nodes_b set
1095: node_view = p_node_view,
1096: data_source = p_data_source,
1097: media_type_id = p_media_type_id,
1098: where_clause = p_where_clause,

Line 1948: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

1944: l_res_cat_enum_flag varchar2(1);
1945:
1946: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
1947: data_source
1948: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
1949: where uwq_b.node_id = uwq_tl.node_id
1950: and uwq_tl.language = userenv('LANG')
1951: and parent_id = l_node_id
1952: and node_query='CURSOR' and enabled_flag='Y';

Line 1957: from cs_sr_uwq_nodes_b uwq_b

1953:
1954: cursor node_cursor is select 'Node ',
1955: node_view,where_clause,data_source,level,node_query,cursor_sql,
1956: uwq_b.node_id,res_cat_enum_flag
1957: from cs_sr_uwq_nodes_b uwq_b
1958: where node_id > 9999 and node_query='SINGLE' and enabled_flag='Y'
1959: and ( parent_id is null or parent_id > 9999 )
1960: start with uwq_b.parent_id is null
1961: connect by prior uwq_b.node_id = uwq_b.parent_id;

Line 1966: from cs_sr_uwq_nodes_b uwq_b

1962:
1963: cursor seed_cursor is select 'Node',
1964: node_view,where_clause,data_source,node_query,cursor_sql,
1965: uwq_b.node_id,res_cat_enum_flag,level,nvl(parent_id,-1)
1966: from cs_sr_uwq_nodes_b uwq_b
1967: where enabled_flag='Y'
1968: --where node_id < 1000 and enabled_flag='Y'
1969: and node_query = 'SINGLE'
1970: start with uwq_b.parent_id is null

Line 2047: cs_sr_uwq_nodes_b

2043:
2044: begin
2045: l_parent_where_clause := null;
2046: select where_clause into l_parent_where_clause from
2047: cs_sr_uwq_nodes_b
2048: where node_id=l_parent_id ;
2049: exception
2050: when NO_DATA_FOUND then
2051: l_parent_where_clause :=' incident_id = -1 ';

Line 2096: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2092: select node_label,node_view,cursor_key_col,data_source,
2093: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
2094: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2095: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
2096: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2097: where uwq_b.node_id = uwq_tl.node_id
2098: and uwq_tl.language = userenv('LANG')
2099: and parent_id = l_node_id and enabled_flag='Y'
2100: and node_query = 'CURSOR' ;

Line 2271: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all

2267: end if; -- End of if at cursor_sql is not null
2268: end loop; -- End of loop for cur_seed_cursor
2269:
2270: --- Start of personalized single,cursor nodes.
2271: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all
2272: -- personalized nodes.
2273:
2274: open node_cursor;
2275: loop

Line 2330: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2326: , res_cat_enum_flag
2327: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2328: l_node_query,l_cursor_sql,l_node_id
2329: , l_res_cat_enum_flag
2330: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2331: where uwq_b.node_id = uwq_tl.node_id
2332: and uwq_tl.language = userenv('LANG')
2333: and parent_id = l_node_id and enabled_flag='Y'
2334: and node_query = 'CURSOR' ;

Line 2473: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2469: l_res_cat_enum_flag varchar2(1);
2470:
2471: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
2472: data_source
2473: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2474: where uwq_b.node_id = uwq_tl.node_id
2475: and uwq_tl.language = userenv('LANG')
2476: and parent_id = l_node_id
2477: and node_query='CURSOR' and enabled_flag='Y';

Line 2482: from cs_sr_uwq_nodes_b uwq_b

2478:
2479: cursor node_cursor is select 'Node ',
2480: node_view,where_clause,data_source,level,node_query,cursor_sql,
2481: uwq_b.node_id,res_cat_enum_flag
2482: from cs_sr_uwq_nodes_b uwq_b
2483: where node_id > 9999 and node_query='SINGLE' and enabled_flag='Y'
2484: and ( parent_id is null or parent_id > 9999 )
2485: start with uwq_b.parent_id is null
2486: connect by prior uwq_b.node_id = uwq_b.parent_id;

Line 2491: from cs_sr_uwq_nodes_b uwq_b

2487:
2488: cursor seed_cursor is select 'Node',
2489: node_view,where_clause,data_source,node_query,cursor_sql,
2490: uwq_b.node_id,res_cat_enum_flag,level,nvl(parent_id,-1)
2491: from cs_sr_uwq_nodes_b uwq_b
2492: where enabled_flag='Y'
2493: --where node_id < 1000 and enabled_flag='Y'
2494: and node_query = 'SINGLE'
2495: start with uwq_b.parent_id is null

Line 2571: cs_sr_uwq_nodes_b

2567:
2568: begin
2569: l_parent_where_clause := null;
2570: select where_clause into l_parent_where_clause from
2571: cs_sr_uwq_nodes_b
2572: where node_id=l_parent_id ;
2573: exception
2574: when NO_DATA_FOUND then
2575: l_parent_where_clause :=' incident_id = -1 ';

Line 2617: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2613: select node_label,node_view,cursor_key_col,data_source,
2614: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
2615: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2616: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
2617: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2618: where uwq_b.node_id = uwq_tl.node_id
2619: and uwq_tl.language = userenv('LANG')
2620: and parent_id = l_node_id and enabled_flag='Y'
2621: and node_query = 'CURSOR' ;

Line 2794: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all

2790: end if; -- End of if at cursor_sql is not null
2791: end loop; -- End of loop for cur_seed_cursor
2792:
2793: --- Start of personalized single,cursor nodes.
2794: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all
2795: -- personalized nodes.
2796:
2797: open node_cursor;
2798: loop

Line 2854: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2850: , res_cat_enum_flag
2851: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
2852: l_node_query,l_cursor_sql,l_node_id
2853: , l_res_cat_enum_flag
2854: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2855: where uwq_b.node_id = uwq_tl.node_id
2856: and uwq_tl.language = userenv('LANG')
2857: and parent_id = l_node_id and enabled_flag='Y'
2858: and node_query = 'CURSOR' ;

Line 2998: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

2994: l_res_cat_enum_flag varchar2(1);
2995:
2996: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
2997: data_source
2998: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
2999: where uwq_b.node_id = uwq_tl.node_id
3000: and uwq_tl.language = userenv('LANG')
3001: and parent_id = l_node_id
3002: and node_query='CURSOR' and enabled_flag='Y';

Line 3007: from cs_sr_uwq_nodes_b uwq_b

3003:
3004: cursor node_cursor is select 'Node ',
3005: node_view,where_clause,data_source,level,node_query,cursor_sql,
3006: uwq_b.node_id,res_cat_enum_flag
3007: from cs_sr_uwq_nodes_b uwq_b
3008: where node_id > 9999 and node_query='SINGLE' and enabled_flag='Y'
3009: and ( parent_id is null or parent_id > 9999 )
3010: start with uwq_b.parent_id is null
3011: connect by prior uwq_b.node_id = uwq_b.parent_id;

Line 3016: from cs_sr_uwq_nodes_b uwq_b

3012:
3013: cursor seed_cursor is select 'Node',
3014: node_view,where_clause,data_source,node_query,cursor_sql,
3015: uwq_b.node_id,res_cat_enum_flag,level,nvl(parent_id,-1)
3016: from cs_sr_uwq_nodes_b uwq_b
3017: where enabled_flag='Y'
3018: --where node_id < 1000 and enabled_flag='Y'
3019: and node_query = 'SINGLE'
3020: start with uwq_b.parent_id is null

Line 3097: cs_sr_uwq_nodes_b

3093:
3094: begin
3095: l_parent_where_clause := null;
3096: select where_clause into l_parent_where_clause from
3097: cs_sr_uwq_nodes_b
3098: where node_id=l_parent_id ;
3099: exception
3100: when NO_DATA_FOUND then
3101: l_parent_where_clause :=' incident_id = -1 ';

Line 3145: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

3141: select node_label,node_view,cursor_key_col,data_source,
3142: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
3143: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
3144: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
3145: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
3146: where uwq_b.node_id = uwq_tl.node_id
3147: and uwq_tl.language = userenv('LANG')
3148: and parent_id = l_node_id and enabled_flag='Y'
3149: and node_query = 'CURSOR' ;

Line 3320: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all

3316: end if; -- End of if at cursor_sql is not null
3317: end loop; -- End of loop for cur_seed_cursor
3318:
3319: --- Start of personalized single,cursor nodes.
3320: -- This section of code queries the table cs_sr_uwq_nodes_b / tl for all
3321: -- personalized nodes.
3322:
3323: open node_cursor;
3324: loop

Line 3379: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

3375: , res_cat_enum_flag
3376: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
3377: l_node_query,l_cursor_sql,l_node_id
3378: , l_res_cat_enum_flag
3379: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
3380: where uwq_b.node_id = uwq_tl.node_id
3381: and uwq_tl.language = userenv('LANG')
3382: and parent_id = l_node_id and enabled_flag='Y'
3383: and node_query = 'CURSOR' ;