BOM flexfield

[venkat_mel]

hi,

i have a requirement where i need to display flexfield information.
which table stores this information.
also need to display segment description in GL. how to do that.
can plz anyone help me

thanks,
venkat

[arun1203]

Hi Venkat,

If you want to print the flex field information in Oracle Reports you can use the user exit <font color="red"><b>FND FLEXSQL</b></font id="red">.

I'm giving you a small example of how to use this user exit.
<font color="red"><b>
SRW.User_Exit(?FND FLEXSQL
APPL_Short_Name=?GL?
Code=?GL#?
NUM=?:P_Struct_Num?

Output=?:P_FlexData?
Mode=?Select?
Display=?All? ?);
</b></font id="red">

Pass the parameters as required and you will get the flex field information.

The tables where flexfields are stored are as follows:

<font color="red"><b>Key Flex Fields:
1.fnd_flex_values_tl,
2.fnd_id_flex_segment,
3.fnd_flex_value_sets,
4.fnd_id_flex_structure,
5.fnd_id_flexs</b></font id="red">


<font color="red"><b>Descriptive Flex Fields:
1.FND_DESCRIPTIVE_FLEXS,
2. FND_DESCR_FLEX_CONTEXT,
3. FND_DESCR_FLEX_COLUMN_USAGES</b></font id="red">

<font color="blue"><b>Best Regards & Thanks,
Arun Reddy</b></font id="blue">