APPS.JTF_TERR_JSP_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 919: hr_organization_units houo,

915: , ROUND((atc.ACTIVE_TERR_COUNT / arc.ACTIVE_DIST_REP_COUNT), 2)
916: ) TERR_PER_REP
917:
918: FROM
919: hr_organization_units houo,
920: -- Total # of Active Territories -- 13918
921: ( SELECT
922: hou.name,
923: hou.organization_id,

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

997: ( SELECT
998: hou.name,
999: hou.organization_id,
1000: COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
1001: FROM jtf_terr_rsc_all jtr, hr_organization_units hou
1002: WHERE jtr.org_id = hou.organization_id
1003: AND EXISTS ( SELECT jtdr.terr_id
1004: FROM jtf_terr_denorm_rules_all jtdr
1005: WHERE jtdr.resource_exists_flag = 'Y'

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)