VIEW: WIP.WIP_TIME_ENTRY_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_ID INTERFACE_ID, TIME_ENTRY_TYPE TIME_ENTRY_TYPE, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, WIP_ENTITY_ID WIP_ENTITY_ID, JOB_NAME JOB_NAME, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_CODE RESOURCE_CODE, RESOURCE_ID RESOURCE_ID, UOM_CODE UOM_CODE, EMPLOYEE_ID EMPLOYEE_ID, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_END_DATE ACTUAL_END_DATE, DURATION DURATION, ACTION_FLAG ACTION_FLAG, REQUEST_ID REQUEST_ID, ERROR ERROR, PROCESS_STATUS PROCESS_STATUS, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BADGE_ID BADGE_ID, CONTINGENT_FLAG CONTINGENT_FLAG from "WIP"."WIP_TIME_ENTRY_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_ID INTERFACE_ID
, TIME_ENTRY_TYPE TIME_ENTRY_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, WIP_ENTITY_ID WIP_ENTITY_ID
, JOB_NAME JOB_NAME
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_CODE RESOURCE_CODE
, RESOURCE_ID RESOURCE_ID
, UOM_CODE UOM_CODE
, EMPLOYEE_ID EMPLOYEE_ID
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_END_DATE ACTUAL_END_DATE
, DURATION DURATION
, ACTION_FLAG ACTION_FLAG
, REQUEST_ID REQUEST_ID
, ERROR ERROR
, PROCESS_STATUS PROCESS_STATUS
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BADGE_ID BADGE_ID
, CONTINGENT_FLAG CONTINGENT_FLAG
FROM "WIP"."WIP_TIME_ENTRY_INTERFACE"