DBA Data[Home] [Help]

VIEW: APPS.GR_LABEL_CLASS_RESPS_V

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')