SQL Query to find process tasks in process definition of a Resource Object

SELECT MIL.MIL_NAME,EVT.EVT_NAME,OBJ.OBJ_NAME FROM OBJ JOIN PKG ON  PKG.OBJ_KEY=OBJ.OBJ_KEY JOIN TOS ON TOS.PKG_KEY=PKG.PKG_KEY JOIN MIL ON
MIL.TOS_KEY=TOS.TOS_KEY  LEFT OUTER JOIN EVT ON MIL.EVT_KEY=EVT.EVT_KEY
WHERE OBJ.OBJ_NAME='OUDAppInstance';

No comments:

Post a Comment

About OIM

Oracle Identity Management enables organizations to effectively manage the end - to - end life - cycle of user ide...

Popular Posts