ANC_WFM_INTERFACE_HEADER_V

Details

• Schema: FUSION

• Object owner: ANC

• Object type: VIEW

Columns

Name

WFM_IFACE_HDR_ID HEADER_ID ENTERPRISE_ID OBJECT_VERSION_NUMBER PER_ABS_TYPE_ENTRY_ID TRANSACTION_ID USER_OPERATION DML_OPERATION STATUS_TIME PROCESS_STATUS START_DATETIME END_DATETIME PER_ABS_ENTRY_ID ABSENCE_STATUS START_DATE END_DATE START_TIME END_TIME START_DATE_DURATION END_DATE_DURATION ABSENCE_TYPE_REASON_ID PERSON_ID ASSIGNMENT_ID COMMENTS_TYPE_ENTRIES ABSENCE_TYPE_ID UOM QTY ABSENCE_STATUS_CD APPROVAL_STATUS_CD SOURCE COMMENTS_PER_ABS_ENTRIES

Query

SQL_Statement

SELECT hd.WFM_IFACE_HDR_ID, hd.HEADER_ID, hd.ENTERPRISE_ID, hd.OBJECT_VERSION_NUMBER, hd.PER_ABS_TYPE_ENTRY_ID, hd.TRANSACTION_ID, hd.USER_OPERATION, hd.DML_OPERATION, hd.STATUS_TIME, hd.PROCESS_STATUS, hd.START_DATETIME, hd.END_DATETIME, hd.PER_ABS_ENTRY_ID, typ.ABSENCE_STATUS, typ.START_DATE, typ.END_DATE, typ.START_TIME, typ.END_TIME, typ.START_DATE_DURATION, typ.END_DATE_DURATION, typ.ABSENCE_TYPE_REASON_ID, hd.PERSON_ID, typ.ASSIGNMENT_ID, typ.COMMENTS AS COMMENTS_TYPE_ENTRIES, typ.ABSENCE_TYPE_ID, typ.UOM, typ.QTY, ent.ABSENCE_STATUS_CD, ent.APPROVAL_STATUS_CD, ent.SOURCE, ent.COMMENTS AS COMMENTS_PER_ABS_ENTRIES FROM (ANC_WFM_INTERFACE_HEADER hd LEFT OUTER JOIN ANC_PER_ABS_ENTRIES ent on hd.PER_ABS_ENTRY_ID = ent.PER_ABSENCE_ENTRY_ID) LEFT OUTER JOIN ANC_PER_ABS_TYPE_ENTRIES typ ON typ.PER_ABS_TYPE_ENTRY_ID = hd.PER_ABS_TYPE_ENTRY_ID