My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.