APPS.JTY_ASSIGN_BULK_PUB dependencies on JTF_TERR_ALL

Line 1365: , jtf_terr_all jt1

1361: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN
1362: SELECT COUNT(*)
1363: INTO num_of_terr
1364: FROM jtf_terr_qtype_usgs_all jtqu
1365: , jtf_terr_all jt1
1366: , jtf_qual_type_usgs jqtu
1367: WHERE jtqu.terr_id = jt1.terr_id
1368: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1369: AND jqtu.qual_type_id = p_trans_id

Line 1388: FROM jtf_terr_all jt

1384: AND jqta.qual_type_id = p_trans_id
1385: AND jtra.trans_access_code <> 'NONE')
1386: AND NOT EXISTS (
1387: SELECT jt.terr_id
1388: FROM jtf_terr_all jt
1389: WHERE jt.end_date_active < l_sysdate
1390: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1391: START WITH jt.terr_id = jt1.terr_id)
1392: AND jqtu.qual_type_id <> -1001;

Line 2137: ' , jtf_terr_all jt ' ||

2133: ' ORDER BY M.absolute_rank DESC, M.TERR_ID ) AS LL_TERR_RANK ' ||
2134: ' FROM ' || p_matches_target || ' M ' ||
2135: ' , ' || l_denorm_table_name || ' UL ' ||
2136: ' , ' || p_terr_L5_target_tbl || ' ML ' || /* FINAL LEVEL TABLE */
2137: ' , jtf_terr_all jt ' ||
2138: ' , ' || l_denorm_table_name || ' LL ' ||
2139: ' WHERE UL.level_from_root = 6 ' || /* UPPER level */
2140: ' AND UL.source_id = :b1_source_id ' ||
2141: ' AND UL.terr_id = M.TERR_ID ' ||

Line 2910: ' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) ' ||

2906: ' , i.top_level_terr_id ' ||
2907: ' ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK ' ||
2908: ' FROM ' || l_match_target || ' i ' ||
2909: ' WHERE i.worker_id = :bv_worker_id ) o ' ||
2910: ' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) ' ||
2911: ' ) WT ' ||
2912: ' , jtf_terr_rsc_all jtr ' ||
2913: ' , jtf_terr_rsc_access_all jtra ' ||
2914: ' , jtf_qual_types_all jqta ' ||

Line 3116: -- move jtf_terr_all out of inline view to avoid

3112: -- ' PROGRAM_UPDATE_DATE, ' ||
3113: ' worker_id) ( ';
3114:
3115: -- SOLIN, bug 5633062
3116: -- move jtf_terr_all out of inline view to avoid
3117: -- database bug
3118: l_dyn_str := l_dyn_str ||
3119: 'select ' ||
3120: ' ilv.trans_object_id, ' ||

Line 3141: ' jtf_terr_all jt ' ||

3137: l_dyn_str := l_dyn_str || ' union ';
3138: end if;
3139: end loop;
3140: l_dyn_str := l_dyn_str || ' ) ilv, ' ||
3141: ' jtf_terr_all jt ' ||
3142: 'where ilv.terr_id = jt.terr_id) ';
3143:
3144: /* SOLIN, the oritinal code follows: 5633062
3145: for i IN 1..l_max_terr loop

Line 3163: 'from ' || l_dmc_winner_target || ' a, jtf_terr_all b ' ||

3159: -- ' ' || g_appl_id || ', ' ||
3160: -- ' ' || g_program_id || ', ' ||
3161: -- ' ''' || lp_sysdate || ''', ' ||
3162: ' ' || p_worker_id || ' ' ||
3163: 'from ' || l_dmc_winner_target || ' a, jtf_terr_all b ' ||
3164: 'where a.terr_id' || i || ' = b.terr_id ';
3165: if (i < l_max_terr) then
3166: l_dyn_str := l_dyn_str || ' union ';
3167: end if;