--3 click the lov object activing last query address.
SELECT T.SQL_TEXT
FROM V$SQLTEXT_WITH_NEWLINES T, V$SESSION S
WHERE 1 = 1 AND S.PREV_SQL_ADDR = T.ADDRESS
AND S.SID = &P_SID --369
ORDER BY T.PIECE
--concatenate each row.
select wip_entity_id, wip_entity_name, description
from wip_discrete_jobs_all_v
where (WIP_ENTITY_NAME LIKE :1) AND ( organization_id = :2 ) order by wip_entity_name
