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_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 5213: from jtf_qual_usgs_ALL jqu,

5209: BEGIN
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

Line 6011: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq

6007: AS
6008: Cursor C_QualDef1 IS
6009: -- Get the qualifier usage related information
6010: select jqu.qual_col1_datatype, jqu.display_type, jqu.convert_to_id_flag
6011: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq
6012: where jqu.qual_usg_id = jtq.qual_Usg_Id and
6013: jqu.org_id = jtq.org_id AND
6014: jtq.terr_qual_id = p_Terr_Qual_Id;
6015: