The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT application_column_name
FROM fnd_id_flex_segments ffs
WHERE application_id = 401 -- 'INV'
AND id_flex_code = 'MTLL'
AND id_flex_num = 101 -- 'STOCK_LOCATORS'
AND enabled_flag = 'Y'
AND display_flag = 'Y'
AND (application_column_name not in ('SEGMENT19','SEGMENT20')
OR p_compatibility = G_compatibility_mode_1158) --Added for bug#4345239
ORDER BY segment_num;
SELECT concatenated_segment_delimiter
FROM fnd_id_flex_structures
WHERE id_flex_code = 'MTLL'
AND ROWNUM = 1;
l_view_text := 'CREATE OR REPLACE VIEW WMS_ITEM_LOCATIONS_KFV AS SELECT';
l_view_text := l_view_text||' PROGRAM_ID, PROGRAM_UPDATE_DATE, PROJECT_ID, TASK_ID, PHYSICAL_LOCATION_ID, PICK_UOM_CODE, DIMENSION_UOM_CODE, LENGTH, WIDTH, HEIGHT, LOCATOR_STATUS, ';
l_view_text := l_view_text||' SUGGESTED_CUBIC_AREA, SUGGESTED_WEIGHT, LOCATION_SUGGESTED_UNITS, EMPTY_FLAG, MIXED_ITEMS_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,';