DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_QUAL_USGS_ALL

Line 4072: , jtf_qual_usgs_all jqu

4068: UPDATE jtf_terr_qtype_usgs_all qua
4069: SET qua.num_qual = (
4070: SELECT COUNT(*)
4071: FROM jtf_terr_qual_all jtq
4072: , jtf_qual_usgs_all jqu
4073: , jtf_qual_type_usgs jqtu
4074: , jtf_qual_type_denorm_v v
4075: WHERE jtq.qual_usg_id = jqu.qual_usg_id
4076: /* ACHANDA 03/08/2004 : Bug 3378530 : change the where clause to use index more selectively */

Line 4326: , jtf_qual_usgs_all jqu

4322: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4323: UPDATE jtf_terr_qtype_usgs_all qua
4324: SET qua.num_qual = ( SELECT count(*)
4325: FROM jtf_terr_qual_all jtq
4326: , jtf_qual_usgs_all jqu
4327: , jtf_qual_type_usgs jqtu
4328: , jtf_qual_type_denorm_v v
4329: WHERE jtq.qual_usg_id = jqu.qual_usg_id
4330: /* ACHANDA 02/03/2004 : Bug 3378530 : change the where clause to use index more selectively */