How to set SQL statement for a hidden parameter to get the value automatically.

Hi

There are  two parameter for a custom program.

parameter a

parameter b

value set <a> for Parameter a  is as below:

table name: OE_ORDER_HEADERS_ALL OOHA

value:OOHA.ORDER_NUMBER

where /order by

1=1

AND ORG_ID = (SELECT FND_PROFILE.VALUE('ORG_ID') FROM DUAL)

AND ORDER_TYPE_ID = NVL(:$FLEX$.ONT_MOAC_SRS_ORDER_TYPES:NULL, ORDER_TYPE_ID)

AND EXISTS (SELECT 1 FROM WSH_NEW_DELIVERIES WND WHERE WND.SOURCE_HEADER_ID = OOHA.HEADER_ID)

ORDER BY CREATION_DATE DESC

value set  <b> for parameter b is as below:

table name :(SELECT distinct wnd.name,wnd.delivery_id,wnd.source_header_id,ooh.order_number FROM WSH_NEW_DELIVERIES WND,OE_ORDER_HEADERS_ALL ooh WHERE 1=1 and WND.source_header_id=ooh.header_id)a