FAI_SAM_ANOMALY_PROCESSOUT_V

Details

• Schema: FUSION

• Object owner: FAI

• Object type: VIEW

Columns

Name
ANOMALY_DETECTION_ID DETECTION_KEY DETAIL_INFO OBJECT_ID RAW_PROCESSOUT_ID CONTEXT KEY VALUE DATE_DATA STATUS CONSUMER_DATA_KEY ANOMALY_LOOP CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID RAW_LOAD_ID

Query

SQL_Statement

select anomaly_detection_id, detection_key, detail_info, a.detection_object_id object_id, b."RAW_PROCESSOUT_ID",b."CONTEXT",b."KEY",b."VALUE",b."DATE_DATA",b."STATUS",b."CONSUMER_DATA_KEY",b."ANOMALY_LOOP",b."CREATED_BY",b."CREATION_DATE",b."LAST_UPDATED_BY",b."LAST_UPDATE_DATE",b."LAST_UPDATE_LOGIN",b."ENTERPRISE_ID",b."RAW_LOAD_ID" from fai_sam_anomaly_detection a, fai_sam_raw_processout b where a.detection_object_id = b.raw_processout_id and detection_key = 'FAI_SAM_COMPARE_PROCESSOUT_DATA'