SELECT b.task_id, b.object_id, b.position, b.value
FROM wri$_adv_sqlt_binds b, wri$_adv_objects o, wri$_adv_tasks t
WHERE b.object_id = o.id and b.task_id = o.task_id and o.task_id = t.id and
t.owner# = SYS_CONTEXT('USERENV', 'CURRENT_USERID')
SELECT B.TASK_ID
, B.OBJECT_ID
, B.POSITION
, B.VALUE
FROM WRI$_ADV_SQLT_BINDS B
, WRI$_ADV_OBJECTS O
, WRI$_ADV_TASKS T
WHERE B.OBJECT_ID = O.ID
AND B.TASK_ID = O.TASK_ID
AND O.TASK_ID = T.ID AND
T.OWNER# = SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')
|
|
|