VIEW: APPS.MTH_ENTITY_SUSTAIN_PERFORM_V

Source

View Text - Preformatted

SELECT epp.EQUIPMENT_FK_KEY,epp.SYSTEM_FK_KEY,epp.WORKORDER_FK_KEY,epp.SEGMENT_FK_KEY,epp.SHIFT_WORKDAY_FK_KEY,epp.HOUR_FK_KEY,epp.RUN_HOURS,epp.IDLE_HOURS,epp.DOWN_HOURS,epp.OFF_HOURS,epp.QTY_COMPLETED,epp.QTY_OUTPUT,epp.QTY_GOOD,epp.QTY_SCRAP,epp.QTY_REJECTED,epp.QTY_REWORK,sa.SUSTAIN_ASPECT_CODE,eps.SUSTAIN_ASPECT_UOM,eps.SUSTAIN_ASPECT_USAGE_VALUE AS SUSTAIN_ASPECT_CONSUMED FROM MTH_EQUIP_PROD_PERFORMANCE_F epp, MTH_EQUIP_PROD_SUSTAIN_F eps, MTH_SUSTAIN_ASPECTS sa WHERE eps.SUSTAIN_ASPECT_FK_KEY = sa.SUSTAIN_ASPECT_PK_KEY UNION SELECT ENTITY_FK_KEY,NULL,NULL,NULL,SHIFT_WORKDAY_FK_KEY,HOUR_FK_KEY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,SUSTAIN_ASPECT,USAGE_UOM,Sum(USAGE_VALUE) FROM MTH_ENTITY_SUSTAIN_ASPECT ESA WHERE ESA.METER_CATEGORY = 'PRIMARY' AND ESA.ENTITY_TYPE! = 'EQUIPMENT' GROUP BY ENTITY_FK_KEY, SHIFT_WORKDAY_FK_KEY, HOUR_FK_KEY, SUSTAIN_ASPECT,USAGE_UOM UNION SELECT ENTITY_FK_KEY,NULL,NULL, NULL,SHIFT_WORKDAY_FK_KEY,HOUR_FK_KEY,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,SUSTAIN_ASPECT,USAGE_UOM,Sum(USAGE_VALUE) FROM MTH_ENTITY_SUSTAIN_ASPECT ESA, MTH_EQUIPMENTS_D EQUIP WHERE ESA.METER_CATEGORY = 'PRIMARY' AND ESA.ENTITY_TYPE = 'EQUIPMENT' AND ESA.ENTITY_FK_KEY = EQUIP.EQUIPMENT_PK_KEY AND EQUIP.PRODUCTION_EQUIPMENT != 'Y' GROUP BY ENTITY_FK_KEY, SHIFT_WORKDAY_FK_KEY, HOUR_FK_KEY, SUSTAIN_ASPECT, USAGE_UOM

View Text - HTML Formatted

SELECT EPP.EQUIPMENT_FK_KEY
, EPP.SYSTEM_FK_KEY
, EPP.WORKORDER_FK_KEY
, EPP.SEGMENT_FK_KEY
, EPP.SHIFT_WORKDAY_FK_KEY
, EPP.HOUR_FK_KEY
, EPP.RUN_HOURS
, EPP.IDLE_HOURS
, EPP.DOWN_HOURS
, EPP.OFF_HOURS
, EPP.QTY_COMPLETED
, EPP.QTY_OUTPUT
, EPP.QTY_GOOD
, EPP.QTY_SCRAP
, EPP.QTY_REJECTED
, EPP.QTY_REWORK
, SA.SUSTAIN_ASPECT_CODE
, EPS.SUSTAIN_ASPECT_UOM
, EPS.SUSTAIN_ASPECT_USAGE_VALUE AS SUSTAIN_ASPECT_CONSUMED
FROM MTH_EQUIP_PROD_PERFORMANCE_F EPP
, MTH_EQUIP_PROD_SUSTAIN_F EPS
, MTH_SUSTAIN_ASPECTS SA
WHERE EPS.SUSTAIN_ASPECT_FK_KEY = SA.SUSTAIN_ASPECT_PK_KEY UNION SELECT ENTITY_FK_KEY
, NULL
, NULL
, NULL
, SHIFT_WORKDAY_FK_KEY
, HOUR_FK_KEY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SUSTAIN_ASPECT
, USAGE_UOM
, SUM(USAGE_VALUE)
FROM MTH_ENTITY_SUSTAIN_ASPECT ESA
WHERE ESA.METER_CATEGORY = 'PRIMARY'
AND ESA.ENTITY_TYPE! = 'EQUIPMENT' GROUP BY ENTITY_FK_KEY
, SHIFT_WORKDAY_FK_KEY
, HOUR_FK_KEY
, SUSTAIN_ASPECT
, USAGE_UOM UNION SELECT ENTITY_FK_KEY
, NULL
, NULL
, NULL
, SHIFT_WORKDAY_FK_KEY
, HOUR_FK_KEY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SUSTAIN_ASPECT
, USAGE_UOM
, SUM(USAGE_VALUE)
FROM MTH_ENTITY_SUSTAIN_ASPECT ESA
, MTH_EQUIPMENTS_D EQUIP
WHERE ESA.METER_CATEGORY = 'PRIMARY'
AND ESA.ENTITY_TYPE = 'EQUIPMENT'
AND ESA.ENTITY_FK_KEY = EQUIP.EQUIPMENT_PK_KEY
AND EQUIP.PRODUCTION_EQUIPMENT != 'Y' GROUP BY ENTITY_FK_KEY
, SHIFT_WORKDAY_FK_KEY
, HOUR_FK_KEY
, SUSTAIN_ASPECT
, USAGE_UOM