APPS.HXC_OTL_INFO_TYPE_HELPER SQL Statements

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

Line: 26

        select max(to_number(substrb(descriptive_flex_context_code,
                                     instr(descriptive_flex_context_code,'-')+2)))
          from fnd_descr_flex_contexts_vl
         where descriptive_flexfield_name = 'OTC Information Types'
           and application_id = 809
           and  substrb(descriptive_flex_context_code,0,
                        instr(descriptive_flex_context_code,'-')-2)
                =substrb(descriptive_flex_context_name,0,
                         instr(descriptive_flex_context_name,'-')-2)||'C';