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>
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