VIEW: BOM.BOM_MIXED_MODEL_MAP_PROCESSES#

Source

View Text - Preformatted

select MIXED_MODEL_MAP_ID MIXED_MODEL_MAP_ID, GROUP_NUMBER GROUP_NUMBER, SEQUENCE_ID SEQUENCE_ID, OPERATION_CODE OPERATION_CODE, MACHINE_WEIGHTED_TIME MACHINE_WEIGHTED_TIME, LABOR_WEIGHTED_TIME LABOR_WEIGHTED_TIME, TOTAL_WEIGHTED_TIME TOTAL_WEIGHTED_TIME, MACHINES_NEEDED MACHINES_NEEDED, MACHINES_ASSIGNED MACHINES_ASSIGNED, MACHINES_NEEDED_DELTA MACHINES_NEEDED_DELTA, LABOR_NEEDED LABOR_NEEDED, LABOR_ASSIGNED LABOR_ASSIGNED, LABOR_NEEDED_DELTA LABOR_NEEDED_DELTA, TAKT_TIME TAKT_TIME, TAKT_TIME_FOR_ASSIGNED TAKT_TIME_FOR_ASSIGNED, IN_PROCESS_KANBAN IN_PROCESS_KANBAN, IN_PROCESS_KANBAN_DELTA IN_PROCESS_KANBAN_DELTA, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "BOM"."BOM_MIXED_MODEL_MAP_PROCESSES"

View Text - HTML Formatted

SELECT MIXED_MODEL_MAP_ID MIXED_MODEL_MAP_ID
, GROUP_NUMBER GROUP_NUMBER
, SEQUENCE_ID SEQUENCE_ID
, OPERATION_CODE OPERATION_CODE
, MACHINE_WEIGHTED_TIME MACHINE_WEIGHTED_TIME
, LABOR_WEIGHTED_TIME LABOR_WEIGHTED_TIME
, TOTAL_WEIGHTED_TIME TOTAL_WEIGHTED_TIME
, MACHINES_NEEDED MACHINES_NEEDED
, MACHINES_ASSIGNED MACHINES_ASSIGNED
, MACHINES_NEEDED_DELTA MACHINES_NEEDED_DELTA
, LABOR_NEEDED LABOR_NEEDED
, LABOR_ASSIGNED LABOR_ASSIGNED
, LABOR_NEEDED_DELTA LABOR_NEEDED_DELTA
, TAKT_TIME TAKT_TIME
, TAKT_TIME_FOR_ASSIGNED TAKT_TIME_FOR_ASSIGNED
, IN_PROCESS_KANBAN IN_PROCESS_KANBAN
, IN_PROCESS_KANBAN_DELTA IN_PROCESS_KANBAN_DELTA
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "BOM"."BOM_MIXED_MODEL_MAP_PROCESSES"