How to invoke another form in oracle apps form?

In Oracle Applications, we can use FND_FUNCTION.EXECUTE instead of CALL_FORM / OPEN_FORM

Syntax

FND_FUNCTION.EXECUTE
                    (function_name  IN varchar2,
                     open_flag      IN varchar2 default ’Y’,
                     session_flag   IN varchar2 default ’SESSION’,
                     other_params   IN varchar2 default NULL,
                     activate       IN varchar2 default ’ACTIVATE’,
                     browser_target IN varchar2 default NULL);



Description

Execute the specified form function; only executes functions that have a form attached.

Arguments

 
Example
 

How do use the same LOV for 2 form fields?

We can achieve by passing the return values in global values / parameters and using the values in the code.

in another way ... we can create the diff LOV with the same Record groups