VIEW: APPS.PA_RESOURCE_CLASSES_VL

Source

View Text - Preformatted

SELECT B.rowid row_id, B.resource_class_id, B.resource_class_code, B.resource_class_seq, B.last_update_date, B.last_updated_by, B.creation_date, B.created_by, B.last_update_login, T.name, T.description from PA_RESOURCE_CLASSES_TL T, PA_RESOURCE_CLASSES_B B WHERE B.resource_class_id = T.resource_class_id and T.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RESOURCE_CLASS_ID
, B.RESOURCE_CLASS_CODE
, B.RESOURCE_CLASS_SEQ
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.NAME
, T.DESCRIPTION
FROM PA_RESOURCE_CLASSES_TL T
, PA_RESOURCE_CLASSES_B B
WHERE B.RESOURCE_CLASS_ID = T.RESOURCE_CLASS_ID
AND T.LANGUAGE = USERENV('LANG')