[Home] [Help]
View: WSH_GRANTS_V
Product: | WSH - Shipping Execution |
Description: | |
Implementation/DBA Data: |
APPS.WSH_GRANTS_V
|
View Text
SELECT G.ROWID
, G.GRANT_ID
, G.USER_ID
, F.USER_NAME
, R.ROLE_ID
, R.NAME
, R.DESCRIPTION
, O.ORGANIZATION_ID
, O.ORGANIZATION_CODE
, O.ORGANIZATION_NAME
, G.START_DATE
, G.END_DATE
, G.CREATED_BY
, G.CREATION_DATE
, G.LAST_UPDATED_BY
, G.LAST_UPDATE_DATE
, G.LAST_UPDATE_LOGIN FROM WSH_GRANTS G
, FND_USER F
, WSH_ROLES R
, ORG_ORGANIZATION_DEFINITIONS O
WHERE G.USER_ID = F.USER_ID AND G.ROLE_ID = R.ROLE_ID AND G.ORGANIZATION_ID = O.ORGANIZATION_ID(+)
Columns
Name |
ROW_ID |
GRANT_ID |
USER_ID |
USER_NAME |
ROLE_ID |
ROLE_NAME |
ROLE_DESCRIPTION |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
START_DATE |
END_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |