1. Tables and Views for Sales and Fusion Service
  2. CSO_USER_ATTRIBUTES_V

CSO_USER_ATTRIBUTES_V

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: VIEW

Columns

Name

RECORD_ID

ALIAS

CREATED_BY

DATE_ADDED

DATE_MODIFIED

DEFAULT_SUB_SITE_ID

EXTERNAL_ID

LAST_UPDATED_BY

LOCALE_ID

LOOKUP_CODE_ID

PDIT_CHALLENGE

RECEIVE_ASSIGNED

RECEIVE_PERFORM

REPUTATION_POINTS

SUBSCRIPTION_SCHEDULE

USER_LEVEL

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

ui.PARTY_ID AS RECORD_ID,

ui.ALIAS,

ui.CREATED_BY,

ui.DATE_ADDED,

ui.DATE_MODIFIED,

ui.DEFAULT_SUB_SITE_ID,

ui.EXTERNAL_ID,

ui.LAST_UPDATED_BY,

ui.LOCALE_ID,

NVL2(ui.LOOKUP_CODE_ID, ui.LOOKUP_CODE_ID, CAST(null AS varchar2(32))) AS LOOKUP_CODE_ID,

ui.PDIT_CHALLENGE,

ui.RECEIVE_ASSIGNED,

ui.RECEIVE_PERFORM,

ui.REPUTATION_POINTS,

ui.SUBSCRIPTION_SCHEDULE,

ui.USER_LEVEL,

ui.CREATION_DATE,

ui.LAST_UPDATE_DATE,

ui.LAST_UPDATE_LOGIN

FROM

CSO_USER_ATTRIBUTES ui