VIEW: APPS.BOM_MIXED_MODEL_MAP_PROC_V

Source

View Text - Preformatted

SELECT A.MIXED_MODEL_MAP_ID, A.GROUP_NUMBER, A.OPERATION_CODE, B.OPERATION_CODE, C.OPERATION_CODE, D.OPERATION_CODE, E.OPERATION_CODE, A.MACHINE_WEIGHTED_TIME, B.MACHINE_WEIGHTED_TIME, C.MACHINE_WEIGHTED_TIME, D.MACHINE_WEIGHTED_TIME, E.MACHINE_WEIGHTED_TIME, A.LABOR_WEIGHTED_TIME, B.LABOR_WEIGHTED_TIME, C.LABOR_WEIGHTED_TIME, D.LABOR_WEIGHTED_TIME, E.LABOR_WEIGHTED_TIME, A.TOTAL_WEIGHTED_TIME, B.TOTAL_WEIGHTED_TIME, C.TOTAL_WEIGHTED_TIME, D.TOTAL_WEIGHTED_TIME, E.TOTAL_WEIGHTED_TIME, A.MACHINES_NEEDED, B.MACHINES_NEEDED, C.MACHINES_NEEDED, D.MACHINES_NEEDED, E.MACHINES_NEEDED, A.MACHINES_ASSIGNED, B.MACHINES_ASSIGNED, C.MACHINES_ASSIGNED, D.MACHINES_ASSIGNED, E.MACHINES_ASSIGNED, A.LABOR_NEEDED, B.LABOR_NEEDED, C.LABOR_NEEDED, D.LABOR_NEEDED, E.LABOR_NEEDED, A.LABOR_ASSIGNED, B.LABOR_ASSIGNED, C.LABOR_ASSIGNED, D.LABOR_ASSIGNED, E.LABOR_ASSIGNED, A.TAKT_TIME, B.TAKT_TIME, C.TAKT_TIME, D.TAKT_TIME, E.TAKT_TIME, A.TAKT_TIME_FOR_ASSIGNED, B.TAKT_TIME_FOR_ASSIGNED, C.TAKT_TIME_FOR_ASSIGNED, D.TAKT_TIME_FOR_ASSIGNED, E.TAKT_TIME_FOR_ASSIGNED, A.IN_PROCESS_KANBAN, B.IN_PROCESS_KANBAN, C.IN_PROCESS_KANBAN, D.IN_PROCESS_KANBAN, E.IN_PROCESS_KANBAN, A.MACHINES_NEEDED_DELTA, B.MACHINES_NEEDED_DELTA, C.MACHINES_NEEDED_DELTA, D.MACHINES_NEEDED_DELTA, E.MACHINES_NEEDED_DELTA, A.LABOR_NEEDED_DELTA, B.LABOR_NEEDED_DELTA, C.LABOR_NEEDED_DELTA, D.LABOR_NEEDED_DELTA, E.LABOR_NEEDED_DELTA, A.IN_PROCESS_KANBAN_DELTA, B.IN_PROCESS_KANBAN_DELTA, C.IN_PROCESS_KANBAN_DELTA, D.IN_PROCESS_KANBAN_DELTA, E.IN_PROCESS_KANBAN_DELTA FROM BOM_MIXED_MODEL_MAP_PROCESSES A,BOM_MIXED_MODEL_MAP_PROCESSES B,BOM_MIXED_MODEL_MAP_PROCESSES C,BOM_MIXED_MODEL_MAP_PROCESSES D,BOM_MIXED_MODEL_MAP_PROCESSES E where a.mixed_model_map_id = b.mixed_model_map_id(+) and a.mixed_model_map_id = c.mixed_model_map_id(+) and a.mixed_model_map_id = d.mixed_model_map_id(+) and a.mixed_model_map_id = e.mixed_model_map_id(+) and a.group_number = b.group_number(+) and a.group_number = c.group_number(+) and a.group_number = d.group_number(+) and a.group_number = e.group_number(+) and a.sequence_id = 1 and b.sequence_id(+) = 2 and c.sequence_id(+) = 3 and d.sequence_id(+) = 4 and e.sequence_id(+) = 5

View Text - HTML Formatted

SELECT A.MIXED_MODEL_MAP_ID
, A.GROUP_NUMBER
, A.OPERATION_CODE
, B.OPERATION_CODE
, C.OPERATION_CODE
, D.OPERATION_CODE
, E.OPERATION_CODE
, A.MACHINE_WEIGHTED_TIME
, B.MACHINE_WEIGHTED_TIME
, C.MACHINE_WEIGHTED_TIME
, D.MACHINE_WEIGHTED_TIME
, E.MACHINE_WEIGHTED_TIME
, A.LABOR_WEIGHTED_TIME
, B.LABOR_WEIGHTED_TIME
, C.LABOR_WEIGHTED_TIME
, D.LABOR_WEIGHTED_TIME
, E.LABOR_WEIGHTED_TIME
, A.TOTAL_WEIGHTED_TIME
, B.TOTAL_WEIGHTED_TIME
, C.TOTAL_WEIGHTED_TIME
, D.TOTAL_WEIGHTED_TIME
, E.TOTAL_WEIGHTED_TIME
, A.MACHINES_NEEDED
, B.MACHINES_NEEDED
, C.MACHINES_NEEDED
, D.MACHINES_NEEDED
, E.MACHINES_NEEDED
, A.MACHINES_ASSIGNED
, B.MACHINES_ASSIGNED
, C.MACHINES_ASSIGNED
, D.MACHINES_ASSIGNED
, E.MACHINES_ASSIGNED
, A.LABOR_NEEDED
, B.LABOR_NEEDED
, C.LABOR_NEEDED
, D.LABOR_NEEDED
, E.LABOR_NEEDED
, A.LABOR_ASSIGNED
, B.LABOR_ASSIGNED
, C.LABOR_ASSIGNED
, D.LABOR_ASSIGNED
, E.LABOR_ASSIGNED
, A.TAKT_TIME
, B.TAKT_TIME
, C.TAKT_TIME
, D.TAKT_TIME
, E.TAKT_TIME
, A.TAKT_TIME_FOR_ASSIGNED
, B.TAKT_TIME_FOR_ASSIGNED
, C.TAKT_TIME_FOR_ASSIGNED
, D.TAKT_TIME_FOR_ASSIGNED
, E.TAKT_TIME_FOR_ASSIGNED
, A.IN_PROCESS_KANBAN
, B.IN_PROCESS_KANBAN
, C.IN_PROCESS_KANBAN
, D.IN_PROCESS_KANBAN
, E.IN_PROCESS_KANBAN
, A.MACHINES_NEEDED_DELTA
, B.MACHINES_NEEDED_DELTA
, C.MACHINES_NEEDED_DELTA
, D.MACHINES_NEEDED_DELTA
, E.MACHINES_NEEDED_DELTA
, A.LABOR_NEEDED_DELTA
, B.LABOR_NEEDED_DELTA
, C.LABOR_NEEDED_DELTA
, D.LABOR_NEEDED_DELTA
, E.LABOR_NEEDED_DELTA
, A.IN_PROCESS_KANBAN_DELTA
, B.IN_PROCESS_KANBAN_DELTA
, C.IN_PROCESS_KANBAN_DELTA
, D.IN_PROCESS_KANBAN_DELTA
, E.IN_PROCESS_KANBAN_DELTA
FROM BOM_MIXED_MODEL_MAP_PROCESSES A
, BOM_MIXED_MODEL_MAP_PROCESSES B
, BOM_MIXED_MODEL_MAP_PROCESSES C
, BOM_MIXED_MODEL_MAP_PROCESSES D
, BOM_MIXED_MODEL_MAP_PROCESSES E
WHERE A.MIXED_MODEL_MAP_ID = B.MIXED_MODEL_MAP_ID(+)
AND A.MIXED_MODEL_MAP_ID = C.MIXED_MODEL_MAP_ID(+)
AND A.MIXED_MODEL_MAP_ID = D.MIXED_MODEL_MAP_ID(+)
AND A.MIXED_MODEL_MAP_ID = E.MIXED_MODEL_MAP_ID(+)
AND A.GROUP_NUMBER = B.GROUP_NUMBER(+)
AND A.GROUP_NUMBER = C.GROUP_NUMBER(+)
AND A.GROUP_NUMBER = D.GROUP_NUMBER(+)
AND A.GROUP_NUMBER = E.GROUP_NUMBER(+)
AND A.SEQUENCE_ID = 1
AND B.SEQUENCE_ID(+) = 2
AND C.SEQUENCE_ID(+) = 3
AND D.SEQUENCE_ID(+) = 4
AND E.SEQUENCE_ID(+) = 5