1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE OR REPLACE FORCE VIEW "COSWIN"."VIST_DATA" ("EQUIPMENT", "DESCRIPTION", "LIGNE", "ZONE", "CRITIQUE", "FONCTION", "DATE_", "T_OUVERTURE", "N_OT", "T_ARRET") AS
SELECT EREQ_CODE AS EQUIPMENT,
ereq_description AS DESCRIPTION,
EREQ_PARENT_EQUIPMENT AS LIGNE,
EREQ_ZONE AS ZONE,
ereq_boolean1 AS CRITIQUE,
EREQ_CATEGORY AS FONCTION,
EQFR_DATE1 AS DATE_,
EQFR_NUMBER1 AS T_OUVERTURE,
EQFR_NUMBER2 AS N_OT,
EQFR_NUMBER3 AS T_ARRET
FROM EQUIPMENT
LEFT OUTER JOIN EQUIPMENT_FREE
ON EQUIPMENT.EREQ_CODE=EQUIPMENT_FREE.EQFR_EQUIPMENT
WHERE EREQ_ENTITY='TPM' AND EREQ_EQUIPMENT_STATUS='N' and EREQ_LEVEL=2 AND EQFR_DATE1 >TO_DATE ('12/31/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS')
ORDER BY EQUIPMENT,
DATE_ desc; |
Partager