APPS.WF_WORKLIST_ENGINE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

 Modeled the following views and selects

create or replace force view WF_WORKLIST_V
(
ROW_ID,
NID,
PRIORITY,
MESSAGE_TYPE,
RECIPIENT_ROLE,
LOCKED_BY,
SUBJECT,
BEGIN_DATE,
DUE_DATE,
END_DATE,
DISPLAY_STATUS,
STATUS,
ORIGINAL_RECIPIENT,
ITEM_TYPE,
MESSAGE_NAME
) as select
  WN.ROWID,
  WN.NOTIFICATION_ID,
  WN.PRIORITY,
  WIT.DISPLAY_NAME,
  WN.RECIPIENT_ROLE,
  WN.LOCKED_BY,
  Wf_Notification.GetSubject(notification_id),
  WN.BEGIN_DATE,
  WN.DUE_DATE,
  WN.END_DATE,
  WL.MEANING,
  WN.STATUS,
  WN.ORIGINAL_RECIPIENT,
  WN.MESSAGE_TYPE,
  WN.MESSAGE_NAME
 from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
 where WN.MESSAGE_TYPE = WIT.NAME
  and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
  and WN.STATUS = WL.LOOKUP_CODE;

Line: 52

select MA1.FORMAT
 from  WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES MA1
 where WN.MESSAGE_TYPE in ('WFDEMO')
 and   WN.MESSAGE_TYPE = MA1.MESSAGE_TYPE (+)
 and   WN.MESSAGE_NAME = MA1.MESSAGE_NAME (+)
 and   MA1.NAME (+) = 'RESULT';

Line: 60

select NA1.TEXT_VALUE
 from  WF_NOTIFICATIONS WN, WF_NOTIFICATION_ATTRIBUTES NA1
 where WN.MESSAGE_TYPE in ('WFDEMO')
 and   WN.NOTIFICATION_ID = NA1.NOTIFICATION_ID (+)
 and   NA1.NAME (+) = 'DOC_OWNER_ROLE';

Line: 87

    select ROLE_NAME
    from   WF_USER_ROLES
    where  USER_ORIG_SYSTEM    = osys
    and    USER_ORIG_SYSTEM_ID = osysid
    and    USER_NAME           = uname;