DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_USGS_ALL

Line 1436: , jtf_terr_usgs_all jtu

1432:
1433: SELECT COUNT(*)
1434: INTO num_of_terr
1435: FROM jtf_terr_qtype_usgs_all jtqu
1436: , jtf_terr_usgs_all jtu
1437: , jtf_terr_all jt1
1438: , jtf_qual_type_usgs jqtu
1439: WHERE jtqu.terr_id = jt1.terr_id
1440: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

Line 1475: , jtf_terr_usgs_all jtu

1471:
1472: SELECT COUNT(*)
1473: INTO num_of_terr
1474: FROM jtf_terr_qtype_usgs_all jtqu
1475: , jtf_terr_usgs_all jtu
1476: , jtf_terr_all jt1
1477: , jtf_qual_type_usgs jqtu
1478: WHERE jtqu.terr_id = jt1.terr_id
1479: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id