APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on FND_STATS

Line 4475: FND_STATS.GATHER_TABLE_STATS(

4471: /* analyse table */
4472: BEGIN
4473:
4474: /* JDOCHERT: 06/17/03: bug#2991180 */
4475: FND_STATS.GATHER_TABLE_STATS(
4476: ownname => 'JTF',
4477: tabname => 'JTF_TERR_DENORM_RULES_ALL',
4478: percent => 20,
4479: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4495: -- FND_STATS.GATHER_TABLE_STATS(

4491: ** ORACLE SALES, the records in JTF_TERR_DENORM_ALL
4492: ** are no longer required
4493: **/
4494: -- /* JDOCHERT: 06/17/03: bug#2991180 */
4495: -- FND_STATS.GATHER_TABLE_STATS(
4496: -- ownname => 'JTF',
4497: -- tabname => 'JTF_TERR_DENORM_ALL',
4498: -- percent => 20,
4499: -- degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4509: FND_STATS.GATHER_TABLE_STATS(

4505: --
4506:
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 */

Line 4522: FND_STATS.GATHER_TABLE_STATS(

4518: hmode => 'FULL'
4519: );
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 */

Line 4599: FND_STATS.GATHER_TABLE_STATS(

4595: /* analyse Materialized view */
4596: BEGIN
4597:
4598: /* JDOCHERT: 05/07/03: bug#2948883 */
4599: FND_STATS.GATHER_TABLE_STATS(
4600: ownname => 'APPS',
4601: tabname => 'JTF_TERR_QUAL_RULES_MV',
4602: percent => 20,
4603: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4629: FND_STATS.GATHER_TABLE_STATS(

4625: /* analyse Materialized view */
4626: BEGIN
4627:
4628: /* JDOCHERT: 05/07/03: bug#2948883 */
4629: FND_STATS.GATHER_TABLE_STATS(
4630: ownname => 'APPS',
4631: tabname => 'JTF_TERR_CNR_QUAL_LIKE_MV',
4632: percent => 20,
4633: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4659: FND_STATS.GATHER_TABLE_STATS(

4655: /* analyse Materialized view */
4656: BEGIN
4657:
4658: /* JDOCHERT: 05/07/03: bug#2948883 */
4659: FND_STATS.GATHER_TABLE_STATS(
4660: ownname => 'APPS',
4661: tabname => 'JTF_TERR_CNR_QUAL_BTWN_MV',
4662: percent => 20,
4663: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4689: FND_STATS.GATHER_TABLE_STATS(

4685: /* analyse Materialized view */
4686: BEGIN
4687:
4688: /* JDOCHERT: 05/07/03: bug#2948883 */
4689: FND_STATS.GATHER_TABLE_STATS(
4690: ownname => 'APPS',
4691: tabname => 'JTF_TERR_CNRG_EQUAL_MV',
4692: percent => 20,
4693: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4719: FND_STATS.GATHER_TABLE_STATS(

4715: /* analyse Materialized view */
4716: BEGIN
4717:
4718: /* JDOCHERT: 05/07/03: bug#2948883 */
4719: FND_STATS.GATHER_TABLE_STATS(
4720: ownname => 'APPS',
4721: tabname => 'JTF_TERR_CNRG_LIKE_MV',
4722: percent => 20,
4723: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */

Line 4749: FND_STATS.GATHER_TABLE_STATS(

4745: /* analyse Materialized view */
4746: BEGIN
4747:
4748: /* JDOCHERT: 05/07/03: bug#2948883 */
4749: FND_STATS.GATHER_TABLE_STATS(
4750: ownname => 'APPS',
4751: tabname => 'JTF_TERR_CNRG_BTWN_MV',
4752: percent => 20,
4753: degree => NULL, /* JDOCHERT: 04/10/03: bug#2896552 */