eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 3731: FROM jtf_terr_denorm_rules_all jtdr

3727: */
3728: CURSOR csr_get_denorm_terr ( lp_source_id NUMBER
3729: , lp_qual_type_id NUMBER) IS
3730: SELECT jtdr.terr_id
3731: FROM jtf_terr_denorm_rules_all jtdr
3732: WHERE jtdr.terr_id = jtdr.related_terr_id
3733: AND jtdr.source_id = lp_source_id
3734: AND jtdr.qual_type_id = lp_qual_type_id;
3735:

Line 3742: , jtf_terr_denorm_rules_all jtdr

3738: , lp_qual_type_id NUMBER ) IS
3739: SELECT jtqu.terr_id
3740: , jtqu.terr_qtype_usg_id
3741: FROM jtf_terr_qtype_usgs_all jtqu
3742: , jtf_terr_denorm_rules_all jtdr
3743: , jtf_qual_type_usgs jqtu
3744: WHERE jqtu.qual_type_id = LP_qual_type_id
3745: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
3746: AND jtqu.terr_id = jtdr.terr_id

Line 3754: FROM jtf_terr_denorm_rules_all jtdr

3750:
3751: CURSOR csr_get_RSC_denorm_terr ( lp_source_id NUMBER
3752: , lp_qual_type_id NUMBER) IS
3753: SELECT jtdr.terr_id
3754: FROM jtf_terr_denorm_rules_all jtdr
3755: WHERE jtdr.terr_id = jtdr.related_terr_id
3756: AND jtdr.source_id = lp_source_id
3757: AND jtdr.qual_type_id = lp_qual_type_id
3758: AND jtdr.resource_exists_flag = 'Y';

Line 3763: FROM jtf_terr_denorm_rules_all jtdr

3759:
3760: /* ARPATEL: 12/03/2003: Oracle Sales only has one record per territory in terr_denorm_rules_all (no longer strpied by TX type) */
3761: CURSOR csr_get_SALES_denorm_terr ( lp_source_id NUMBER ) IS
3762: SELECT jtdr.terr_id
3763: FROM jtf_terr_denorm_rules_all jtdr
3764: WHERE jtdr.terr_id = jtdr.related_terr_id
3765: AND jtdr.source_id = lp_source_id;
3766:
3767: CURSOR csr_get_transactions(lp_source_id NUMBER) IS

Line 3878: UPDATE jtf_terr_denorm_rules_all j

3874: --dbms_output.put_line('AFTER: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');
3875:
3876:
3877: /* populate resource_exists_flag and absolute rank for Oracle Sales */
3878: UPDATE jtf_terr_denorm_rules_all j
3879: SET j.resource_exists_flag = 'Y'
3880: WHERE EXISTS
3881: ( SELECT jtr.terr_id
3882: FROM jtf_terr_rsc_all jtr

Line 3891: --dbms_output.put_line('UPDATE jtf_terr_denorm_rules_all, SET jtdr.resource_exists_flag ');

3887: AND j.terr_id = j.related_terr_id
3888: AND j.source_id = p_source_id;
3889:
3890:
3891: --dbms_output.put_line('UPDATE jtf_terr_denorm_rules_all, SET jtdr.resource_exists_flag ');
3892: FOR csr_dnm IN csr_get_SALES_denorm_terr( p_source_id ) LOOP
3893:
3894: UPDATE jtf_terr_denorm_rules_all jtdr
3895: SET jtdr.ABSOLUTE_RANK = (

Line 3894: UPDATE jtf_terr_denorm_rules_all jtdr

3890:
3891: --dbms_output.put_line('UPDATE jtf_terr_denorm_rules_all, SET jtdr.resource_exists_flag ');
3892: FOR csr_dnm IN csr_get_SALES_denorm_terr( p_source_id ) LOOP
3893:
3894: UPDATE jtf_terr_denorm_rules_all jtdr
3895: SET jtdr.ABSOLUTE_RANK = (
3896: SELECT SUM(jt1.relative_rank)
3897: FROM jtf_terr_denorm_rules_all jt1
3898: WHERE jt1.related_terr_id = jt1.terr_id

Line 3897: FROM jtf_terr_denorm_rules_all jt1

3893:
3894: UPDATE jtf_terr_denorm_rules_all jtdr
3895: SET jtdr.ABSOLUTE_RANK = (
3896: SELECT SUM(jt1.relative_rank)
3897: FROM jtf_terr_denorm_rules_all jt1
3898: WHERE jt1.related_terr_id = jt1.terr_id
3899:
3900: /* JDOCHERT: 12/09/03: records in JTF_TERR_DENORM_RULES_ALL
3901: ** are no longer striped by QUAL_TYPE_ID, so commenting out the

Line 3900: /* JDOCHERT: 12/09/03: records in JTF_TERR_DENORM_RULES_ALL

3896: SELECT SUM(jt1.relative_rank)
3897: FROM jtf_terr_denorm_rules_all jt1
3898: WHERE jt1.related_terr_id = jt1.terr_id
3899:
3900: /* JDOCHERT: 12/09/03: records in JTF_TERR_DENORM_RULES_ALL
3901: ** are no longer striped by QUAL_TYPE_ID, so commenting out the
3902: ** the following lines
3903: */
3904: --ARPATEL: 11/12/03 Bug#3254575 */

Line 3929: --dbms_output.put_line('GEN: AFTER: UPDATE jtf_terr_denorm_rules_all, SET jtdr.resource_exists_flag ');

3925: AND jtdr.terr_id = CSR_DNM.terr_id;
3926:
3927: END LOOP;
3928:
3929: --dbms_output.put_line('GEN: AFTER: UPDATE jtf_terr_denorm_rules_all, SET jtdr.resource_exists_flag ');
3930:
3931: END IF;
3932:
3933:

Line 3980: UPDATE jtf_terr_denorm_rules_all j

3976: /* Setting resource_exists flag */
3977: BEGIN
3978:
3979: /* get all territories that have resources attached */
3980: UPDATE jtf_terr_denorm_rules_all j
3981: SET j.resource_exists_flag = 'Y'
3982: WHERE EXISTS
3983: ( SELECT jtr.terr_id
3984: FROM jtf_terr_rsc_all jtr

Line 4006: UPDATE jtf_terr_denorm_rules_all jtdr

4002:
4003: FOR csr_dnm IN csr_get_denorm_terr( p_source_id
4004: , lp_qual_type_id) LOOP
4005:
4006: UPDATE jtf_terr_denorm_rules_all jtdr
4007: SET jtdr.ABSOLUTE_RANK = (
4008: SELECT SUM(jt1.relative_rank)
4009: FROM jtf_terr_denorm_rules_all jt1
4010: WHERE jt1.related_terr_id = jt1.terr_id

Line 4009: FROM jtf_terr_denorm_rules_all jt1

4005:
4006: UPDATE jtf_terr_denorm_rules_all jtdr
4007: SET jtdr.ABSOLUTE_RANK = (
4008: SELECT SUM(jt1.relative_rank)
4009: FROM jtf_terr_denorm_rules_all jt1
4010: WHERE jt1.related_terr_id = jt1.terr_id
4011:
4012: /* ARPATEL: 11/12/03 Bug#3254575 */
4013: AND jt1.qual_type_id = lp_qual_type_id

Line 4187: UPDATE jtf_terr_denorm_rules_all j

4183: IF ( p_source_id = -1001 ) THEN
4184:
4185: BEGIN
4186: /* get all territories that have resources attached */
4187: UPDATE jtf_terr_denorm_rules_all j
4188: SET j.resource_exists_flag = 'Y'
4189: WHERE EXISTS
4190: ( SELECT jtr.terr_id
4191: FROM jtf_terr_rsc_all jtr

Line 4208: UPDATE jtf_terr_denorm_rules_all jtdr

4204: BEGIN
4205:
4206: FOR csr_dnm IN csr_get_SALES_denorm_terr( p_source_id ) LOOP
4207:
4208: UPDATE jtf_terr_denorm_rules_all jtdr
4209: SET jtdr.ABSOLUTE_RANK = (
4210: SELECT SUM(jt1.relative_rank)
4211: FROM jtf_terr_denorm_rules_all jt1
4212: WHERE jt1.related_terr_id = jt1.terr_id

Line 4211: FROM jtf_terr_denorm_rules_all jt1

4207:
4208: UPDATE jtf_terr_denorm_rules_all jtdr
4209: SET jtdr.ABSOLUTE_RANK = (
4210: SELECT SUM(jt1.relative_rank)
4211: FROM jtf_terr_denorm_rules_all jt1
4212: WHERE jt1.related_terr_id = jt1.terr_id
4213:
4214:
4215: /* JDOCHERT: 12/09/03: records in JTF_TERR_DENORM_RULES_ALL

Line 4215: /* JDOCHERT: 12/09/03: records in JTF_TERR_DENORM_RULES_ALL

4211: FROM jtf_terr_denorm_rules_all jt1
4212: WHERE jt1.related_terr_id = jt1.terr_id
4213:
4214:
4215: /* JDOCHERT: 12/09/03: records in JTF_TERR_DENORM_RULES_ALL
4216: ** are no longer striped by QUAL_TYPE_ID, so commenting out the
4217: ** the following lines
4218: */
4219: /* ARPATEL: 11/12/03 Bug#3254575 */

Line 4245: UPDATE jtf_terr_denorm_rules_all j

4241:
4242: /* moved from jtf_terr_denorm_rules_pvt */
4243: BEGIN
4244: /* get all territories that have resources attached */
4245: UPDATE jtf_terr_denorm_rules_all j
4246: SET j.resource_exists_flag = 'Y'
4247: WHERE EXISTS
4248: ( SELECT jtr.terr_id
4249: FROM jtf_terr_rsc_all jtr

Line 4268: UPDATE jtf_terr_denorm_rules_all jtdr

4264:
4265: FOR csr_dnm IN csr_get_denorm_terr( p_source_id
4266: , LP_QUAL_TYPE_ID ) LOOP
4267:
4268: UPDATE jtf_terr_denorm_rules_all jtdr
4269: SET jtdr.ABSOLUTE_RANK = (
4270: SELECT SUM(jt1.relative_rank)
4271: FROM jtf_terr_denorm_rules_all jt1
4272: WHERE jt1.related_terr_id = jt1.terr_id

Line 4271: FROM jtf_terr_denorm_rules_all jt1

4267:
4268: UPDATE jtf_terr_denorm_rules_all jtdr
4269: SET jtdr.ABSOLUTE_RANK = (
4270: SELECT SUM(jt1.relative_rank)
4271: FROM jtf_terr_denorm_rules_all jt1
4272: WHERE jt1.related_terr_id = jt1.terr_id
4273: /* ARPATEL: 11/12/03 Bug#3254575 */
4274: AND jt1.qual_type_id = p_qualifier_type_id
4275: AND jt1.terr_id IN

Line 4441: ** since records in JTF_TERR_DENORM_RULES_ALL

4437: NULL;
4438: END;
4439:
4440: /* JDOCHERT: 12/09/03: bug#3307414
4441: ** since records in JTF_TERR_DENORM_RULES_ALL
4442: ** are no longer striped by QUAL_TYPE_ID for
4443: ** ORACLE SALES, the records in JTF_TERR_DENORM_ALL
4444: ** are no longer required
4445: **/

Line 4464: --FROM jtf_terr_denorm_rules_all j

4460: -- , j.absolute_rank
4461: -- , j.related_terr_id
4462: -- , j.top_level_terr_id
4463: -- , j.num_winners
4464: --FROM jtf_terr_denorm_rules_all j
4465: --WHERE j.source_id = -1001;
4466: --
4467:
4468: END IF;

Line 4477: tabname => 'JTF_TERR_DENORM_RULES_ALL',

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 */
4480: partname => NULL,
4481: backup_flag => 'NOBACKUP',

Line 4489: ** since records in JTF_TERR_DENORM_RULES_ALL

4485: );
4486:
4487:
4488: /* JDOCHERT: 12/09/03: bug#3307414
4489: ** since records in JTF_TERR_DENORM_RULES_ALL
4490: ** are no longer striped by QUAL_TYPE_ID for
4491: ** ORACLE SALES, the records in JTF_TERR_DENORM_ALL
4492: ** are no longer required
4493: **/

Line 4549: FROM jtf_terr_denorm_rules_all j

4545: IF (G_Debug) THEN
4546:
4547: SELECT count(*)
4548: INTO l_denorm_count
4549: FROM jtf_terr_denorm_rules_all j
4550: WHERE j.source_id = p_source_id
4551: AND ( ( j.qual_type_id = p_qualifier_type_id )
4552: OR
4553: ( p_source_id = -1001 AND p_qualifier_type_id IS NULL )

Line 4558: Write_Log(2, 'Populating denorm table - JTF_TERR_DENORM_RULES_ALL ');

4554: );
4555:
4556: Write_Log(2, ' ');
4557: Write_Log(2, '/***************** BEGIN: DENORM STATUS *********************/');
4558: Write_Log(2, 'Populating denorm table - JTF_TERR_DENORM_RULES_ALL ');
4559: Write_Log(2, 'Inserted ' || l_denorm_count || ' rows into JTF_TERR_DENORM_RULES_ALL ');
4560:
4561:
4562: /* JDOCHERT: 12/09/03: bug#3307414

Line 4559: Write_Log(2, 'Inserted ' || l_denorm_count || ' rows into JTF_TERR_DENORM_RULES_ALL ');

4555:
4556: Write_Log(2, ' ');
4557: Write_Log(2, '/***************** BEGIN: DENORM STATUS *********************/');
4558: Write_Log(2, 'Populating denorm table - JTF_TERR_DENORM_RULES_ALL ');
4559: Write_Log(2, 'Inserted ' || l_denorm_count || ' rows into JTF_TERR_DENORM_RULES_ALL ');
4560:
4561:
4562: /* JDOCHERT: 12/09/03: bug#3307414
4563: ** since records in JTF_TERR_DENORM_RULES_ALL

Line 4563: ** since records in JTF_TERR_DENORM_RULES_ALL

4559: Write_Log(2, 'Inserted ' || l_denorm_count || ' rows into JTF_TERR_DENORM_RULES_ALL ');
4560:
4561:
4562: /* JDOCHERT: 12/09/03: bug#3307414
4563: ** since records in JTF_TERR_DENORM_RULES_ALL
4564: ** are no longer striped by QUAL_TYPE_ID for
4565: ** ORACLE SALES, the records in JTF_TERR_DENORM_ALL
4566: ** are no longer required
4567: **/