APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_VALUES_ALL

Line 257: DELETE FROM jtf_terr_values_all jtv

253: /* TOTAL mode => re-generate all NA territories */
254: IF (p_mode = 'TOTAL') THEN
255:
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

Line 773: FROM jtf_terr_values_all jtv

769: , jtv.CURRENCY_CODE
770: , jtv.ORG_ID
771: , jtv.ID_USED_FLAG
772: , jtv.LOW_VALUE_CHAR_ID
773: FROM jtf_terr_values_all jtv
774: WHERE jtv.terr_qual_id = lp_terr_qual_id;
775:
776:
777: /* get those roles for a territory Group that

Line 4524: tabname => 'JTF_TERR_VALUES_ALL',

4520:
4521: /* JDOCHERT: 06/17/03: bug#2991180 */
4522: FND_STATS.GATHER_TABLE_STATS(
4523: ownname => 'JTF',
4524: tabname => 'JTF_TERR_VALUES_ALL',
4525: percent => 20,
4526: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */
4527: partname => NULL,
4528: backup_flag => 'NOBACKUP',