APPS.JTF_TERR_DIAGNOSTIC_TEST dependencies on JTF_TERR_DENORM_RULES_ALL

Line 75: from jtf_terr_denorm_rules_all jtdr

71:
72: CURSOR C_valid_terrs(lc_source_id NUMBER)
73: IS
74: select qta.description name, count(*) terr_count
75: from jtf_terr_denorm_rules_all jtdr
76: , jtf_qual_types qta
77: where jtdr.source_id = lc_source_id
78: and jtdr.terr_id = jtdr.related_terr_id
79: and jtdr.qual_type_id = qta.qual_type_id

Line 86: from jtf_terr_denorm_rules_all jtdr

82:
83: CURSOR C_valid_terrs_with_reps(lc_source_id NUMBER)
84: IS
85: select qta.description name, count(*) terr_count
86: from jtf_terr_denorm_rules_all jtdr
87: , jtf_qual_types_all qta
88: where jtdr.source_id = lc_source_id
89: and jtdr.terr_id = jtdr.related_terr_id
90: and jtdr.qual_type_id = qta.qual_type_id

Line 147: FROM jtf_terr_denorm_rules_all r

143: , q.qual_usg_id qual_usg_id
144: , v.terr_value_id terr_value_id
145: , v.comparison_operator comparison_operator
146: , v.low_value_char_id low_value_char_id
147: FROM jtf_terr_denorm_rules_all r
148: , jtf_terr_qual_all q
149: , jtf_terr_values_all v
150: WHERE r.source_id = -1001
151: AND q.terr_id = r.related_terr_id

Line 241: FROM jtf_terr_denorm_rules_all r

237: , q.qual_usg_id qual_usg_id
238: , v.terr_value_id terr_value_id
239: , v.comparison_operator comparison_operator
240: , v.low_value_char_id low_value_char_id
241: FROM jtf_terr_denorm_rules_all r
242: , jtf_terr_qual_all q
243: , jtf_terr_values_all v
244: WHERE r.source_id = -1001
245: AND q.terr_id = r.related_terr_id

Line 494: FROM jtf_terr_denorm_rules_all jtdr

490: from jtf_terr_rsc_all jtr
491: where jtr.start_date_active <= SYSDATE
492: AND NVL(jtr.end_date_active, SYSDATE) >= SYSDATE
493: AND EXISTS ( SELECT jtdr.terr_id
494: FROM jtf_terr_denorm_rules_all jtdr
495: WHERE jtdr.source_id = l_source_id );
496:
497: JTF_DIAGNOSTIC_COREAPI.line_out( '  5. Number of ACTIVE '||l_meaning||' Territory Resource Assignments = '||l_terr_res_assign);
498: JTF_DIAGNOSTIC_COREAPI.brprint;

Line 510: FROM jtf_terr_denorm_rules_all jtdr

506: from jtf_terr_rsc_all jtr
507: where jtr.start_date_active <= SYSDATE
508: AND NVL(jtr.end_date_active, SYSDATE) >= SYSDATE
509: AND EXISTS ( SELECT jtdr.terr_id
510: FROM jtf_terr_denorm_rules_all jtdr
511: WHERE jtdr.source_id = l_source_id ) );
512:
513: JTF_DIAGNOSTIC_COREAPI.line_out('  6. Number of ACTIVE '||l_meaning||' Territory Resources (Total # of Active Reps) = '||l_active_reps);
514: JTF_DIAGNOSTIC_COREAPI.brprint;