Segment Values Meaning

[ramk]

Hello all,

I am trying to find the meaning of the values that are being stored in GL_code_Combinations table. For example, segment1 stores the fund value, segment2 may store budget fiscal year.

Is there some kind of look up values for these.

Thanks for your time.

Ram

[siva sankar]

Hi,

Please check with following query.

SELECT DISTINCT(ffv.FLEX_VALUE),ffv.DESCRIPTION
FROM fnd_id_flex_segments fis,FND_FLEX_VALUES_vl ffv
WHERE fis.FLEX_VALUE_SET_ID=ffv.FLEX_VALUE_SET_ID
AND END_DATE_ACTIVE IS NULL
AND fis.SEGMENT_NAME=' key flexfield Segment name'

if any more queries please let me know.

Thanks & Regards,

Siva

[ramk]

Hello Siva,

Thank you for your reply. I was actually trying to find it from applications side, but this one also helped me.

Thank you for your time.

Ram