APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_QUAL_ALL

Line 260: FROM jtf_terr_qual_all jtq, jtf_terr_all jt

256: --DELETE territory value records
257: DELETE FROM jtf_terr_values_all jtv
258: WHERE jtv.terr_qual_id IN
259: ( SELECT jtq.terr_qual_id
260: FROM jtf_terr_qual_all jtq, jtf_terr_all jt
261: WHERE jtq.terr_id = jt.terr_id
262: AND jt.terr_group_flag = 'Y' );
263:
264: --Delete Territory Qualifer records

Line 265: DELETE from JTF_TERR_QUAL_ALL jtq

261: WHERE jtq.terr_id = jt.terr_id
262: AND jt.terr_group_flag = 'Y' );
263:
264: --Delete Territory Qualifer records
265: DELETE from JTF_TERR_QUAL_ALL jtq
266: WHERE jtq.terr_id IN
267: ( SELECT jt.terr_id
268: FROM jtf_terr_all jt
269: WHERE jt.terr_group_flag = 'Y' );

Line 753: FROM jtf_terr_qual_all jtq

749: /* get Qualifiers used in a territory */
750: CURSOR csr_get_qual( lp_terr_id NUMBER) IS
751: SELECT jtq.terr_qual_id
752: , jtq.qual_usg_id
753: FROM jtf_terr_qual_all jtq
754: WHERE jtq.terr_id = lp_terr_id;
755:
756: /* get Values used in a territory qualifier */
757: CURSOR csr_get_qual_val ( lp_terr_qual_id NUMBER ) IS

Line 4071: FROM jtf_terr_qual_all jtq

4067:
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

Line 4325: FROM jtf_terr_qual_all jtq

4321:
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

Line 4511: tabname => 'JTF_TERR_QUAL_ALL',

4507:
4508: /* JDOCHERT: 06/17/03: bug#2991180 */
4509: FND_STATS.GATHER_TABLE_STATS(
4510: ownname => 'JTF',
4511: tabname => 'JTF_TERR_QUAL_ALL',
4512: percent => 20,
4513: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */
4514: partname => NULL,
4515: backup_flag => 'NOBACKUP',