APPS.JTY_ASSIGN_REALTIME_PUB dependencies on JTF_TERR_RESULTS_GT_MT

Line 105: /* corresponding to the transaction objects into jtf_terr_results_gt_mt */

101: substr(l_matching_sql, 1, 4000));
102: END IF;
103:
104: /* Execute the matching SQL, which will insert matching territories */
105: /* corresponding to the transaction objects into jtf_terr_results_gt_mt */
106: DELETE jtf_terr_results_gt_mt;
107: EXECUTE IMMEDIATE l_matching_sql;
108:
109: -- debug message

Line 106: DELETE jtf_terr_results_gt_mt;

102: END IF;
103:
104: /* Execute the matching SQL, which will insert matching territories */
105: /* corresponding to the transaction objects into jtf_terr_results_gt_mt */
106: DELETE jtf_terr_results_gt_mt;
107: EXECUTE IMMEDIATE l_matching_sql;
108:
109: -- debug message
110: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 113: FROM jtf_terr_results_gt_mt;

109: -- debug message
110: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: SELECT COUNT(*)
112: INTO l_match_no_of_records
113: FROM jtf_terr_results_gt_mt;
114:
115: FND_LOG.string(FND_LOG.LEVEL_EVENT,
116: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_match.match_data',
117: 'Number of records inserted into jtf_terr_results_gt_mt table : ' || l_match_no_of_records);

Line 117: 'Number of records inserted into jtf_terr_results_gt_mt table : ' || l_match_no_of_records);

113: FROM jtf_terr_results_gt_mt;
114:
115: FND_LOG.string(FND_LOG.LEVEL_EVENT,
116: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_match.match_data',
117: 'Number of records inserted into jtf_terr_results_gt_mt table : ' || l_match_no_of_records);
118: END IF;
119:
120: -- debug message
121: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 325: FROM jtf_terr_results_GT_MT i ) o

321: , i.trans_object_id
322: , i.trans_detail_object_id
323: , i.top_level_terr_id
324: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
325: FROM jtf_terr_results_GT_MT i ) o
326: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
327: ) WT
328: , jtf_terr_all jta
329: , jtf_terr_rsc_all jtr

Line 479: FROM jtf_terr_results_GT_MT i ) o

475: , i.trans_object_id
476: , i.trans_detail_object_id
477: , i.top_level_terr_id
478: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
479: FROM jtf_terr_results_GT_MT i ) o
480: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
481: ) WT
482: , jtf_terr_all jta
483: , jtf_terr_rsc_all jtr

Line 577: FROM jtf_terr_results_GT_MT i ) o

573: , i.trans_object_id
574: , i.trans_detail_object_id
575: , i.top_level_terr_id
576: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
577: FROM jtf_terr_results_GT_MT i ) o
578: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
579: ) WT
580: , jtf_terr_all jta
581: WHERE WT.terr_id = jta.terr_id

Line 772: FROM jtf_terr_results_GT_MT i ) o

768: , i.trans_object_id
769: , i.trans_detail_object_id
770: , i.top_level_terr_id
771: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
772: FROM jtf_terr_results_GT_MT i ) o
773: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
774: ) WT
775: , jtf_terr_all jta
776: , jtf_terr_all jta_p

Line 890: l_matches_target := 'JTF_TERR_RESULTS_GT_MT';

886: END IF;
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889: l_worker_id := 1;
890: l_matches_target := 'JTF_TERR_RESULTS_GT_MT';
891: l_terr_L1_target := 'JTF_TERR_RESULTS_GT_L1';
892: l_terr_L2_target := 'JTF_TERR_RESULTS_GT_L2';
893: l_terr_L3_target := 'JTF_TERR_RESULTS_GT_L3';
894: l_terr_L4_target := 'JTF_TERR_RESULTS_GT_L4';