PSC_COM_CC_RESOURCE_ACTIONS_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
RESOURCE_ACTION_ID ACTION_CODE RESOURCE_ID ACTION_ENDPOINT REQUIRED_PARAMETERS LANGUAGE SOURCE_LANG ACTION_NAME ACTION_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER AGENCY_ID MODULE_ID SEED_DATA_LOCK DELETED_FLAG SEED_DATA_SOURCE

Query

SQL_Statement

SELECT b.RESOURCE_ACTION_ID RESOURCE_ACTION_ID, b.ACTION_CODE ACTION_CODE, b.RESOURCE_ID RESOURCE_ID, b.ACTION_ENDPOINT ACTION_ENDPOINT, b.REQUIRED_PARAMETERS REQUIRED_PARAMETERS, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, tl.ACTION_NAME ACTION_NAME, tl.ACTION_DESCRIPTION ACTION_DESCRIPTION, 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.MODULE_ID MODULE_ID, b.SEED_DATA_LOCK SEED_DATA_LOCK , b.DELETED_FLAG DELETED_FLAG, b.SEED_DATA_SOURCE SEED_DATA_SOURCE FROM PSC_COM_CC_RESOURCE_ACTIONS_B b, PSC_COM_CC_RESOURCE_ACTIONS_TL tl WHERE b.RESOURCE_ACTION_ID = tl.RESOURCE_ACTION_ID AND tl.LANGUAGE = USERENV('LANG')