Deepak

• Mar 1st, 2006

 

 

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

Call this user exit to populate fields for display. You pass the key flexfields data retrieved
by the query into this exit from the formula column. With this exit you display values,
descriptions and prompts by passing appropriate token (any one of VALUE,
DESCRIPTION, APROMPT or LPROMPT).
Syntax:
FND FLEXIDVAL
CODE=? flexfield code?
APPL_SHORT_NAME=? application short name?
DATA=?: source column name?
[NUM=?: structure defining source column/lexical?]
[DISPLAY=?{ALL| flexfield qualifier| segment number}?]
[IDISPLAY=?{ALL| flexfield qualifier| segmentnumber}?]
[SHOWDEPSEG=?{Y | N}?]
[VALUE=?: output column name?]
[DESCRIPTION=?: output column name?]
[APROMPT=?: output column name?]
[LPROMPT=?: output column name?]
[PADDED_VALUE=?: output column name?]
[SECURITY=?: column name?]

Reddy

• Oct 24th, 2006

 

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

samir_mandal78

 Profile Answers by samir_mandal78 

• Jan 21st, 2008

 

Dear swapna,

Go to data model and please arrange your fields according to your required order.

Thanks
Samir