APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERR_RSC_ALL

Line 858: FROM jtf_terr_rsc_all jtr

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
858: FROM jtf_terr_rsc_all jtr
859: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
860: AND jtr.terr_id = jt.terr_id )
861: AND EXISTS ( SELECT jtr.terr_id
862: FROM jtf_terr_rsc_all jtr

Line 862: FROM jtf_terr_rsc_all jtr

858: FROM jtf_terr_rsc_all jtr
859: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
860: AND jtr.terr_id = jt.terr_id )
861: AND EXISTS ( SELECT jtr.terr_id
862: FROM jtf_terr_rsc_all jtr
863: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
864: AND jtr.terr_id = jt.terr_id )
865: ) tdac,
866:

Line 896: FROM jtf_terr_rsc_all jtr

892: ) tuc,
893:
894: -- Total Distinct # of People Assigned to Active Territories -- 2930
895: ( SELECT COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
896: FROM jtf_terr_rsc_all jtr
897: WHERE EXISTS ( SELECT jtdr.terr_id
898: FROM jtf_terr_denorm_rules_all jtdr
899: WHERE jtdr.resource_exists_flag = 'Y'
900: AND jtdr.terr_id = jtr.terr_id and jtdr.source_id = p_param2)

Line 944: FROM jtf_terr_rsc_all jtr

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)
943: AND EXISTS ( SELECT jtr.terr_id
944: FROM jtf_terr_rsc_all jtr
945: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
946: AND jtr.terr_id = jt.terr_id )
947: AND EXISTS ( SELECT jtr.terr_id
948: FROM jtf_terr_rsc_all jtr

Line 948: FROM jtf_terr_rsc_all jtr

944: FROM jtf_terr_rsc_all jtr
945: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
946: AND jtr.terr_id = jt.terr_id )
947: AND EXISTS ( SELECT jtr.terr_id
948: FROM jtf_terr_rsc_all jtr
949: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
950: AND jtr.terr_id = jt.terr_id )
951: GROUP BY hou.name, hou.organization_id
952: ) tdac,

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'