DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_QUAL_TYPE_DENORM_V

Line 4074: , jtf_qual_type_denorm_v v

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 */
4077: AND jqu.org_id = -3113
4078: /*

Line 4328: , jtf_qual_type_denorm_v v

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 */
4331: AND jqu.org_id = -3113
4332: /*