VIEW: WIP.WIP_RESOURCE_ACTUAL_TIMES#

Source

View Text - Preformatted

select TIME_ENTRY_ID TIME_ENTRY_ID, ORGANIZATION_ID ORGANIZATION_ID, WIP_ENTITY_ID WIP_ENTITY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_ID RESOURCE_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, INSTANCE_ID INSTANCE_ID, SERIAL_NUMBER SERIAL_NUMBER, TIME_ENTRY_MODE TIME_ENTRY_MODE, COST_FLAG COST_FLAG, ADD_TO_RTG ADD_TO_RTG, STATUS_TYPE STATUS_TYPE, START_DATE START_DATE, END_DATE END_DATE, PROJECTED_COMPLETION_DATE PROJECTED_COMPLETION_DATE, DURATION DURATION, UOM_CODE UOM_CODE, EMPLOYEE_ID EMPLOYEE_ID, PROCESS_STATUS PROCESS_STATUS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACTION_FLAG ACTION_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "WIP"."WIP_RESOURCE_ACTUAL_TIMES"

View Text - HTML Formatted

SELECT TIME_ENTRY_ID TIME_ENTRY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_ID RESOURCE_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, INSTANCE_ID INSTANCE_ID
, SERIAL_NUMBER SERIAL_NUMBER
, TIME_ENTRY_MODE TIME_ENTRY_MODE
, COST_FLAG COST_FLAG
, ADD_TO_RTG ADD_TO_RTG
, STATUS_TYPE STATUS_TYPE
, START_DATE START_DATE
, END_DATE END_DATE
, PROJECTED_COMPLETION_DATE PROJECTED_COMPLETION_DATE
, DURATION DURATION
, UOM_CODE UOM_CODE
, EMPLOYEE_ID EMPLOYEE_ID
, PROCESS_STATUS PROCESS_STATUS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACTION_FLAG ACTION_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "WIP"."WIP_RESOURCE_ACTUAL_TIMES"