The following lines contain the word 'select', 'insert', 'update' or 'delete':
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));
SELECT *
FROM mtl_system_items
WHERE
organization_id = org
AND inventory_item_id = id;
SELECT
stock_locator_control_code
INTO
L_Stock_Locator_Control_code
FROM
MTL_PARAMETERS
WHERE
organization_id = p_organization_id;
SELECT
code_combination_id
FROM gl_code_combinations
WHERE
code_combination_id = id;
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, '@');
SELECT *
FROM mtl_cycle_count_headers
WHERE
(cycle_count_header_id = ID
OR cycle_count_header_name= NAME);
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);
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;
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);
SELECT
inventory_item_id
FROM MTL_CYCLE_COUNT_ITEMS
WHERE
inventory_item_id = id
AND cycle_count_header_id = cchead;
SELECT
SUBINVENTORY
FROM MTL_CC_SUBINVENTORIES
WHERE
SUBINVENTORY = sub
AND cycle_count_header_id = CCId;
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;
UPDATE mtl_item_locations
SET subinventory_code = p_subinv
WHERE inventory_location_id = l_new_ccid
AND organization_id = P_Organization_Id ;
mdebug('Table is not Updated');
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);