[Home] [Help]
View: PSB_WS_SERVICE_PKG_PROFILES_V
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT WUP.ROWID
, WUP.WORKSHEET_ID
, WUP.PROFILE_TYPE
, WUP.USER_ID
, WUP.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, SP.NAME
, SP.PRIORITY
, WUP.LAST_UPDATE_DATE
, WUP.LAST_UPDATED_BY
, WUP.LAST_UPDATE_LOGIN
, WUP.CREATED_BY
, WUP.CREATION_DATE
FROM PSB_WS_USER_PROFILES WUP
, PSB_SERVICE_PACKAGES SP
WHERE WUP.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WUP.PROFILE_TYPE = 'S'
Columns
Name |
ROW_ID |
WORKSHEET_ID |
PROFILE_TYPE |
USER_ID |
SERVICE_PACKAGE_ID |
SERVICE_PACKAGE_SHORT_NAME |
SERVICE_PACKAGE_NAME |
PRIORITY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |