APPS.INV_LOT_SERIAL_DATE_PKG SQL Statements

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

Line: 243

   SELECT application_id INTO l_application_id
     FROM fnd_application WHERE application_short_name='INV';

Line: 318

         SELECT organization_code INTO text_value
         FROM mtl_parameters
         WHERE to_char(organization_id) = SUBSTR(context, 1, (INSTR(context, '+-?*', 1, 1)-1)) ;

Line: 326

         SELECT concatenated_segments INTO text_value
         FROM mtl_system_items_kfv
         WHERE to_char(organization_id) = SUBSTR(context, 1, (INSTR(context, '+-?*', 1, 1)-1))
         AND to_char(inventory_item_id) = SUBSTR(context, (INSTR(context, '+-?*', 1, 1)+4), INSTR(context, '+-?*', 1, 2) - (INSTR(context, '+-?*', 1, 1)+4));

Line: 335

         SELECT category_concat_segs INTO text_value
         FROM mtl_categories_v
         WHERE to_char(category_id) = SUBSTR(context, (INSTR(context, '+-?*', 1, 2)+4), INSTR(context, '+-?*', 1, 3) - (INSTR(context, '+-?*', 1, 2)+4));