HOW TO make flexfield fields dependent on anotherThis is a featured page

Platform: Oracle App: Application Object Library Tool:
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver:
Revision Date: 26-Oct-2005 Keywords: HOWTO, FLEXFIELD, SEGMENT, DEPENDENT

Goal
To make one flexfield segment dependent on the value of another segment

Facts


Solution

This is specifically for dependency between flexfield segments that use table validated value sets. The requirement is illustrated in the example below:

Flexfield segment1 = Warehouse
Flexfield segment2 = Location within Warehouse selected as segment1

The dependency between the flexfield segments is actually a dependency between the value sets used by the flexfield segments.

1. Set up the 1st value set that the dependent value set will be dependent upon. (e.g. XX_WAREHOUSE_VS)
2. In the dependent value set (e.g. XX_LOCATIONS_VS), use the following in the WHERE clause to reference it:

AND warehouse =:$FLEX$.XX_WAREHOUSE_VS
It is the:$FLEX$.XX_WAREHOUSE_VS that references the value selected in the previous flexfield segment.



consultium
consultium 		Latest page update: made by consultium , Oct 6 2009, 12:10 PM EDT (about this update About This Update consultium Migration of consultium wiki - consultium

145 words added

view changes
- complete history)
Keyword tags: FLEXFIELDS HOW TO
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
HOW TO programmatically launching concurrent request sets HOW TO simulate DISTINCT or GROUP BY in a value set HOW TO find the DFFs for a given table
HOW TO find all profile option values HOW TO find DFFs that use a particular value set HOW TO reference profile values from value sets
HOW TO trace a concurrent program HOW TO use personalize for simple customizations HOW TO setup a printer driver