SELECT A.ACCESS_ID , B.NOTIFICATION_ID , B.NAME , B.TEXT_VALUE , B.NUMBER_VALUE , B.DATE_VALUE FROM JTM_WF_NOTIFICATION_AT_ACC A , WF_NOTIFICATION_ATTRIBUTES B WHERE A.NOTIFICATION_ID = B.NOTIFICATION_ID AND A.NAME = B.NAME AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
SELECT A.ACCESS_ID
, B.NOTIFICATION_ID
, B.NAME
, B.TEXT_VALUE
, B.NUMBER_VALUE
, B.DATE_VALUE
FROM JTM_WF_NOTIFICATION_AT_ACC A
, WF_NOTIFICATION_ATTRIBUTES B
WHERE A.NOTIFICATION_ID = B.NOTIFICATION_ID
AND A.NAME = B.NAME
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
|
|
|