PER_PORTRAIT_CONTENT_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PORTRAIT_CONTENT_ITEM_KEY PORTRAIT_CARD_FLAG ALLOW_USER_CONTROL_FLAG PARENT_CONTENT_ITEM_KEY DEFAULT_MANAGER_VISIBLE DEFAULT_CONNECTIONS_VISIBLE DEFAULT_EVERYONE_VISIBLE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION PORTRAIT_CONTENT_ITEM_NAME MODULE_ID ENTERPRISE_ID DISPLAY_CARD_IN_PORTRAIT CARD_ORDER PORTRAIT_CARD_NUMBER PORTRAIT_ADMIN_FLAG DEFAULT_CARD PORTRAIT_CONTENT_ID

Query

SQL_Statement

SELECT B.PORTRAIT_CONTENT_ITEM_KEY, B.PORTRAIT_CARD_FLAG, B.ALLOW_USER_CONTROL_FLAG, B.PARENT_CONTENT_ITEM_KEY, B.DEFAULT_MANAGER_VISIBLE, B.DEFAULT_CONNECTIONS_VISIBLE, B.DEFAULT_EVERYONE_VISIBLE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.DESCRIPTION DESCRIPTION, T.PORTRAIT_CONTENT_ITEM_NAME, B.MODULE_ID, B.ENTERPRISE_ID, B.DISPLAY_CARD_IN_PORTRAIT, B.CARD_ORDER, B.PORTRAIT_CARD_NUMBER, B.PORTRAIT_ADMIN_FLAG, B.DEFAULT_CARD, B.PORTRAIT_CONTENT_ID FROM PER_PORTRAIT_CONTENT_B B, PER_PORTRAIT_CONTENT_TL T WHERE B.PORTRAIT_CONTENT_ID = T.PORTRAIT_CONTENT_ID AND T.LANGUAGE = USERENV('LANG')