Fusion Apps - How To Create Dependent User Defined LOV In ESS Job Using SQL Query
(Doc ID 2566254.1)
Last updated on FEBRUARY 05, 2021
Applies to:Oracle Fusion Manufacturing Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.
Developers have a requirement where they have to create a dependent LOV based
on the first LOV selected, using SQL queries.
Example: They have below 2 parameters to be defined.
1. Shipment Number
2. Licence plate (Package) number for that shipment no.
When a specific 'Shipment number' is selected for the 1st parameter, then the
second parameter 'Licence plate' should display values that are related to
that shipment number.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document