VIEW: FLM.FLM_MMM_OPERATIONS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LINE_ID LINE_ID, OPERATION_TYPE OPERATION_TYPE, OPERATION_TAKT OPERATION_TAKT, MACHINE_WEIGHTED_TIME MACHINE_WEIGHTED_TIME, LABOR_WEIGHTED_TIME LABOR_WEIGHTED_TIME, ELAPSED_WEIGHTED_TIME ELAPSED_WEIGHTED_TIME, IPK_NEEDED IPK_NEEDED, IPK_ASSIGNED IPK_ASSIGNED, OP_TAKT_AS_ASSIGNED OP_TAKT_AS_ASSIGNED, BOTTLENECK_RESOURCE_PERCENT BOTTLENECK_RESOURCE_PERCENT, PROCESS_EFFICIENCY PROCESS_EFFICIENCY, RESOURCE_UNDERCAPACITY RESOURCE_UNDERCAPACITY from "FLM"."FLM_MMM_OPERATIONS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LINE_ID LINE_ID
, OPERATION_TYPE OPERATION_TYPE
, OPERATION_TAKT OPERATION_TAKT
, MACHINE_WEIGHTED_TIME MACHINE_WEIGHTED_TIME
, LABOR_WEIGHTED_TIME LABOR_WEIGHTED_TIME
, ELAPSED_WEIGHTED_TIME ELAPSED_WEIGHTED_TIME
, IPK_NEEDED IPK_NEEDED
, IPK_ASSIGNED IPK_ASSIGNED
, OP_TAKT_AS_ASSIGNED OP_TAKT_AS_ASSIGNED
, BOTTLENECK_RESOURCE_PERCENT BOTTLENECK_RESOURCE_PERCENT
, PROCESS_EFFICIENCY PROCESS_EFFICIENCY
, RESOURCE_UNDERCAPACITY RESOURCE_UNDERCAPACITY
FROM "FLM"."FLM_MMM_OPERATIONS"