fnd flexsql in a report into SQL statement.

From: David Caudron <dcaudron_at_club-internet.fr>
Date: Fri, 24 Nov 2000 00:37:45 +0100
Message-ID: <3A1DAA49.2352D638_at_club-internet.fr>


Do somebody knows how this work ?
I found this in a program units of a reports which belong to Oracle Financial PO module.

I think tat it is used to check if values belong to a fork : seg1.seg2.seg3 between seg1inf and seg1sup, seg2inf and seg2sup, seg3inf and seg3sup.

Iwould like to convert it into a SQL statement.

  SRW.USER_EXIT('FND FLEXSQL CODE           ="MCAT"
                             OUTPUT         =":P_WHERE_CAT"
                             APPL_SHORT_NAME="INV"
                             MODE           ="WHERE"
                             DISPLAY        ="ALL"
                             NUM
=":P_STRUCT_NUM"
TABLEALIAS     ="MCA"
                             OPERATOR       ="BETWEEN"
                             OPERAND1       =":P_CATEGORY_FROM"
                             OPERAND2       =":P_CATEGORY_TO"');
Received on Fri Nov 24 2000 - 00:37:45 CET

Original text of this message