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_TERR_JSP_REPORTS dependencies on DUAL

Line 338: from dual;

334: /* ARPATEL: 10/16, bug#2832442 */
335: --parse the resource_id to extract the resource_type
336: select SUBSTR(p_param1, 1,INSTR(p_param1, 'R')-1)
337: into l_resource_id
338: from dual;
339:
340: select SUBSTR(p_param1, INSTR(p_param1, 'R'))
341: into l_resource_type
342: from dual;

Line 342: from dual;

338: from dual;
339:
340: select SUBSTR(p_param1, INSTR(p_param1, 'R'))
341: into l_resource_type
342: from dual;
343:
344: /* ARPATEL: 10/16, END OF bug#2832442 */
345:
346: --dbms_output.put_line('get territory by property');

Line 572: select 1 into l_match_qual from dual

568: then
569: if rec_qual_value.COMPARISON_OPERATOR = 'BETWEEN'
570: then
571: begin
572: select 1 into l_match_qual from dual
573: where UPPER(p_param3) BETWEEN lx_result_tbl(l_out_index).column9 and lx_result_tbl(l_out_index).column10;
574:
575: exception
576: when no_data_found then l_match_qual := 0;

Line 584: select 1 into l_match_qual from dual

580:
581: if rec_qual_value.COMPARISON_OPERATOR = '='
582: then
583: begin
584: select 1 into l_match_qual from dual
585: where UPPER(p_param3) = lx_result_tbl(l_out_index).column9;
586:
587: exception
588: when no_data_found then l_match_qual := 0;

Line 596: select 1 into l_match_qual from dual

592:
593: if rec_qual_value.COMPARISON_OPERATOR = 'LIKE'
594: then
595: begin
596: select 1 into l_match_qual from dual
597: where UPPER(p_param3) LIKE lx_result_tbl(l_out_index).column9;
598:
599: exception
600: when no_data_found then l_match_qual := 0;

Line 625: select 1 into l_match_qual from dual

621:
622: if rec_qual_value.COMPARISON_OPERATOR = 'BETWEEN'
623: then
624: begin
625: select 1 into l_match_qual from dual
626: where UPPER(p_param4) BETWEEN lx_result_tbl(l_out_index).column9 and lx_result_tbl(l_out_index).column10;
627:
628: exception
629: when no_data_found then l_match_qual := 0;

Line 637: select 1 into l_match_qual from dual

633:
634: if rec_qual_value.COMPARISON_OPERATOR = '='
635: then
636: begin
637: select 1 into l_match_qual from dual
638: where UPPER(p_param4) = lx_result_tbl(l_out_index).column9;
639:
640: exception
641: when no_data_found then l_match_qual := 0;

Line 649: select 1 into l_match_qual from dual

645:
646: if rec_qual_value.COMPARISON_OPERATOR = 'LIKE'
647: then
648: begin
649: select 1 into l_match_qual from dual
650: where UPPER(p_param4) LIKE lx_result_tbl(l_out_index).column9;
651:
652: exception
653: when no_data_found then l_match_qual := 0;

Line 860: tdac.TERR_DUAL_ASSGN_COUNT TERR_DUAL_ASSGN_COUNT,

856: --ACTIVE GLOBAL CURSOR
857: cursor c_ACTIVE_GLOBAL IS
858: SELECT 'All' name,
859: atc.ACTIVE_TERR_COUNT ACTIVE_TERR_COUNT,
860: tdac.TERR_DUAL_ASSGN_COUNT TERR_DUAL_ASSGN_COUNT,
861: tcc.TERR_CREATED_COUNT TERR_CREATED_COUNT,
862: tsdc.TERR_SOFT_DEL_COUNT TERR_SOFT_DEL_COUNT,
863: tuc.TERR_UPDATED_COUNT TERR_UPDATED_COUNT,
864: arc.ACTIVE_DIST_REP_COUNT ACTIVE_DIST_REP_COUNT,

Line 876: ( SELECT COUNT(*) TERR_DUAL_ASSGN_COUNT

872: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
873: ) atc,
874:
875: -- Total # of Territories that have Internal and External Reps
876: ( SELECT COUNT(*) TERR_DUAL_ASSGN_COUNT
877: FROM jtf_terr_all jt
878: WHERE EXISTS ( SELECT jtdr.terr_id
879: FROM jtf_terr_denorm_rules_all jtdr
880: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 932: NVL(tdac.TERR_DUAL_ASSGN_COUNT, 0) TERR_DUAL_ASSGN_COUNT,

928: cursor c_ACTIVE_BY_COUNTRY IS
929: SELECT
930: houo.name name,
931: NVL(atc.ACTIVE_TERR_COUNT, 0) ACTIVE_TERR_COUNT,
932: NVL(tdac.TERR_DUAL_ASSGN_COUNT, 0) TERR_DUAL_ASSGN_COUNT,
933: NVL(tcc.TERR_CREATED_COUNT, 0) TERR_CREATED_COUNT,
934: NVL(tsdc.TERR_SOFT_DEL_COUNT, 0) TERR_SOFT_DEL_COUNT,
935: NVL(tuc.TERR_UPDATED_COUNT, 0) TERR_UPDATED_COUNT,
936: NVL(arc.ACTIVE_DIST_REP_COUNT, 0) ACTIVE_DIST_REP_COUNT,

Line 961: COUNT(*) TERR_DUAL_ASSGN_COUNT

957: -- Total # of Territories that have Internal and External Reps
958: ( SELECT
959: hou.name,
960: hou.organization_id,
961: COUNT(*) TERR_DUAL_ASSGN_COUNT
962: FROM jtf_terr_all jt, hr_organization_units hou
963: WHERE jt.org_id = hou.organization_id
964: AND EXISTS ( SELECT jtdr.terr_id
965: FROM jtf_terr_denorm_rules_all jtdr

Line 1087: lx_result_tbl(l_out_index).column3 := actglobal_type.TERR_DUAL_ASSGN_COUNT;

1083: l_out_index := l_out_index + 1;
1084: lx_result_tbl.extend;
1085: lx_result_tbl(l_out_index).column1 := actglobal_type.name;
1086: lx_result_tbl(l_out_index).column2 := actglobal_type.ACTIVE_TERR_COUNT;
1087: lx_result_tbl(l_out_index).column3 := actglobal_type.TERR_DUAL_ASSGN_COUNT;
1088: lx_result_tbl(l_out_index).column4 := actglobal_type.TERR_CREATED_COUNT;
1089: lx_result_tbl(l_out_index).column5 := actglobal_type.TERR_SOFT_DEL_COUNT;
1090: lx_result_tbl(l_out_index).column6 := actglobal_type.TERR_UPDATED_COUNT;
1091: lx_result_tbl(l_out_index).column7 := actglobal_type.ACTIVE_DIST_REP_COUNT;

Line 1104: lx_result_tbl(l_out_index).column3 := actcountry_type.TERR_DUAL_ASSGN_COUNT;

1100: l_out_index := l_out_index + 1;
1101: lx_result_tbl.extend;
1102: lx_result_tbl(l_out_index).column1 := actcountry_type.name;
1103: lx_result_tbl(l_out_index).column2 := actcountry_type.ACTIVE_TERR_COUNT;
1104: lx_result_tbl(l_out_index).column3 := actcountry_type.TERR_DUAL_ASSGN_COUNT;
1105: lx_result_tbl(l_out_index).column4 := actcountry_type.TERR_CREATED_COUNT;
1106: lx_result_tbl(l_out_index).column5 := actcountry_type.TERR_SOFT_DEL_COUNT;
1107: lx_result_tbl(l_out_index).column6 := actcountry_type.TERR_UPDATED_COUNT;
1108: lx_result_tbl(l_out_index).column7 := actcountry_type.ACTIVE_DIST_REP_COUNT;