Product: | BOM - Bills of Material |
---|---|
Description: | Contains process, line operation, and summary information for a mixed model map |
Implementation/DBA Data: | APPS.BOM_MIXED_MODEL_MAP_PROC_V |
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