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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 88


   /* dblee: 08/20/03 - define global variable for holding select clause which differs
        between 'full' mode and 'new mode' TAP */
   k_select_list_fm  CONSTANT VARCHAR2(240) :=
       'SELECT a.trans_object_id,a.trans_detail_object_id,a.worker_id,a.header_id1,a.header_id2,'
          || 'ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners,ILV.org_id ';

Line: 94


   k_select_list_nm  CONSTANT VARCHAR2(240) :=
       'SELECT A.*,ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners  ';

Line: 97


   g_select_list_1   VARCHAR2(240) := k_select_list_fm;

Line: 506


           G_INDENT || '     ( SELECT /*+ NO_MERGE */               ' || g_newline ||
           G_INDENT || '              jtdr.terr_id                  ' || g_newline ||
           G_INDENT || '            , jtdr.source_id                ' || g_newline ||
           G_INDENT || '            , jtdr.qual_type_id             ' || g_newline ||
           G_INDENT || '            , jtdr.top_level_terr_id        ' || g_newline ||
           G_INDENT || '            , jtdr.absolute_rank            ' || g_newline ||
           G_INDENT || '            , jtdr.num_winners              ' || g_newline ||
           G_INDENT || '            , jtdr.org_id                   ' || g_newline ||
           G_INDENT || '       FROM  jtf_terr_denorm_rules_all jtdr ' || g_newline ||
           G_INDENT || '            ,jtf_terr_qtype_usgs_all jtqu   ' || g_newline ||
           G_INDENT || '            ,jtf_qual_type_usgs_all jqtu    ' || g_newline ||
           G_INDENT || '       WHERE jtdr.source_id = p_source_id    ' || g_newline ||
           G_INDENT || '         AND jtdr.terr_id= jtdr.related_terr_id' || g_newline ||

           G_INDENT || '         AND jqtu.source_id = jtdr.source_id    ' || g_newline ||
           G_INDENT || '         AND jqtu.qual_type_id = p_trans_object_type_id ' || g_newline ||
           G_INDENT || '         AND jtdr.terr_id = jtqu.terr_id ' || g_newline ||
           G_INDENT || '         AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id ' || g_newline ||

           G_INDENT || '         AND jtdr.resource_exists_flag = ''Y'' '|| g_newline ||
           G_INDENT || '         AND jtqu.qual_relation_product = lp_qual_combination_tbl(i) ' || g_newline ||
           G_INDENT || '     ) ILV'||g_newline;

Line: 533


          G_INDENT || '     ( SELECT /*+ NO_MERGE */ DISTINCT      ' || g_newline ||
          G_INDENT || '              jtdr.terr_id                  ' || g_newline ||
          G_INDENT || '            , jtdr.source_id                ' || g_newline ||
          G_INDENT || '            , jtdr.qual_type_id             ' || g_newline ||
          G_INDENT || '            , jtdr.top_level_terr_id        ' || g_newline ||
          G_INDENT || '            , jtdr.absolute_rank            ' || g_newline ||
          G_INDENT || '            , jtdr.num_winners              ' || g_newline ||
          G_INDENT || '            , jtdr.org_id                   ' || g_newline ||
          G_INDENT || '       FROM  jtf_terr_denorm_rules_all jtdr ' || g_newline ||
          G_INDENT || '            ,jtf_changed_terr_all jct       ' || g_newline ||
          G_INDENT || '            ,jtf_terr_qtype_usgs_all jtqu   ' || g_newline ||
          G_INDENT || '            ,jtf_qual_type_usgs_all jqtu    ' || g_newline ||
          G_INDENT || '       WHERE jqtu.source_id = p_source_id   ' || g_newline ||
          G_INDENT || '         AND jtdr.terr_id= jct.terr_id      ' || g_newline ||
          G_INDENT || '         AND jtdr.terr_id= jtdr.related_terr_id' || g_newline ||

          G_INDENT || '         AND jqtu.source_id = jtdr.source_id    ' || g_newline ||
          G_INDENT || '         AND jqtu.qual_type_id = p_trans_object_type_id ' || g_newline ||
          G_INDENT || '         AND jct.terr_id = jtqu.terr_id ' || g_newline ||
          G_INDENT || '         AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id ' || g_newline ||

          G_INDENT || '         AND jtdr.resource_exists_flag = ''Y'' '|| g_newline ||
          G_INDENT || '         AND jtqu.qual_relation_product = lp_qual_combination_tbl(i) ' || g_newline ||
          G_INDENT || '     ) ILV'||g_newline;

Line: 568


   PROCEDURE add_insert_nmtrans(p_match_table_name  IN   VARCHAR2)
   AS
   BEGIN

      Add_To_PackageTable ('         INSERT INTO  '|| p_match_table_name || ' i');

Line: 580


      Add_To_PackageTable ('            , LAST_UPDATE_DATE');

Line: 581


      Add_To_PackageTable ('            , LAST_UPDATED_BY');

Line: 584


      Add_To_PackageTable ('            , LAST_UPDATE_LOGIN');

Line: 588


      Add_To_PackageTable ('            , PROGRAM_UPDATE_DATE');

Line: 734


        Add_To_PackageTable ('-- Program failed in add_insert_nmtrans procedure ');

Line: 736


   END add_insert_nmtrans;

Line: 739


   PROCEDURE add_select_nmtrans(p_match_table_name  IN   VARCHAR2)
   AS
   BEGIN

      Add_To_PackageTable ('         SELECT DISTINCT ');

Line: 904


         Add_To_PackageTable ('-- Program failed in add_select_nmtrans procedure ');

Line: 906


   END add_select_nmtrans;

Line: 973


      l_select         VARCHAR2(32767);

Line: 979


         SELECT distinct jtqp.relation_product
                ,jtqf.qual_usg_id
                ,jqu.alias_rule1
                ,jqu.alias_op_like
                ,jqu.alias_op_between
                ,jqu.op_eql
                ,jqu.op_not_eql
                ,jqu.op_lss_thn
                ,jqu.op_lss_thn_eql
                ,jqu.op_grtr_thn
                ,jqu.op_grtr_thn_eql
                ,jqu.op_like
                ,jqu.op_not_like
                ,jqu.op_between
                ,jqu.op_not_between
                ,jqu.op_common_where
          FROM jtf_qual_usgs_all jqu,
               jtf_tae_qual_factors jtqf,
               jtf_tae_qual_products jtqp,
               jtf_tae_qual_prod_factors jtpf
          WHERE jqu.org_id = -3113
          AND jqu.qual_usg_id = jtqf.qual_usg_id
            and jtpf.qual_factor_id = jtqf.qual_factor_id
            and jtqf.relation_factor = p_relation_factor
            and jtqp.qual_product_id = jtpf.qual_product_id
            and jtqp.relation_product = p_relation_product
            and jtqp.source_id = p_source_id
            and jtqp.trans_object_type_id = p_qual_type_id
            and jqu.op_not_eql IS NULL
            and jqu.op_not_like IS NULL
            and jqu.op_not_between IS NULL
          ORDER BY jtqf.qual_usg_id;

Line: 1021


             l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                         G_INDENT || '       AI.customer_id' || l_newline ||
                         G_INDENT || '     , AI.address_id'  || l_newline;

Line: 1025


             l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                         G_INDENT || '       ASLLP.sales_lead_id' || l_newline ||
                         G_INDENT || '     , ASLLP.sales_lead_line_id'  || l_newline;

Line: 1029


             l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                         G_INDENT || '       ASLL.sales_lead_id' || l_newline ||
                         G_INDENT || '     , ASLL.sales_lead_line_id'  || l_newline;

Line: 1033


             l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                         G_INDENT || '       ASLLI.sales_lead_id' || l_newline ||
                         G_INDENT || '     , ASLLI.sales_lead_line_id'  || l_newline;

Line: 1037


              l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                          G_INDENT || '       ALLP.lead_id' || l_newline ||
                          G_INDENT || '     , ALLP.lead_line_id' || l_newline;

Line: 1041


              l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                          G_INDENT || '       ALLI.lead_id' || l_newline ||
                          G_INDENT || '     , ALLI.lead_line_id' || l_newline;

Line: 1045


              l_select := G_INDENT || 'SELECT ' || l_idx_hint || G_NEWLINE ||
                          G_INDENT || '       OAI.lead_id' || l_newline ;

Line: 1050


         l_select := l_select ||
            G_INDENT || '     , ILV.terr_id                  ' || l_newline ||
            G_INDENT || '     , ILV.top_level_terr_id        ' || l_newline ||
            G_INDENT || '     , ILV.absolute_rank            ' || l_newline ||
            G_INDENT || '     , ILV.num_winners              ' || l_newline ||
            G_INDENT || '     , ILV.org_id                   ' || l_newline;

Line: 1097


            l_select || l_newline ||
               l_from_str || l_newline ||
               l_where_str || l_newline ||
                  l_predicate;

Line: 1129


         SELECT DISTINCT jtqp.relation_product
               ,jtqf.qual_usg_id
               ,jqu.alias_rule1
               ,jqu.alias_op_like
               ,jqu.alias_op_between
               ,jqu.op_eql
               ,jqu.op_not_eql
               ,jqu.op_lss_thn
               ,jqu.op_lss_thn_eql
               ,jqu.op_grtr_thn
               ,jqu.op_grtr_thn_eql
               ,jqu.op_like
               ,jqu.op_not_like
               ,jqu.op_between
               ,jqu.op_not_between
               ,jqu.op_common_where
         FROM jtf_qual_usgs_all jqu,
               jtf_tae_qual_factors jtqf,
               jtf_tae_qual_products jtqp,
               jtf_tae_qual_prod_factors jtpf
         WHERE jqu.org_id = -3113
            AND jqu.qual_usg_id = jtqf.qual_usg_id
            AND jtpf.qual_factor_id= jtqf.qual_factor_id
            AND jtqf.relation_factor <> p_relation_factor
            AND jtqp.qual_product_id = jtpf.qual_product_id
            AND jtqp.relation_product = p_relation_product
            AND jtqp.source_id = p_source_id
            AND jtqp.trans_object_type_id= p_qual_type_id
            AND jqu.op_not_eql IS NULL
            AND jqu.op_not_like IS NULL
            AND jqu.op_not_between IS NULL
         ORDER BY jtqf.qual_usg_id;

Line: 1183


      l_select_eq          VARCHAR2(32767);

Line: 1184


      l_select_like        VARCHAR2(32767);

Line: 1185


      l_select_btw         VARCHAR2(32767);

Line: 1239


					l_select_eq := l_newline || g_select_list_1;

Line: 1240


                    l_select_like := l_newline || g_select_list_1;

Line: 1241


    		        l_select_btw := l_newline || g_select_list_1;

Line: 1244


                      l_select_eq := l_select_eq || ' ,A.SQUAL_NUM01, A.SQUAL_NUM02 ';

Line: 1245


                      l_select_like := l_select_like || ' ,A.SQUAL_NUM01, A.SQUAL_NUM02 ';

Line: 1246


                      l_select_btw := l_select_btw || ' ,A.SQUAL_NUM01, A.SQUAL_NUM02 ';

Line: 1292


					l_select_eq := l_newline || g_select_list_1;

Line: 1293


                    l_select_like := l_newline || g_select_list_1;

Line: 1294


                    l_select_btw := l_newline || g_select_list_1;

Line: 1297


                      l_select_eq := l_select_eq || ' ,A.SQUAL_NUM01, A.SQUAL_NUM02 ';

Line: 1298


                      l_select_like := l_select_like || ' ,A.SQUAL_NUM01, A.SQUAL_NUM02 ';

Line: 1299


                      l_select_btw := l_select_btw || ' ,A.SQUAL_NUM01, A.SQUAL_NUM02 ';

Line: 1400


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline
                     || l_predicate_like || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline;

Line: 1422


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq|| l_newline;

Line: 1428


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like || l_newline;

Line: 1434


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline;

Line: 1441


               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline;

Line: 1449


		    l_select_like := l_newline || g_select_list_1;

Line: 1452


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq || l_newline ||
                     'and Q1012R1.terr_id = Q1003R1.terr_id' || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like ||  l_newline ||
                     'and Q1012LK.terr_id = Q1007R1.terr_id' || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline ||
                     'and Q1012BT.terr_id = Q1003R1.terr_id' || l_newline;

Line: 1477


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq || l_newline ||
                     'and Q1012R1.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012R1.terr_id = Q1007R1.terr_id'|| l_newline;

Line: 1485


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like || l_newline ||
                     'and Q1012LK.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012LK.terr_id = Q1007R1.terr_id'|| l_newline;

Line: 1493


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline ||
                     'and Q1012LK.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012LK.terr_id = Q1007R1.terr_id'|| l_newline;

Line: 1502


               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline || l_newline ||
                     'and Q1012BT.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012BT.terr_id = Q1007R1.terr_id' || l_newline;

Line: 1529


               'SELECT /*+ use_concat no_merge */ A.*,ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners ';

Line: 1533


               'SELECT /*+ use_concat no_merge */ a.trans_object_id,a.trans_detail_object_id,a.worker_id,a.header_id1,a.header_id2,' ||
	       'ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners,ILV.org_id ' ;

Line: 1546


             p_sql := g_select_list_1;

Line: 1570


            p_sql := g_select_list_1;

Line: 1621


         SELECT DISTINCT jtqp.relation_product
               ,jtqf.qual_usg_id
               ,jqu.alias_rule1
               ,jqu.alias_op_like
               ,jqu.alias_op_between
               ,jqu.op_eql
               ,jqu.op_not_eql
               ,jqu.op_lss_thn
               ,jqu.op_lss_thn_eql
               ,jqu.op_grtr_thn
               ,jqu.op_grtr_thn_eql
               ,jqu.op_like
               ,jqu.op_not_like
               ,jqu.op_between
               ,jqu.op_not_between
               ,jqu.op_common_where
         FROM jtf_qual_usgs_all jqu,
               jtf_tae_qual_factors jtqf,
               jtf_tae_qual_products jtqp,
               jtf_tae_qual_prod_factors jtpf
         WHERE jqu.org_id = -3113
            AND jqu.qual_usg_id = jtqf.qual_usg_id
            and jtpf.qual_factor_id= jtqf.qual_factor_id
            and jtqp.qual_product_id = jtpf.qual_product_id
            and jtqp.relation_product = p_relation_product
            and jtqp.source_id = p_source_id
            and jtqp.trans_object_type_id= p_qual_type_id
            and jqu.op_not_eql is NULL
            and jqu.op_not_like is NULL
            and jqu.op_not_between is NULL
         ORDER BY jtqf.qual_usg_id;

Line: 1674


      l_select_eq          VARCHAR2(32767);

Line: 1675


      l_select_like        VARCHAR2(32767);

Line: 1676


      l_select_btw         VARCHAR2(32767);

Line: 1754


                   l_select_eq := l_newline || g_select_list_1;

Line: 1755


                   l_select_like := l_newline || g_select_list_1;

Line: 1756


   		           l_select_btw := l_newline || g_select_list_1;

Line: 1803


                  l_select_eq := l_newline || g_select_list_1;

Line: 1804


                  l_select_like := l_newline || g_select_list_1;

Line: 1805


                  l_select_btw := l_newline || g_select_list_1;

Line: 1906


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq ||  l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline;

Line: 1928


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq|| l_newline;

Line: 1934


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like || l_newline;

Line: 1940


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline;

Line: 1947


               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline;

Line: 1955


		    l_select_like := l_newline || g_select_list_1;

Line: 1958


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq || l_newline ||
                     'and Q1012R1.terr_id = Q1003R1.terr_id' || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like ||l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like || l_newline ||
                     'and Q1012LK.terr_id = Q1007R1.terr_id' || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline ||
               'UNION ALL' || l_newline ||
               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline ||
                     'and Q1012BT.terr_id = Q1003R1.terr_id' || l_newline;

Line: 1983


               l_select_eq || l_newline ||
                  l_from_str_eq || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_eq || l_newline ||
                     'and Q1012R1.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012R1.terr_id = Q1007R1.terr_id'|| l_newline;

Line: 1991


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_like || l_newline ||
                     'and Q1012LK.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012LK.terr_id = Q1007R1.terr_id' || l_newline;

Line: 1999


               l_select_like || l_newline ||
                  l_from_str_like || l_newline ||
                  l_where_str || l_newline ||
                     replace(l_predicate_like,'a.squal_fc01 = Q1012LK.first_char',
                           'Q1012LK.first_char= ''%''') || l_newline ||
                     'and Q1012LK.terr_id = Q1003R1.terr_id' || l_newline ||
                     'and Q1012LK.terr_id = Q1007R1.terr_id'||l_newline ;

Line: 2008


               l_select_btw || l_newline ||
                  l_from_str_btw || l_newline ||
                  l_where_str || l_newline ||
                     l_predicate_btw || l_newline || l_newline ||
                     'and Q1012BT.terr_id = Q1003R1.terr_id' || l_newline  ||
                     'and Q1012BT.terr_id = Q1007R1.terr_id'|| l_newline;

Line: 2023


            l_qual_rules := -- where's the 'select' clause?
               l_from_str || l_newline ||
               l_where_str || l_newline ||
                  l_predicate || l_newline || ';' ;

Line: 2030


               g_select_list_1 ||
               l_from_str || l_newline ||
               l_where_str || l_newline ||
                  l_predicate || l_newline;

Line: 2035


            l_qual_rules := -- where's the 'select' clause?
               l_from_str || l_newline ||
               l_where_str || l_newline ||
                  l_predicate || l_newline ||
                  'AND Q1004R1.terr_id = Q1003R1.terr_id AND Q1004R1.terr_id = Q1007R1.terr_id'
                  || l_newline || ';';

Line: 2044


               g_select_list_1 || l_newline || -- where's the 'from' clause?
               l_where_str || l_newline ||
                  l_predicate || l_newline ||
                  'AND Q1004R1.terr_id = Q1003R1.terr_id AND Q1004R1.terr_id = Q1007R1.terr_id'
                  || l_newline;

Line: 2118


                   Add_To_PackageTable (G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' );

Line: 2270


      Add_To_PackageTable (G_INDENT || '   SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ');

Line: 2388


             Add_To_PackageTable (G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' );

Line: 2539


      Add_To_PackageTable (G_INDENT || '   SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ');

Line: 2609


             Add_To_PackageTable (G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' );

Line: 2760


      Add_To_PackageTable (G_INDENT || '   SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ');

Line: 2824


             Add_To_PackageTable (G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' );

Line: 2975


      Add_To_PackageTable (G_INDENT || '   SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ');

Line: 3039


             Add_To_PackageTable (G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' );

Line: 3190


      Add_To_PackageTable (G_INDENT || '   SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ');

Line: 3276


            SELECT jtdr.terr_id, jtqu.qual_relation_product
              FROM jtf_terr_denorm_rules_all jtdr
	          ,jtf_terr_qtype_usgs_all jtqu
	          ,jtf_qual_type_usgs_all jqtu
                  ,jtf_changed_terr_all b
            WHERE jtdr.terr_id = jtdr.related_terr_id
              AND jtdr.terr_id= b.terr_id
              AND jqtu.source_id = jtdr.source_id
	      AND jqtu.qual_type_id = p_qual_type_id
	      AND jtdr.terr_id = jtqu.terr_id
              AND jtdr.source_id = p_source_id
	      AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id;

Line: 3306


              /* p_view_name is the name of the view from which deatils to be selected  */
              Build_Qualifier_Rules(p_source_id,p_qual_type_id,JTF_csr.qual_relation_product,p_view_name,'N',l_new_mode_fetch, l_sql,l_ilv2eq,l_ilv2lk,l_ilv2lkp,l_ilv2btwn);

Line: 3338


         SELECT DISTINCT jtqp.relation_product
         FROM jtf_tae_qual_products jtqp
         WHERE jtqp.source_id = lp_source_id
            AND jtqp.trans_object_type_id= lp_qual_type_id
         ORDER BY jtqp.relation_product DESC;

Line: 3419


      Add_To_PackageTable ('      SELECT jtqp.relation_product ');

Line: 3426


      Add_To_PackageTable ('      SELECT distinct jtdr.terr_id ');

Line: 3476


            add_insert_nmtrans(p_match_table_name);

Line: 3481


            Add_To_PackageTable ('         INSERT INTO  '|| p_match_table_name || ' i');

Line: 3491


            Add_To_PackageTable ('          , last_update_date');

Line: 3492


            Add_To_PackageTable ('          , last_updated_by');

Line: 3495


            Add_To_PackageTable ('          , last_update_login');

Line: 3499


            Add_To_PackageTable ('          , program_update_date');

Line: 3547


               add_select_nmtrans(p_match_table_name);

Line: 3559


                  Add_To_PackageTable ('         SELECT /*+ USE_CONCAT */ DISTINCT ');

Line: 3584


                  Add_To_PackageTable ('         SELECT /*+ USE_CONCAT */ DISTINCT ');

Line: 3688


         Add_To_PackageTable ('                     || '': # OF ROWS INSERTED = '' || SQL%ROWCOUNT;');

Line: 3700


         Add_To_PackageTable (G_INDENT1 || '                     || ''NO_DATA_FOUND: NO ROWS INSERTED.'';');

Line: 3794


      g_select_list_1 := k_select_list_fm;

Line: 3849


          SELECT COUNT(*)
          INTO num_of_combination
          FROM jtf_tae_qual_products jtqp
          WHERE jtqp.source_id = p_source_id
            AND jtqp.trans_object_type_id = p_trans_object_type_id;

Line: 3932


            ' SELECT uo.object_name, uo.object_type, uo.created, uo.last_ddl_time, uo.timestamp, uo.status' ||
            ' FROM user_objects uo' ||
            ' WHERE uo.object_type = ''PACKAGE BODY'' AND uo.object_name = :b1 and rownum < 2';

Line: 4057


      g_select_list_1 := k_select_list_nm;

Line: 4112


         SELECT COUNT(*)
         INTO num_of_combination
         FROM jtf_tae_qual_products jtqp
         WHERE jtqp.source_id = p_source_id
            AND jtqp.trans_object_type_id = p_trans_object_type_id;

Line: 4187


            ' SELECT uo.object_name, uo.object_type, uo.created, uo.last_ddl_time, uo.timestamp, uo.status' ||
            ' FROM user_objects uo' ||
            ' WHERE uo.object_type = ''PACKAGE BODY'' AND uo.object_name = :b1 and rownum < 2';

Line: 4306


      g_select_list_1 := k_select_list_fm;

Line: 4348


          SELECT COUNT(*)
          INTO num_of_combination
          FROM jtf_tae_qual_products jtqp
          WHERE jtqp.source_id = p_source_id
            AND jtqp.trans_object_type_id = p_trans_object_type_id;

Line: 4426


            ' SELECT uo.object_name, uo.object_type, uo.created, uo.last_ddl_time, uo.timestamp, uo.status' ||
            ' FROM user_objects uo' ||
            ' WHERE uo.object_type = ''PACKAGE BODY'' AND uo.object_name = :b1 and rownum < 2';

Line: 4567


      g_select_list_1 := k_select_list_fm;

Line: 4643


          SELECT COUNT(*)
          INTO num_of_combination
          FROM jtf_tae_qual_products jtqp
          WHERE jtqp.source_id = p_source_id
            AND jtqp.trans_object_type_id = p_trans_object_type_id;

Line: 4721


            ' SELECT uo.object_name, uo.object_type, uo.created, uo.last_ddl_time, uo.timestamp, uo.status' ||
            ' FROM user_objects uo' ||
            ' WHERE uo.object_type = ''PACKAGE BODY'' AND uo.object_name = :b1 and rownum < 2';