VIEW: WIP.WIP_SCHEDULING_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_ID INTERFACE_ID, GROUP_ID GROUP_ID, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, SCHEDULING_LEVEL SCHEDULING_LEVEL, OPERATION_START_DATE OPERATION_START_DATE, OPERATION_COMPLETION_DATE OPERATION_COMPLETION_DATE, RESOURCE_START_DATE RESOURCE_START_DATE, RESOURCE_COMPLETION_DATE RESOURCE_COMPLETION_DATE, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT, PROCESS_PHASE PROCESS_PHASE, PROCESS_STATUS PROCESS_STATUS, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID from "WIP"."WIP_SCHEDULING_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_ID INTERFACE_ID
, GROUP_ID GROUP_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, SCHEDULING_LEVEL SCHEDULING_LEVEL
, OPERATION_START_DATE OPERATION_START_DATE
, OPERATION_COMPLETION_DATE OPERATION_COMPLETION_DATE
, RESOURCE_START_DATE RESOURCE_START_DATE
, RESOURCE_COMPLETION_DATE RESOURCE_COMPLETION_DATE
, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, PROCESS_PHASE PROCESS_PHASE
, PROCESS_STATUS PROCESS_STATUS
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
FROM "WIP"."WIP_SCHEDULING_INTERFACE"