I have simple Classic Report (Apex 4.2.4) with two columns. One is from master table and shows ID; other column is LOV that contains names from detail table, which have FK to master table.
Tables structure:
master_table(id NUMBER);
detail_table(detail_name VARCHAR2(50), master_id NUMBER);
Report source looks like:
select
id,
null lov_column
from master_table;
lov_column is set as a Query based LOV, and query looks like:
select detail_name from detail_table
where master_id = #ID#
But application does not recognise #ID# values?! I can use it without WHERE statement, but in this case in LOV i got all records, and I want in one record have only values for this ID.
What can I do?
Thanx in advance.