Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows for the label class responsibility code. |
Implementation/DBA Data: | APPS.GR_LABEL_CLASS_RESPS_V |
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')