Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Report not displaying based on the static list selection

Pritam DasNov 8 2021

Hi Expert,
We are trying to display report based on static list for that we have created two item of static list, one for selecting module name and another one is object name which is based on the module name.
Let suppose if module name is AR then object name will be based on that module .
Now we have report which will display based on the object name selection,unfortunately that report is displaying based on the Object name.

Below is my SQL code
Module name query: select module_name,module_id "return" from abc_MODULES
Object name query: select object_name,object_id from abc_OBJECTS where module_id=:P6_NEW_1(Module name parameter)
Report query: select MODULE_ID,
MODULE_NAME,
OBJECT_ID,
OBJECT_NAME,
VALIDATION_RULE,
ENABLED_FLAG
from ABC_VALIDATION_LISTS
WHERE OBJECT_NAME=:P6_NEW_2(Object name paramter)

Comments

Processing

Post Details

Added on Nov 8 2021
0 comments
67 views