Home » Applications » Oracle Fusion Apps & E-Business Suite » DFF
DFF [message #173451] Mon, 22 May 2006 09:00 Go to next message
APPSUSER
Messages: 17
Registered: January 2006
Junior Member
Dear All

To create 3 DFFs for usage in OM for order lines . The end user will enter the values in 1st and 2nd DFFs. 3 DFF should display the product (multiplication ) of the 1st and 2nd DFF. This is required in Om line orders. Is it possible to do so.?

Regards
Re: DFF [message #173454 is a reply to message #173451] Mon, 22 May 2006 09:09 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Where's the SQL (You have posted in the SQL Experts forum)? Is this an Applications question?

MHE
Re: DFF [message #173464 is a reply to message #173451] Mon, 22 May 2006 10:49 Go to previous message
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
Senior Member
I am not really sure of the point of doing this as you will just be duplicating information that already is in the table which is not exactly best practice, but if you still want to do this, you should be able to do this by using the $FLEX$.Value_Set_Name.

You should be able to do this either by using a table or special validated valueset.

For details refer to Chapter 4 Values and Value Sets in the Oracle Applications Flexfields Guide which is freely available for download from OTN.

--
Aleksander Dragnes
Previous Topic: Descriptive Flex filed
Next Topic: How ra_customer_trx_all linked with ra_customers
Goto Forum:
  


Current Time: Sun May 19 06:26:16 CDT 2024