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 279: FROM hr_operating_units hr, jtf_terr_all jt

275:
276: /*Added for bug 7315889 */
277: CURSOR c_get_operating_unit(ci_terr_id VARCHAR2) IS
278: SELECT distinct hr.name operating_unit
279: FROM hr_operating_units hr, jtf_terr_all jt
280: WHERE hr.organization_id = jt.org_id
281: AND jt.terr_id = ci_terr_id;
282:
283: -- ADDED FOR BUG 7315889

Line 298: from jtf_terr_all j

294: if p_rpt_type = 'LOOKUP_TERR' and p_param5 IS NOT NULL then
295: open terr_name_cur for
296: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
297: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
298: from jtf_terr_all j
299: where j.terr_id = p_param5;
300:
301:
302: -- ADDED FOR BUG 7315889

Line 345: FROM jtf_terr_all jt

341: AND jtr.terr_id = j.terr_id
342: )
343: AND NOT EXISTS (
344: SELECT jt.terr_id
345: FROM jtf_terr_all jt
346: WHERE ( ( NVL(jt.end_date_active, lp_sysdate) <= NVL(p_param4, lp_sysdate) ) OR
347: ( NVL(jt.start_date_active, lp_sysdate) > NVL(p_param4, lp_sysdate) )
348: )
349: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 379: FROM jtf_terr_all jt

375: )
376: AND jtu.source_id = NVL(p_param3, jtu.source_id)
377: AND NOT EXISTS (
378: SELECT jt.terr_id
379: FROM jtf_terr_all jt
380: WHERE ( ( NVL(jt.end_date_active, lp_sysdate) <= NVL(p_param4, lp_sysdate) ) OR
381: ( NVL(jt.start_date_active, lp_sysdate) >= NVL(p_param4, lp_sysdate) )
382: )
383: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 845: FROM jtf_terr_all jt

841: ROUND((atc.ACTIVE_TERR_COUNT / decode(arc.ACTIVE_DIST_REP_COUNT, 0, 1, arc.ACTIVE_DIST_REP_COUNT)),2) TERR_PER_REP
842: FROM
843: -- Total # of Active Territories
844: ( SELECT COUNT(*) ACTIVE_TERR_COUNT
845: FROM jtf_terr_all jt
846: WHERE EXISTS ( SELECT jtdr.terr_id
847: FROM jtf_terr_denorm_rules_all jtdr
848: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
849: ) atc,

Line 853: FROM jtf_terr_all jt

849: ) atc,
850:
851: -- Total # of Territories that have Internal and External Reps
852: ( SELECT COUNT(*) TERR_DUAL_ASSGN_COUNT
853: FROM jtf_terr_all jt
854: WHERE EXISTS ( SELECT jtdr.terr_id
855: FROM jtf_terr_denorm_rules_all jtdr
856: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
857: AND EXISTS ( SELECT jtr.terr_id

Line 869: FROM jtf_terr_all jt

865: ) tdac,
866:
867: -- Territories created last 7 days
868: ( SELECT COUNT(*) TERR_CREATED_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: and jt.creation_date BETWEEN SYSDATE-7 AND SYSDATE+1

Line 878: FROM jtf_terr_all jt

874: ) tcc,
875:
876: -- Total # of (SOFT) DELETED Territories
877: ( SELECT COUNT(*) TERR_SOFT_DEL_COUNT
878: FROM jtf_terr_all jt
879: WHERE EXISTS ( SELECT jtdr.terr_id
880: FROM jtf_terr_denorm_rules_all jtdr
881: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
882: and jt.end_date_active BETWEEN SYSDATE-7 AND SYSDATE+1

Line 887: FROM jtf_terr_all jt

883: ) tsdc,
884:
885: -- Total # of UPDATED Territories
886: ( SELECT COUNT(*) TERR_UPDATED_COUNT
887: FROM jtf_terr_all jt
888: WHERE EXISTS ( SELECT jtdr.terr_id
889: FROM jtf_terr_denorm_rules_all jtdr
890: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
891: and jt.last_update_date BETWEEN SYSDATE-7 AND SYSDATE+1

Line 925: FROM jtf_terr_all jt, hr_organization_units hou

921: ( SELECT
922: hou.name,
923: hou.organization_id,
924: COUNT(*) ACTIVE_TERR_COUNT
925: FROM jtf_terr_all jt, hr_organization_units hou
926: WHERE jt.org_id = hou.organization_id
927: AND EXISTS ( SELECT jtdr.terr_id
928: FROM jtf_terr_denorm_rules_all jtdr
929: WHERE jtdr.terr_id = jt.terr_id and jtdr.source_id = p_param2)

Line 938: FROM jtf_terr_all jt, hr_organization_units hou

934: ( SELECT
935: hou.name,
936: hou.organization_id,
937: COUNT(*) TERR_DUAL_ASSGN_COUNT
938: FROM jtf_terr_all jt, hr_organization_units hou
939: WHERE jt.org_id = hou.organization_id
940: AND EXISTS ( SELECT jtdr.terr_id
941: FROM jtf_terr_denorm_rules_all jtdr
942: WHERE jtdr.terr_id = jt.terr_id and jtdr.source_id = p_param2)

Line 959: FROM jtf_terr_all jt, hr_organization_units hou

955: ( SELECT
956: hou.name,
957: hou.organization_id,
958: COUNT(*) TERR_CREATED_COUNT
959: FROM jtf_terr_all jt, hr_organization_units hou
960: WHERE jt.org_id = hou.organization_id
961: and EXISTS ( SELECT jtdr.terr_id
962: FROM jtf_terr_denorm_rules_all jtdr
963: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 973: FROM jtf_terr_all jt, hr_organization_units hou

969: ( SELECT
970: hou.name,
971: hou.organization_id,
972: COUNT(*) TERR_SOFT_DEL_COUNT
973: FROM jtf_terr_all jt, hr_organization_units hou
974: WHERE jt.org_id = hou.organization_id
975: and EXISTS ( SELECT jtdr.terr_id
976: FROM jtf_terr_denorm_rules_all jtdr
977: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 987: FROM jtf_terr_all jt, hr_organization_units hou

983: ( SELECT
984: hou.name,
985: hou.organization_id,
986: COUNT(*) TERR_UPDATED_COUNT
987: FROM jtf_terr_all jt, hr_organization_units hou
988: WHERE jt.org_id = hou.organization_id
989: and EXISTS ( SELECT jtdr.terr_id
990: FROM jtf_terr_denorm_rules_all jtdr
991: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )

Line 1022: FROM jtf_terr_all jt

1018:
1019: cursor c_NONACTIVE_GLOBAL IS
1020: SELECT 'All' name,
1021: COUNT(*) INACTIVE_TERR_COUNT
1022: FROM jtf_terr_all jt
1023: WHERE
1024: exists ( select jtua.terr_id
1025: from jtf_terr_usgs_all jtua
1026: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)

Line 1036: FROM jtf_terr_all jt, hr_organization_units hou

1032: SELECT
1033: hou.name name,
1034: COUNT(*) INACTIVE_TERR_COUNT,
1035: hou.organization_id org_id
1036: FROM jtf_terr_all jt, hr_organization_units hou
1037: WHERE jt.org_id = hou.organization_id
1038: and exists ( select jtua.terr_id
1039: from jtf_terr_usgs_all jtua
1040: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)