APPS.MTL_INV_VALIDATE_GRP SQL Statements

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

Line: 83

     select calendar_date
     from bom_calendar_dates
     where calendar_code = p_calendar_code
     and exception_set_id = p_exception_set_id
     and seq_num in
     (select seq_num + p_offset_days
     from bom_calendar_dates
     where calendar_code = p_calendar_code
     and exception_set_id = p_exception_set_id
     and next_date = trunc(p_start_date));

Line: 228

          SELECT *
          FROM mtl_system_items
       WHERE
          organization_id = org
          AND inventory_item_id = id;

Line: 292

       SELECT
          stock_locator_control_code
       INTO
          L_Stock_Locator_Control_code
       FROM
          MTL_PARAMETERS
       WHERE
          organization_id = p_organization_id;

Line: 368

          SELECT
          code_combination_id
          FROM gl_code_combinations
       WHERE
          code_combination_id = id;

Line: 405

          SELECT
          code_combination_id
          FROM gl_code_combinations
       WHERE
          NVL(segment1, '@') = NVL(seg1, '@')
          AND NVL(segment2, '@') = NVL(seg2, '@')
          AND NVL(segment3, '@') = NVL(seg3, '@')
          AND NVL(segment4, '@') = NVL(seg4, '@')
          AND NVL(segment5, '@') = NVL(seg5, '@')
          AND NVL(segment6, '@') = NVL(seg6, '@')
          AND NVL(segment7, '@') = NVL(seg7, '@')
          AND NVL(segment8, '@') = NVL(seg8, '@')
          AND NVL(segment9, '@') = NVL(seg9, '@')
          AND NVL(segment10, '@') = NVL(seg10, '@')
          AND NVL(segment11, '@') = NVL(seg11, '@')
          AND NVL(segment12, '@') = NVL(seg12, '@')
          AND NVL(segment13, '@') = NVL(seg13, '@')
          AND NVL(segment14, '@') = NVL(seg14, '@')
          AND NVL(segment15, '@') = NVL(seg15, '@')
          AND NVL(segment16, '@') = NVL(seg16, '@')
          AND NVL(segment17, '@') = NVL(seg17, '@')
          AND NVL(segment18, '@') = NVL(seg18, '@')
          AND NVL(segment19, '@') = NVL(seg19, '@')
          AND NVL(segment20, '@') = NVL(seg20, '@')
          AND NVL(segment21, '@') = NVL(seg21, '@')
          AND NVL(segment22, '@') = NVL(seg22, '@')
          AND NVL(segment23, '@') = NVL(seg23, '@')
          AND NVL(segment24, '@') = NVL(seg24, '@')
          AND NVL(segment25, '@') = NVL(seg25, '@')
          AND NVL(segment26, '@') = NVL(seg26, '@')
          AND NVL(segment27, '@') = NVL(seg27, '@')
          AND NVL(segment28, '@') = NVL(seg28, '@')
          AND NVL(segment29, '@') = NVL(seg29, '@')
          AND NVL(segment30, '@') = NVL(seg30, '@');

Line: 853

          SELECT *
          FROM mtl_cycle_count_headers
       WHERE
          (cycle_count_header_id = ID
             OR cycle_count_header_name= NAME);

Line: 1064

          SELECT *
          FROM mtl_cycle_count_entries
       WHERE
          cycle_count_header_id = ID
          AND organization_id = org
          AND count_list_sequence= seq
          AND entry_status_code IN(1, 2, 3);

Line: 1468

          SELECT
          location_control_code,
          serial_number_control_code,
          revision_qty_control_code,
          lot_control_code FROM mtl_system_items
       WHERE
          inventory_item_id = id
          and organization_id = org;

Line: 1782

          SELECT
          UOM_CODE
          FROM mtl_item_uoms_view
       WHERE
          organization_id = org
          AND inventory_item_id = itemid
          AND(uom_code = code OR
             unit_of_measure = name);

Line: 1973

          SELECT
          inventory_item_id
          FROM MTL_CYCLE_COUNT_ITEMS
       WHERE
          inventory_item_id = id
          AND cycle_count_header_id = cchead;

Line: 2654

          SELECT
          SUBINVENTORY
          FROM MTL_CC_SUBINVENTORIES
       WHERE
          SUBINVENTORY = sub
          AND cycle_count_header_id = CCId;

Line: 3234

          SELECT count(segment_num) into L_n_segments from
          fnd_id_flex_segments
          where application_id = 401
          and id_flex_code = L_key_flex_code
          and enabled_flag = 'Y'
          order by segment_num;

Line: 3324

	     UPDATE mtl_item_locations
	       SET subinventory_code = p_subinv
	       WHERE inventory_location_id = l_new_ccid
	       AND   organization_id = P_Organization_Id ;

Line: 3330

   		mdebug('Table is not Updated');

Line: 3416

      SELECT uom_code
        FROM mtl_item_uoms_view
       WHERE organization_id = org
         AND inventory_item_id = itemid
         AND (uom_code = code OR unit_of_measure = NAME);