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 JTF_TERR_ALL

Line 303: FROM hr_operating_units hr, jtf_terr_all jt

299:
300: /*Added for bug 7315889 */
301: CURSOR c_get_operating_unit(ci_terr_id VARCHAR2) IS
302: SELECT distinct hr.name operating_unit
303: FROM hr_operating_units hr, jtf_terr_all jt
304: WHERE hr.organization_id = jt.org_id
305: AND jt.terr_id = ci_terr_id;
306:
307: -- ADDED FOR BUG 7315889

Line 322: from jtf_terr_all j

318: if p_rpt_type = 'LOOKUP_TERR' and p_param5 IS NOT NULL then
319: open terr_name_cur for
320: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
321: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
322: from jtf_terr_all j
323: where j.terr_id = p_param5;
324:
325:
326: -- ADDED FOR BUG 7315889

Line 369: FROM jtf_terr_all jt

365: AND jtr.terr_id = j.terr_id
366: )
367: AND NOT EXISTS (
368: SELECT jt.terr_id
369: FROM jtf_terr_all jt
370: WHERE ( ( NVL(jt.end_date_active, lp_sysdate) <= NVL(p_param4, lp_sysdate) ) OR
371: ( NVL(jt.start_date_active, lp_sysdate) > NVL(p_param4, lp_sysdate) )
372: )
373: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 403: FROM jtf_terr_all jt

399: )
400: AND jtu.source_id = NVL(p_param3, jtu.source_id)
401: AND NOT EXISTS (
402: SELECT jt.terr_id
403: FROM jtf_terr_all jt
404: WHERE ( ( NVL(jt.end_date_active, lp_sysdate) <= NVL(p_param4, lp_sysdate) ) OR
405: ( NVL(jt.start_date_active, lp_sysdate) >= NVL(p_param4, lp_sysdate) )
406: )
407: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 869: FROM jtf_terr_all jt

865: ROUND((atc.ACTIVE_TERR_COUNT / decode(arc.ACTIVE_DIST_REP_COUNT, 0, 1, arc.ACTIVE_DIST_REP_COUNT)),2) TERR_PER_REP
866: FROM
867: -- Total # of Active Territories
868: ( SELECT COUNT(*) ACTIVE_TERR_COUNT
869: FROM jtf_terr_all jt
870: WHERE EXISTS ( SELECT jtdr.terr_id
871: FROM jtf_terr_denorm_rules_all jtdr
872: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
873: ) atc,

Line 877: FROM jtf_terr_all jt

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 )
881: AND EXISTS ( SELECT jtr.terr_id

Line 893: FROM jtf_terr_all jt

889: ) tdac,
890:
891: -- Territories created last 7 days
892: ( SELECT COUNT(*) TERR_CREATED_COUNT
893: FROM jtf_terr_all jt
894: WHERE EXISTS ( SELECT jtdr.terr_id
895: FROM jtf_terr_denorm_rules_all jtdr
896: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
897: and jt.creation_date BETWEEN SYSDATE-7 AND SYSDATE+1

Line 902: FROM jtf_terr_all jt

898: ) tcc,
899:
900: -- Total # of (SOFT) DELETED Territories
901: ( SELECT COUNT(*) TERR_SOFT_DEL_COUNT
902: FROM jtf_terr_all jt
903: WHERE EXISTS ( SELECT jtdr.terr_id
904: FROM jtf_terr_denorm_rules_all jtdr
905: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
906: and jt.end_date_active BETWEEN SYSDATE-7 AND SYSDATE+1

Line 911: FROM jtf_terr_all jt

907: ) tsdc,
908:
909: -- Total # of UPDATED Territories
910: ( SELECT COUNT(*) TERR_UPDATED_COUNT
911: FROM jtf_terr_all jt
912: WHERE EXISTS ( SELECT jtdr.terr_id
913: FROM jtf_terr_denorm_rules_all jtdr
914: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
915: and jt.last_update_date BETWEEN SYSDATE-7 AND SYSDATE+1

Line 949: FROM jtf_terr_all jt, hr_organization_units hou

945: ( SELECT
946: hou.name,
947: hou.organization_id,
948: COUNT(*) ACTIVE_TERR_COUNT
949: FROM jtf_terr_all jt, hr_organization_units hou
950: WHERE jt.org_id = hou.organization_id
951: AND EXISTS ( SELECT jtdr.terr_id
952: FROM jtf_terr_denorm_rules_all jtdr
953: WHERE jtdr.terr_id = jt.terr_id and jtdr.source_id = p_param2)

Line 962: FROM jtf_terr_all jt, hr_organization_units hou

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
966: WHERE jtdr.terr_id = jt.terr_id and jtdr.source_id = p_param2)

Line 983: FROM jtf_terr_all jt, hr_organization_units hou

979: ( SELECT
980: hou.name,
981: hou.organization_id,
982: COUNT(*) TERR_CREATED_COUNT
983: FROM jtf_terr_all jt, hr_organization_units hou
984: WHERE jt.org_id = hou.organization_id
985: and EXISTS ( SELECT jtdr.terr_id
986: FROM jtf_terr_denorm_rules_all jtdr
987: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 997: FROM jtf_terr_all jt, hr_organization_units hou

993: ( SELECT
994: hou.name,
995: hou.organization_id,
996: COUNT(*) TERR_SOFT_DEL_COUNT
997: FROM jtf_terr_all jt, hr_organization_units hou
998: WHERE jt.org_id = hou.organization_id
999: and EXISTS ( SELECT jtdr.terr_id
1000: FROM jtf_terr_denorm_rules_all jtdr
1001: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 1011: FROM jtf_terr_all jt, hr_organization_units hou

1007: ( SELECT
1008: hou.name,
1009: hou.organization_id,
1010: COUNT(*) TERR_UPDATED_COUNT
1011: FROM jtf_terr_all jt, hr_organization_units hou
1012: WHERE jt.org_id = hou.organization_id
1013: and EXISTS ( SELECT jtdr.terr_id
1014: FROM jtf_terr_denorm_rules_all jtdr
1015: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 1046: FROM jtf_terr_all jt

1042:
1043: cursor c_NONACTIVE_GLOBAL IS
1044: SELECT 'All' name,
1045: COUNT(*) INACTIVE_TERR_COUNT
1046: FROM jtf_terr_all jt
1047: WHERE
1048: exists ( select jtua.terr_id
1049: from jtf_terr_usgs_all jtua
1050: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)

Line 1060: FROM jtf_terr_all jt, hr_organization_units hou

1056: SELECT
1057: hou.name name,
1058: COUNT(*) INACTIVE_TERR_COUNT,
1059: hou.organization_id org_id
1060: FROM jtf_terr_all jt, hr_organization_units hou
1061: WHERE jt.org_id = hou.organization_id
1062: and exists ( select jtua.terr_id
1063: from jtf_terr_usgs_all jtua
1064: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)