The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT VAL.start_date_active,
VAL.end_date_active,
FND.segment_name,
FND.segment_num,
VAL.flex_value,
VAL.description,
GLS.chart_of_accounts_id
FROM fnd_id_flex_segments FND,
gl_sets_of_books GLS,
fnd_flex_values_vl VAL
WHERE GLS.name = NVL(sobname,GLS.name)
AND GLS.chart_of_accounts_id = FND.id_flex_num
AND LOWER(FND.segment_name) = LOWER(NVL(segmentname,FND.segment_name))
AND FND.segment_num = NVL(segmentnum, FND.segment_num)
AND FND.enabled_flag = 'Y'
AND FND.flex_value_set_id = VAL.flex_value_set_id
AND VAL.enabled_flag = 'Y'
AND NVL(VAL.start_date_active,SYSDATE) <= NVL(startdate, SYSDATE)
AND NVL(VAL.end_date_active,SYSDATE) >= NVL(enddate, SYSDATE)
AND VAL.flex_value = NVL(segmentval, VAL.flex_value)
AND NVL(VAL.description,' ') = NVL(segmentdesc, NVL(VAL.description,' '))
--AND VAL.flex_value = GLU.ACCOUNT_SEGMENT_VALUE(+)
--AND nvl(GLU.chart_of_accounts_id, GLS.chart_of_accounts_id) = GLS.chart_of_accounts_id -- Bug# 1837544
AND VAL.summary_flag = 'N'
ORDER BY FND.segment_name,
FND.segment_num,
VAL.flex_value;
SELECT unit_of_measure
FROM gl_stat_account_uom
WHERE account_segment_value = acct_seg_val
AND chart_of_accounts_id = chart_of_accts_id ;