APPS.GMF_FND_GET_SEGMENT_VAL SQL Statements

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

Line: 15

 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;

Line: 60

 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 ;