eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERRITORY_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 2266: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu

2262:
2263: UPDATE jtf_terr_ALL jt
2264: SET jt.num_qual = (
2265: SELECT COUNT(jtq.qual_usg_id)
2266: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu
2267: WHERE jtq.terr_id = jt.terr_id
2268: AND jtq.qual_usg_id = jqu.qual_usg_id
2269: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
2270: AND jqtu.qual_type_id = p_qual_type_id

Line 5214: jtf_qual_type_usgs_ALL jqtu,

5210: IF p_Terr_Id is not NULL Then
5211: SELECT 'x'
5212: into l_Temp
5213: from jtf_qual_usgs_ALL jqu,
5214: jtf_qual_type_usgs_ALL jqtu,
5215: jtf_terr_qtype_usgs_ALL jtqu
5216: where jtqu.terr_id = p_Terr_Id and
5217: jqtu.qual_type_usg_id = jtqu.qual_type_usg_id and
5218: jqu.qual_usg_id = P_Terr_Qual_Rec.Qual_Usg_Id and

Line 5853: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu

5849: l_qual_Type_Usg_id := p_Terr_QualTypeUsgs_Rec.QUAL_TYPE_USG_ID;
5850: --Check the qual_type_usg_id specified is valid
5851: Select 1
5852: into l_dummy
5853: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu
5854: where jtu.terr_id = p_Terr_Id and
5855: jqtu.source_id = jtu.source_id and
5856: jqtu.qual_type_usg_id = l_qual_Type_Usg_id;
5857: