A query-based parameter uses a select command to retrieve a value at runtime. The values are shown in a list of value (LOV) in A.60.71.
Enter the Parameter name, Short Description and Description for the new parameter. Choose System (ORACLE Reports) as Parameter Type and the Data Type and Query Type Query.
In the Command field, enter the query for the parameter. The Query must have two columns; the first one will pass to the report.
At the end of the query you can enter a comment by using /* and */ . The text in the comment is used as the title of the list of value in A.60.71.