APPS.JTY_ASSIGN_BULK_PUB dependencies on JTF_TERR_ALL

Line 1279: , jtf_terr_all jt1

1275: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN
1276: SELECT COUNT(*)
1277: INTO num_of_terr
1278: FROM jtf_terr_qtype_usgs_all jtqu
1279: , jtf_terr_all jt1
1280: , jtf_qual_type_usgs jqtu
1281: WHERE jtqu.terr_id = jt1.terr_id
1282: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1283: AND jqtu.qual_type_id = p_trans_id

Line 1302: FROM jtf_terr_all jt

1298: AND jqta.qual_type_id = p_trans_id
1299: AND jtra.trans_access_code <> 'NONE')
1300: AND NOT EXISTS (
1301: SELECT jt.terr_id
1302: FROM jtf_terr_all jt
1303: WHERE jt.end_date_active < l_sysdate
1304: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1305: START WITH jt.terr_id = jt1.terr_id)
1306: AND jqtu.qual_type_id <> -1001;

Line 2005: ' , jtf_terr_all jt ' ||

2001: ' ORDER BY M.absolute_rank DESC, M.TERR_ID ) AS LL_TERR_RANK ' ||
2002: ' FROM ' || p_matches_target || ' M ' ||
2003: ' , ' || l_denorm_table_name || ' UL ' ||
2004: ' , ' || p_terr_L5_target_tbl || ' ML ' || /* FINAL LEVEL TABLE */
2005: ' , jtf_terr_all jt ' ||
2006: ' , ' || l_denorm_table_name || ' LL ' ||
2007: ' WHERE UL.level_from_root = 6 ' || /* UPPER level */
2008: ' AND UL.source_id = :b1_source_id ' ||
2009: ' AND UL.terr_id = M.TERR_ID ' ||

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

2757: ' , i.top_level_terr_id ' ||
2758: ' ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK ' ||
2759: ' FROM ' || l_match_target || ' i ' ||
2760: ' WHERE i.worker_id = :bv_worker_id ) o ' ||
2761: ' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) ' ||
2762: ' ) WT ' ||
2763: ' , jtf_terr_rsc_all jtr ' ||
2764: ' , jtf_terr_rsc_access_all jtra ' ||
2765: ' , jtf_qual_types_all jqta ' ||

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

2951: -- ' PROGRAM_UPDATE_DATE, ' ||
2952: ' worker_id) ( ';
2953:
2954: -- SOLIN, bug 5633062
2955: -- move jtf_terr_all out of inline view to avoid
2956: -- database bug
2957: l_dyn_str := l_dyn_str ||
2958: 'select ' ||
2959: ' ilv.trans_object_id, ' ||

Line 2980: ' jtf_terr_all jt ' ||

2976: l_dyn_str := l_dyn_str || ' union ';
2977: end if;
2978: end loop;
2979: l_dyn_str := l_dyn_str || ' ) ilv, ' ||
2980: ' jtf_terr_all jt ' ||
2981: 'where ilv.terr_id = jt.terr_id) ';
2982:
2983: /* SOLIN, the oritinal code follows: 5633062
2984: for i IN 1..l_max_terr loop

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

2998: -- ' ' || g_appl_id || ', ' ||
2999: -- ' ' || g_program_id || ', ' ||
3000: -- ' ''' || lp_sysdate || ''', ' ||
3001: ' ' || p_worker_id || ' ' ||
3002: 'from ' || l_dmc_winner_target || ' a, jtf_terr_all b ' ||
3003: 'where a.terr_id' || i || ' = b.terr_id ';
3004: if (i < l_max_terr) then
3005: l_dyn_str := l_dyn_str || ' union ';
3006: end if;