APPS.GMF_FND_GET_SEGMENT_DTL SQL Statements

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

Line: 8

      SELECT FND.segment_name,
             FND.segment_num,
        ATT.segment_attribute_type,
        ATT.attribute_value
        FROM fnd_id_flex_segments FND,
             gl_sets_of_books     GLS,
        fnd_segment_attribute_values ATT
       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 ATT.APPLICATION_ID       = FND.APPLICATION_ID
         AND ATT.ID_FLEX_CODE         = FND.ID_FLEX_CODE
         AND ATT.ID_FLEX_NUM          = FND.ID_FLEX_NUM
         AND ATT.APPLICATION_COLUMN_NAME = FND.APPLICATION_COLUMN_NAME
         AND ATT.SEGMENT_ATTRIBUTE_TYPE =  NVL(segmentattr_type,ATT.SEGMENT_ATTRIBUTE_TYPE )
         AND ATT.ATTRIBUTE_VALUE = NVL(attributevalue,ATT.ATTRIBUTE_VALUE);