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_TERR_QTYPE_USGS_ALL

Line 515: G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_newline ||

511: G_INDENT || ' , jtdr.absolute_rank ' || g_newline ||
512: G_INDENT || ' , jtdr.num_winners ' || g_newline ||
513: G_INDENT || ' , jtdr.org_id ' || g_newline ||
514: G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_newline ||
515: G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_newline ||
516: G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_newline ||
517: G_INDENT || ' WHERE jtdr.source_id = p_source_id ' || g_newline ||
518: G_INDENT || ' AND jtdr.terr_id= jtdr.related_terr_id' || g_newline ||
519:

Line 543: G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || 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 ||
547: G_INDENT || ' AND jtdr.terr_id= jtdr.related_terr_id' || g_newline ||

Line 3278: ,jtf_terr_qtype_usgs_all jtqu

3274: /* ARPATEL: 01/06/2004 bug#3337382 */
3275: CURSOR c_terr_rel_prod is
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

Line 3434: Add_To_PackageTable (' ,jtf_terr_qtype_usgs_all jtqu ');

3430: Add_To_PackageTable (' , jtdr.absolute_rank ');
3431: Add_To_PackageTable (' , jtdr.num_winners ');
3432: Add_To_PackageTable (' , jtdr.org_id ');
3433: Add_To_PackageTable (' FROM jtf_terr_denorm_rules_all jtdr ');
3434: Add_To_PackageTable (' ,jtf_terr_qtype_usgs_all jtqu ');
3435: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqtu ');
3436: Add_To_PackageTable (' WHERE jtdr.source_id = p_source_id ');
3437: Add_To_PackageTable (' AND jtdr.resource_exists_flag= ''Y'' ');
3438: