PJF_RESOURCE_CLASSES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
RESOURCE_CLASS_ID NAME DESCRIPTION RESOURCE_CLASS_CODE RESOURCE_CLASS_SEQ LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.RESOURCE_CLASS_ID RESOURCE_CLASS_ID, TL.NAME NAME, TL.DESCRIPTION DESCRIPTION, B.RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, B.RESOURCE_CLASS_SEQ RESOURCE_CLASS_SEQ, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM PJF_RESOURCE_CLASSES_B B, PJF_RESOURCE_CLASSES_TL TL WHERE B.Resource_Class_Id = TL.Resource_Class_Id And TL.Language = userenv('lang')