Technology Stack - EBS (MOSC)

MOSC Banner

Flexfield value set in Flexfield value set

edited May 10, 2013 1:16PM in Technology Stack - EBS (MOSC) 1 commentAnswered
Hi Guru's,
I created conccurent program (Report) with these parameters.

Sample data in database
SUBINV    LOCATOR1             FLAG
SUB01       A01                100
SUB01       A02                200
SUB02       B01                100
SUB02       B02                300
SUB02       C01                500
SUB03       C02                100

Created 4 Flexfield value set
XX01 : as subinv column
XX02 : as flag value
XX03 : as from locator1 value
XX04 : as to locator1 value

How to create the logic in the flexfield value set with this condition
1. If XX01 = null then shows all locators value (XX03 and XX04)
2. IF XX01=A01, then shows all locators value (XX03 and XX04) with subinv = A01
3. IF XX01=A01, and XX03=100, then shows all locators value (XX03 and XX04) with subinv = A01 and FLAG = 100

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center