eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TAE_GEN_PVT dependencies on JTF_CHANGED_TERR_ALL

Line 542: G_INDENT || ' ,jtf_changed_terr_all jct ' || g_newline ||

538: G_INDENT || ' , jtdr.absolute_rank ' || g_newline ||
539: G_INDENT || ' , jtdr.num_winners ' || g_newline ||
540: G_INDENT || ' , jtdr.org_id ' || g_newline ||
541: G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_newline ||
542: G_INDENT || ' ,jtf_changed_terr_all jct ' || g_newline ||
543: G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_newline ||
544: G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_newline ||
545: G_INDENT || ' WHERE jqtu.source_id = p_source_id ' || g_newline ||
546: G_INDENT || ' AND jtdr.terr_id= jct.terr_id ' || g_newline ||

Line 3280: ,jtf_changed_terr_all b

3276: SELECT jtdr.terr_id, jtqu.qual_relation_product
3277: FROM jtf_terr_denorm_rules_all jtdr
3278: ,jtf_terr_qtype_usgs_all jtqu
3279: ,jtf_qual_type_usgs_all jqtu
3280: ,jtf_changed_terr_all b
3281: WHERE jtdr.terr_id = jtdr.related_terr_id
3282: AND jtdr.terr_id= b.terr_id
3283: AND jqtu.source_id = jtdr.source_id
3284: AND jqtu.qual_type_id = p_qual_type_id

Line 3297: /* get all the territory,relation_product from jtf_changed_terr_all,jtf_terr_denorm_rules_all

3293: RETURN;
3294:
3295: END IF;
3296:
3297: /* get all the territory,relation_product from jtf_changed_terr_all,jtf_terr_denorm_rules_all
3298: for the given qual_type_id */
3299: FOR JTF_csr in c_terr_rel_prod LOOP
3300:
3301: i := i + 1;