FFS_PLUGIN_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
PLUGIN_ID LABEL TYPE PATH POST_DATA PRIVILEGE_OBJECT_ID WIDTH HEIGHT OPTIONS USER_AGENT_MASK SORT_ORDER NATIVE_APP_LABEL ACTION_LINK_ID AUTH_TYPE AUTH_LOGIN AUTH_PASSWORD PLUGIN_HOSTED_ID SECURED_DATA NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.PLUGIN_ID PLUGIN_ID, b.LABEL LABEL, b.TYPE TYPE, b.PATH PATH, b.POST_DATA POST_DATA, b.PRIVILEGE_OBJECT_ID PRIVILEGE_OBJECT_ID, b.WIDTH WIDTH, b.HEIGHT HEIGHT, b.OPTIONS OPTIONS, b.USER_AGENT_MASK USER_AGENT_MASK, b.SORT_ORDER SORT_ORDER, b.NATIVE_APP_LABEL NATIVE_APP_LABEL, b.ACTION_LINK_ID ACTION_LINK_ID, b.AUTH_TYPE AUTH_TYPE, b.AUTH_LOGIN AUTH_LOGIN, b.AUTH_PASSWORD AUTH_PASSWORD, b.PLUGIN_HOSTED_ID PLUGIN_HOSTED_ID, b.SECURED_DATA SECURED_DATA, nvl (tl.NAME, b.LABEL) NAME, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from ffs_plugin b left join ffs_plugin_tl tl on b.PLUGIN_ID = tl.PLUGIN_ID and tl.LANGUAGE = USERENV('LANG')