PSC_COM_CC_RESOURCES_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
RESOURCE_ID RESOURCE_CODE RESOURCE_NAME RESOURCE_PATH ENABLED_FLAG DESCRIPTION LANGUAGE SOURCE_LANG SEED_DATA_LOCK DELETED_FLAG MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER AGENCY_ID OFFERING_ID EM_ENABLED

Query

SQL_Statement

SELECT b.RESOURCE_ID RESOURCE_ID, b.RESOURCE_CODE RESOURCE_CODE, tl.RESOURCE_NAME RESOURCE_NAME, b.RESOURCE_PATH RESOURCE_PATH, b.ENABLED_FLAG ENABLED_FLAG, tl.DESCRIPTION DESCRIPTION, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, b.SEED_DATA_LOCK SEED_DATA_LOCK , b.DELETED_FLAG DELETED_FLAG, b.MODULE_ID MODULE_ID, b.CREATED_BY CREATED_BY, b.CREATION_DATE CREATION_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, b.AGENCY_ID AGENCY_ID, b.OFFERING_ID OFFERING_ID, b.EM_ENABLED EM_ENABLED FROM PSC_COM_CC_RESOURCES_B b, PSC_COM_CC_RESOURCES_TL tl WHERE b.RESOURCE_ID = tl.RESOURCE_ID AND tl.LANGUAGE = USERENV('LANG')