VIEW: APPS.WF_USERS

Source

View Text - Preformatted

( select WR.NAME, nvl(WRT.DISPLAY_NAME,
 WR.DISPLAY_NAME), nvl(WRT.DESCRIPTION, WR.DESCRIPTION),
 WR.NOTIFICATION_PREFERENCE, WR.LANGUAGE, WR.TERRITORY,
 WR.EMAIL_ADDRESS, WR.FAX, WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID,
 WR.PARENT_ORIG_SYSTEM, WR.PARENT_ORIG_SYSTEM_ID, WR.START_DATE,
 WR.STATUS, WR.EXPIRATION_DATE, WR.OWNER_TAG, WR.PARTITION_ID from
 wf_local_roles wr, wf_local_roles_tl wrt where (WR.PARTITION_ID = 1
 /* FND_USR and PER */ or (WR.PARTITION_ID IN (0,9) and WR.USER_FLAG =
 'Y')) /*Adhoc Users and HZ_PARTY Persons*/ and
 nvl(WR.EXPIRATION_DATE, sysdate+1) > sysdate and wr.orig_system =
 wrt.orig_system (+) and wr.orig_system_id = wrt.orig_system_id (+)
 and wr.name = wrt.name (+) and wr.partition_id = wrt.partition_id (+)
 and wrt.language (+) = userenv('LANG'))

View Text - HTML Formatted

( SELECT WR.NAME
, NVL(WRT.DISPLAY_NAME
, WR.DISPLAY_NAME)
, NVL(WRT.DESCRIPTION
, WR.DESCRIPTION)
, WR.NOTIFICATION_PREFERENCE
, WR.LANGUAGE
, WR.TERRITORY
, WR.EMAIL_ADDRESS
, WR.FAX
, WR.ORIG_SYSTEM
, WR.ORIG_SYSTEM_ID
, WR.PARENT_ORIG_SYSTEM
, WR.PARENT_ORIG_SYSTEM_ID
, WR.START_DATE
, WR.STATUS
, WR.EXPIRATION_DATE
, WR.OWNER_TAG
, WR.PARTITION_ID FROM WF_LOCAL_ROLES WR
, WF_LOCAL_ROLES_TL WRT
WHERE (WR.PARTITION_ID = 1 /* FND_USR
AND PER */ OR (WR.PARTITION_ID IN (0
, 9)
AND WR.USER_FLAG = 'Y')) /*ADHOC USERS
AND HZ_PARTY PERSONS*/ AND NVL(WR.EXPIRATION_DATE
, SYSDATE+1) > SYSDATE
AND WR.ORIG_SYSTEM = WRT.ORIG_SYSTEM (+)
AND WR.ORIG_SYSTEM_ID = WRT.ORIG_SYSTEM_ID (+)
AND WR.NAME = WRT.NAME (+)
AND WR.PARTITION_ID = WRT.PARTITION_ID (+)
AND WRT.LANGUAGE (+) = USERENV('LANG'))