DBA Data[Home] [Help]

VIEW: APPS.ZPB_CURRENT_USER_V

Source

View Text - Preformatted

SELECT ROWID ROW_ID, BUSINESS_AREA_ID, LAST_LOGIN_DATE, USER_ID, SHADOW_ID, PERSONAL_AW from ZPB_USERS WHERE USER_ID = FND_GLOBAL.USER_ID and LAST_BUSAREA_LOGIN = 'Y'
View Text - HTML Formatted

SELECT ROWID ROW_ID
, BUSINESS_AREA_ID
, LAST_LOGIN_DATE
, USER_ID
, SHADOW_ID
, PERSONAL_AW
FROM ZPB_USERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND LAST_BUSAREA_LOGIN = 'Y'