APPS.JTF_TERR_JSP_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 943: hr_organization_units houo,

939: , ROUND((atc.ACTIVE_TERR_COUNT / arc.ACTIVE_DIST_REP_COUNT), 2)
940: ) TERR_PER_REP
941:
942: FROM
943: hr_organization_units houo,
944: -- Total # of Active Territories -- 13918
945: ( SELECT
946: hou.name,
947: hou.organization_id,

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 1025: FROM jtf_terr_rsc_all jtr, hr_organization_units hou

1021: ( SELECT
1022: hou.name,
1023: hou.organization_id,
1024: COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
1025: FROM jtf_terr_rsc_all jtr, hr_organization_units hou
1026: WHERE jtr.org_id = hou.organization_id
1027: AND EXISTS ( SELECT jtdr.terr_id
1028: FROM jtf_terr_denorm_rules_all jtdr
1029: WHERE jtdr.resource_exists_flag = 'Y'

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)