VIEW: APPS.BOM_MIXED_MODEL_MAP_CELLS_V

Source

View Text - Preformatted

SELECT a.mixed_model_map_id, a.group_number, a.product_item_id, a.demand, a.machine_time, b.machine_time, c.machine_time, d.machine_time, e.machine_time, a.labor_time, b.labor_time, c.labor_time, d.labor_time, e.labor_time, a.total_time, b.total_time, c.total_time, d.total_time, e.total_time, a.process_volume, b.process_volume, c.process_volume, d.process_volume, e.process_volume FROM BOM_MIXED_MODEL_MAP_CELLS A,BOM_MIXED_MODEL_MAP_CELLS B,BOM_MIXED_MODEL_MAP_CELLS C,BOM_MIXED_MODEL_MAP_CELLS D,BOM_MIXED_MODEL_MAP_CELLS 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.product_item_id = b.product_item_id AND a.product_item_id = c.product_item_id AND a.product_item_id = d.product_item_id AND a.product_item_id = e.product_item_id 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.PRODUCT_ITEM_ID
, A.DEMAND
, A.MACHINE_TIME
, B.MACHINE_TIME
, C.MACHINE_TIME
, D.MACHINE_TIME
, E.MACHINE_TIME
, A.LABOR_TIME
, B.LABOR_TIME
, C.LABOR_TIME
, D.LABOR_TIME
, E.LABOR_TIME
, A.TOTAL_TIME
, B.TOTAL_TIME
, C.TOTAL_TIME
, D.TOTAL_TIME
, E.TOTAL_TIME
, A.PROCESS_VOLUME
, B.PROCESS_VOLUME
, C.PROCESS_VOLUME
, D.PROCESS_VOLUME
, E.PROCESS_VOLUME
FROM BOM_MIXED_MODEL_MAP_CELLS A
, BOM_MIXED_MODEL_MAP_CELLS B
, BOM_MIXED_MODEL_MAP_CELLS C
, BOM_MIXED_MODEL_MAP_CELLS D
, BOM_MIXED_MODEL_MAP_CELLS 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.PRODUCT_ITEM_ID = B.PRODUCT_ITEM_ID
AND A.PRODUCT_ITEM_ID = C.PRODUCT_ITEM_ID
AND A.PRODUCT_ITEM_ID = D.PRODUCT_ITEM_ID
AND A.PRODUCT_ITEM_ID = E.PRODUCT_ITEM_ID
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