ATK_USAGE_LOGS_V

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name
LOG_ID USER_NAME ACTIVITY_CODE ACTIVITY_NAME ACTIVITY_DESCRIPTION ACTIVITY_VALUE FLOW_CODE FLOW_NAME FLOW_DESCRIPTION SESSION_ID USER_ACTIVITY_TIME PAGE_URL USER_AGENT LOCALE LOG_LANGUAGE ACCESS_MODE VIEW_ID TASKFLOW_ID TASKFLOW_VIEWID USER_ID PRODUCT_NAME PRODUCT_DESCRIPTION LANGUAGE_CODE ACTIVITY_LOOKUP_TYPE ACTIVITY_LOOKUP_CODE MODULE_ID FLOW_LOOKUP_TYPE FLOW_LOOKUP_CODE

Query

SQL_Statement

SELECT USAGE_LOG.LOG_ID, USAGE_LOG.CREATED_BY USER_NAME, USAGE_LOG.ACTIVITY_CODE, 'NULL' ACTIVITY_NAME, 'NULL' ACTIVITY_DESCRIPTION, USAGE_LOG.ACTIVITY_VALUE, FLOW.FLOW_CODE FLOW_CODE, 'NULL' FLOW_NAME, 'NULL' FLOW_DESCRIPTION, USAGE_LOG.SESSION_ID, USAGE_LOG.USER_ACTIVITY_TIME, USAGE_LOG.PAGE_URL, USAGE_LOG.USER_AGENT, USAGE_LOG.LOCALE, USAGE_LOG.LOG_LANGUAGE, USAGE_LOG.ACCESS_MODE, USAGE_LOG.VIEW_ID, USAGE_LOG.TASKFLOW_ID, USAGE_LOG.TASKFLOW_VIEWID, USAGE_LOG.USER_ID, DECODE (ACTIVITY.MODULE_ID, 'D6A69E3B7355ECBFE040F00A17203B15', 'Application Trials', '61ECAF4AAB73E990E040449821C61C97', 'Help', 'NULL') PRODUCT_NAME, 'NULL' PRODUCT_DESCRIPTION, 'NULL' LANGUAGE_CODE, ACTIVITY.ACTIVITY_LOOKUP_TYPE ACTIVITY_LOOKUP_TYPE, ACTIVITY.ACTIVITY_LOOKUP_CODE ACTIVITY_LOOKUP_CODE, ACTIVITY.MODULE_ID MODULE_ID, FLOW.FLOW_LOOKUP_TYPE FLOW_LOOKUP_TYPE, FLOW.FLOW_LOOKUP_CODE FLOW_LOOKUP_CODE FROM ATK_USAGE_LOGS USAGE_LOG, ATK_USAGE_ACTIVITIES ACTIVITY, ATK_USAGE_FLOWS FLOW, ATK_USAGE_FLOW_STEPS FLOW_STEP WHERE USAGE_LOG.ACTIVITY_CODE = ACTIVITY.ACTIVITY_CODE AND ACTIVITY.ACTIVITY_CODE = FLOW_STEP.ACTIVITY_CODE AND FLOW.FLOW_CODE = FLOW_STEP.FLOW_CODE