FND Design Data [Home] [Help]

View: GR_LABEL_CLASS_RESPS_V

Product: GR - Process Manufacturing Regulatory Management
Description: Contains the rows for the label class responsibility code.
Implementation/DBA Data: ViewAPPS.GR_LABEL_CLASS_RESPS_V
View Text

SELECT R.ROWID ROW_ID
, R.LABEL_CLASS_CODE
, R.APPLICATION_ID
, R.RESPONSIBILITY_ID
, F.RESPONSIBILITY_NAME
, R.DISPLAY_SEQUENCE
, R.ALLOW_CREATE_UPDATE
, F.LANGUAGE
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
FROM FND_RESPONSIBILITY_TL F
, GR_LABEL_CLASS_RESPS R
WHERE R.APPLICATION_ID = F.APPLICATION_ID
AND R.RESPONSIBILITY_ID = F.RESPONSIBILITY_ID
AND F.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
LABEL_CLASS_CODE
APPLICATION_ID
RESPONSIBILITY_ID
RESPONSIBILITY_NAME
DISPLAY_SEQUENCE
ALLOW_CREATE_UPDATE
LANGUAGE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN