Using the My Oracle Support Portal (MOSC)

MOSC Banner

Dynamic record group in Form Builder

edited Dec 20, 2016 4:04AM in Using the My Oracle Support Portal (MOSC) 1 commentAnswered

My requirement is I want to implement below query in Value set ,,those value set i want to use in my custom Form.

Query having 2 columns (FR-number, Rating) like below:

SELECT * FROM (select distinct a.ELEMENT_VALUE FR_NUMBER, b.ELEMENT_VALUE RATING

from MTL_DESCR_ELEMENT_VALUES_V a, MTL_DESCR_ELEMENT_VALUES_V b

where a.inventory_item_id = b.inventory_item_id

and a.ELEMENT_NAME = 'FR NUMBER'

and b.ELEMENT_NAME = 'RATING'

AND a.ELEMENT_VALUE NOT IN ('-')

order by A.ELEMENT_VALUE)

Please suggest me Solution ,

Thanks in Advance.

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