APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 1311: l_qual_rules := l_qual_rules || l_newline || ' , jtf_terr_values_all jtv, jtf_terr_denorm_rules_all B, jtf_terr_qual_all jtq ';

1307: l_qual_rules := l_qual_rules || l_newline || ' UNION ALL ' || l_newline;
1308: END IF;
1309: l_qual_rules := l_qual_rules || l_rts_tbl(j) || l_newline || ' FROM ' || l_trans_name_tbl(i) || ' A ';
1310: /* add the denorm value table name */
1311: l_qual_rules := l_qual_rules || l_newline || ' , jtf_terr_values_all jtv, jtf_terr_denorm_rules_all B, jtf_terr_qual_all jtq ';
1312: IF (l_rtf_tbl(j) IS NOT NULL) THEN
1313: l_qual_rules := l_qual_rules || l_newline || ' ,' || l_rtf_tbl(j) || ' ';
1314: END IF;
1315: l_qual_rules := l_qual_rules || l_newline || l_rtw_tbl(j) || l_newline || ' ';

Line 1541: FROM jtf_terr_denorm_rules_all jtdr

1537: AND jqta.qual_type_id = p_trans_id
1538: AND jtra.trans_access_code <> 'NONE')
1539: AND EXISTS (
1540: SELECT 1
1541: FROM jtf_terr_denorm_rules_all jtdr
1542: WHERE jtdr.terr_id = jt1.terr_id
1543: AND jtdr.terr_id = jtdr.related_terr_id)
1544: AND jqtu.qual_type_id <> -1001
1545: AND rownum < 2;