FND FLEXSQL - This user exits allows you to use Flex fields in Reports

Call this user exit to create a SQL fragment usable by your report to tailor your SELECT
statement that retrieves flexfield values. This fragment allows you to SELECT flexfield
values or to create a WHERE ORDER BY GROUP BY or HAVING clause to limit or
sort the flexfield values returned by your SELECT statement. You call this user exit once
for each fragment you need for your select statement. You define all flexfield columns in
your report as type CHARACTER even though your table may use NUMBER or DATE or
some other datatype.
Syntax:
FND FLEXSQL
CODE flexfield code
APPL_SHORT_NAME application short name
OUTPUT : output lexical parameter name
MODE { SELECT | WHERE | HAVING | ORDER BY}
[DISPLAY {ALL | flexfield qualifier | segment number} ]
[SHOWDEPSEG {Y | N} ]
[NUM : structure defining lexical |
MULTINUM {Y | N} ]
[TABLEALIAS code combination table alias ]
[OPERATOR { | < | > | < | > | ! | || |
BETWEEN | QBE} ]
[OPERAND1 : input parameter or value ]
[OPERAND2 : input parameter or value ]

e.g-

SRW.USER_EXIT('FND FLEXSQL CODE MSTK NUM :P_STRUCT_NUM DISPLAY ALL
APPL_SHORT_NAME INV OUTPUT :P_ITEM_FLEXDATA MODE SELECT TABLEALIAS msi ');

FND FLEXIDVAL - This user exits allows you to use Flex fields in Reports

Hi

Pls have look at my code here

SRW.REFERENCE(:STRUCT_NUM);
SRW.USER_EXIT('FND FLEXSQL
CODE GL#
APPL_SHORT_NAME SQLGL
OUTPUT :FLEXDATA
MODE SELECT
DISPLAY ALL
NUM :STRUCT_NUM
SHOWDEPSEG N
TABLEALIAS GCC ');
--
--ORDER BY
SRW.REFERENCE(:STRUCT_NUM);
SRW.USER_EXIT('FND FLEXSQL
CODE GL#
APPL_SHORT_NAME SQLGL
OUTPUT :CP_ORDERBY
MODE ORDER BY
DISPLAY 1
DISPLAY 3
DISPLAY 2
NUM :STRUCT_NUM
SHOWDEPSEG N
TABLEALIAS GCC ');

I am trying to se;ect Flex data and trying to order it by segment1 segment3 segment2.

But MODE ORDER BY is not making any difference.

It is displayng by ordering in segment1 segment2 segment3.segment4 segment5 segment6 as default order.could any one pls help .

Thanks

swapna