1. Tables and Views for HCM
  2. FAI_SAM_TBS_PROCESSOUT_DATA_V

FAI_SAM_TBS_PROCESSOUT_DATA_V

Details

  • Schema: FUSION

  • Object owner: FAI

  • Object type: VIEW

Columns

Name

SEQUENCE_ID

RAW_PROCESSOUT_ID

STATUS

CONTEXT

KEY

VALUE

DATE_DATA

ANOMALY_LOOP

SEQUENCE

Query

SQL_Statement

select B.SEQUENCE_ID, A.RAW_PROCESSOUT_ID,A.STATUS,"CONTEXT", "KEY","VALUE","DATE_DATA", "ANOMALY_LOOP", B.SEQUENCE

from FAI_SAM_RAW_PROCESSOUT A, FAI_SAM_SEQUENCE B, FAI_SAM_SEQUENCE_OBJECT C

where A.RAW_PROCESSOUT_ID = C.RAW_PROCESSOUT_ID

and C.SEQUENCE_ID = B.SEQUENCE_ID

and a.last_update_date >= SYS_EXTRACT_UTC(SYSTIMESTAMP) - interval '2' hour