APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERR_RSC_ALL

Line 882: FROM jtf_terr_rsc_all jtr

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
882: FROM jtf_terr_rsc_all jtr
883: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
884: AND jtr.terr_id = jt.terr_id )
885: AND EXISTS ( SELECT jtr.terr_id
886: FROM jtf_terr_rsc_all jtr

Line 886: FROM jtf_terr_rsc_all jtr

882: FROM jtf_terr_rsc_all jtr
883: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
884: AND jtr.terr_id = jt.terr_id )
885: AND EXISTS ( SELECT jtr.terr_id
886: FROM jtf_terr_rsc_all jtr
887: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
888: AND jtr.terr_id = jt.terr_id )
889: ) tdac,
890:

Line 920: FROM jtf_terr_rsc_all jtr

916: ) tuc,
917:
918: -- Total Distinct # of People Assigned to Active Territories -- 2930
919: ( SELECT COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
920: FROM jtf_terr_rsc_all jtr
921: WHERE EXISTS ( SELECT jtdr.terr_id
922: FROM jtf_terr_denorm_rules_all jtdr
923: WHERE jtdr.resource_exists_flag = 'Y'
924: AND jtdr.terr_id = jtr.terr_id and jtdr.source_id = p_param2)

Line 968: FROM jtf_terr_rsc_all jtr

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)
967: AND EXISTS ( SELECT jtr.terr_id
968: FROM jtf_terr_rsc_all jtr
969: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
970: AND jtr.terr_id = jt.terr_id )
971: AND EXISTS ( SELECT jtr.terr_id
972: FROM jtf_terr_rsc_all jtr

Line 972: FROM jtf_terr_rsc_all jtr

968: FROM jtf_terr_rsc_all jtr
969: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
970: AND jtr.terr_id = jt.terr_id )
971: AND EXISTS ( SELECT jtr.terr_id
972: FROM jtf_terr_rsc_all jtr
973: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
974: AND jtr.terr_id = jt.terr_id )
975: GROUP BY hou.name, hou.organization_id
976: ) tdac,

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'