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_QUAL_TYPE_USGS_ALL

Line 516: G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || 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:
520: G_INDENT || ' AND jqtu.source_id = jtdr.source_id ' || g_newline ||

Line 544: G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || 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 ||
548:

Line 3279: ,jtf_qual_type_usgs_all jqtu

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
3283: AND jqtu.source_id = jtdr.source_id

Line 3435: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqtu ');

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:
3439: Add_To_PackageTable (' AND jqtu.source_id = jtdr.source_id ');