APPS.JTF_TERRITORY_CUSTOM SQL Statements

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

Line: 49

      Select 1
        into l_dummy
        from jtf_terr_values jtv
       where jtv.terr_qual_id = p_Terr_Qual_Id and
             (         ( jtv.COMPARISON_OPERATOR IN ('!=', '<>') and jtv.low_value_char_id <> p_party_id )
                    or ( jtv.COMPARISON_OPERATOR = '='  and jtv.low_value_char_id =  p_party_id )
              )
              and rownum < 2;

Line: 78

      Select 1
        into l_dummy
        from jtf_terr_values jtv
       where jtv.terr_qual_id = p_Terr_Qual_Id and
             (         ( jtv.COMPARISON_OPERATOR = '<'  and jtv.low_value_char <  p_company_name )
                    or ( jtv.COMPARISON_OPERATOR = '<=' and jtv.low_value_char <= p_company_name )
                    or ( jtv.COMPARISON_OPERATOR = '<>' and jtv.low_value_char <> p_company_name )
                    or ( jtv.COMPARISON_OPERATOR = '='  and jtv.low_value_char =  p_company_name )
                    or ( jtv.COMPARISON_OPERATOR = '>'  and jtv.low_value_char >  p_company_name )
                    or ( jtv.COMPARISON_OPERATOR = '>=' and jtv.low_value_char >= p_company_name )
                    or (     UPPER(jtv.COMPARISON_OPERATOR) = 'BETWEEN'
                         and (   (p_company_name between jtv.low_value_char and jtv.high_value_char )
                              or (p_company_name like jtv.high_value_char )
                             )
                       )
                    or ( UPPER(jtv.COMPARISON_OPERATOR) = 'LIKE' and  p_company_name like jtv.low_value_char )
                    or ( UPPER(jtv.COMPARISON_OPERATOR) = 'NOT BETWEEN' AND
                         (p_company_name not between jtv.low_value_char and jtv.high_value_char )
                       )
                    or ( UPPER(jtv.COMPARISON_OPERATOR) = 'NOT LIKE'    and p_company_name not like jtv.low_value_char  )
              )
              and rownum < 2;

Line: 123

         ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         '   AND rownum < 2 ' ||
         '   AND :p_hierarchy_id IN (  ' ||
         '       SELECT hpr.subject_id ' ||
         '       FROM   hz_party_relationships hpr ' ||
         '       WHERE  hpr.party_relationship_type = ''SUBSIDIARY_OF'' ' ||
         '       START WITH hpr.object_id = jtv.low_value_char_id ' ||
         '       CONNECT BY hpr.object_id = PRIOR hpr.subject_id ' ||
         '       AND    hpr.party_relationship_type = ''SUBSIDIARY_OF'' ) ';

Line: 160

         ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         '    , hz_party_relationships hpr ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         '   AND hpr.subject_id = :p_partner_Id ' ||
         '   AND hpr.object_id = jtv.low_value_char_id ' ||
         '   AND hpr.party_relationship_type = ''PARTNER_OF'' ' ||
         '   AND rownum < 2 ';

Line: 194

         ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         '    , as_interests ai ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         '   AND ai.customer_id = :p_Party_Id ' ||
         '   AND ai.interest_type_id = jtv.interest_type_id ' ||
         '   AND ( NVL(jtv.primary_interest_code_id, -1) = -1 ' ||
         '        OR ai.primary_interest_code_id = jtv.primary_interest_code_id ) ' ||
         '   AND ( NVL(jtv.secondary_interest_code_id, -1) = -1 ' ||
         '        OR ai.secondary_interest_code_id = jtv.secondary_interest_code_id ) ' ||
         '   AND ai.interest_use_code = ''COMPANY_CLASSIFICATION'' ' ||
         '   AND rownum < 2 ';

Line: 230

         ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         '    , as_interests ai ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         '   AND ai.lead_id = :p_Lead_Id ' ||
         '   AND ai.interest_type_id = jtv.interest_type_id ' ||
         '   AND ( NVL(jtv.primary_interest_code_id, -1) = -1 ' ||
         '        OR ai.primary_interest_code_id = jtv.primary_interest_code_id ) '||
         '   AND ( NVL(jtv.secondary_interest_code_id, -1) = -1 ' ||
         '        OR ai.secondary_interest_code_id = jtv.secondary_interest_code_id ) ' ||
         '   AND ai.interest_use_code = ''LEAD_CLASSIFICATION'' ' ||
         '   AND rownum < 2 ';

Line: 269

        ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         '    , as_lead_lines al ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         ' AND al.lead_id = :p_Lead_Id ' ||
         ' AND al.interest_type_id = jtv.interest_type_id ' ||
         ' AND ( NVL(jtv.primary_interest_code_id, -1) = -1 ' ||
         '     OR al.primary_interest_code_id = jtv.primary_interest_code_id ) ' ||
         ' AND ( NVL(jtv.secondary_interest_code_id, -1) = -1 ' ||
         '     OR al.secondary_interest_code_id = jtv.secondary_interest_code_id) ' ||
         ' AND rownum < 2 ';

Line: 303

         ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         '    , as_sales_lead_lines asl ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         '   AND asl.sales_lead_id = :p_Sales_Lead_Id ' ||
         '   AND asl.interest_type_id = jtv.interest_type_id ' ||
         '   AND ( NVL(jtv.primary_interest_code_id, -1) = -1 ' ||
         '       OR asl.primary_interest_code_id = jtv.primary_interest_code_id ) ' ||
         '   AND ( NVL(jtv.secondary_interest_code_id, -1) = -1 ' ||
         '       OR asl.secondary_interest_code_id = jtv.secondary_interest_code_id ) ' ||
         '   AND rownum < 2 ';

Line: 338

         ' SELECT 1 ' ||
         ' FROM jtf_terr_values jtv ' ||
         '    , as_lead_lines al ' ||
         ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
         '   AND al.Lead_id = :p_Lead_Id ' ||
         '   AND al.inventory_item_id = jtv.low_value_char_id ' ||
         '   AND rownum < 2 ';