APPS.AMV_MATCH_PVT dependencies on JTF_TERR_SRCH_ADV_GEN_V

Line 2561: ,jtf_terr_srch_adv_gen_v TERR

2557: SELECT DISTINCT
2558: RSC.terr_id
2559: ,TERR.name
2560: FROM jtf_terr_rsc_all RSC
2561: ,jtf_terr_srch_adv_gen_v TERR
2562: WHERE RSC.terr_id = TERR.terr_id
2563: AND RSC.resource_id = p_resource_id
2564: AND RSC.resource_type = p_resource_type;
2565: --