Product: | BOM - Bills of Material |
---|---|
Description: | View for reformatting data in BOM_MIXED_MODEL_MAP_CELLS for display |
Implementation/DBA Data: | APPS.BOM_MIXED_MODEL_MAP_CELLS_V |
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