Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT main.DWC_ID_EOUSPE, main.DWC_ID_DN, dn.DWC_DS_DN, main.DWC_ID_DT, dt.DWC_DS_DT, main.DWC_ID_DZ, dz.DWC_DS_DZ,
- main.DWC_ID_EXPLOT, expl.DWC_DS_EXPLOT, main.DWC_ID_INSTAL, inst.DWC_DS_INSTAL,
- main.DWC_ID_TIPO_INSTAL, tip.DWC_DS_TIPO_INSTAL, main.DWC_ID_USUARIO, usuarios.DS_USER, DWC_ID_ANYO,
- main.DWC_ID_PERIODICIDAD, perdad.DWC_DS_PERIODICIDAD, main.DWC_ID_PERIODO, periodo.DWC_DS_PERIODO,
- DWC_ID_FEC_INICIO, DWC_ID_FEC_CIERRE, DWC_USUTOPE, DWC_FULTOPE
- FROM DWT_DMTC_FT_EOUSPE main
- LEFT OUTER JOIN DWT_DMTC_LK_EO_DN dn ON main.DWC_ID_DN = dn.DWC_ID_DN AND dn.DWC_ID_ANYMES= 201805
- LEFT OUTER JOIN DWT_DMTC_LK_EO_DT dt ON main.DWC_ID_DT = dt.DWC_ID_DT AND dt.DWC_ID_ANYMES= 201805
- LEFT OUTER JOIN DWT_DMTC_LK_EO_DZ dz ON main.DWC_ID_DZ = dz.DWC_ID_DZ AND dz.DWC_ID_ANYMES= 201805
- LEFT OUTER JOIN DWT_DMTC_LK_EO_EXPLOT expl ON main.DWC_ID_EXPLOT = expl.DWC_ID_EXPLOT AND expl.DWC_ID_ANYMES= 201805
- LEFT OUTER JOIN DWT_DMTC_LK_EO_INSTAL inst ON main.DWC_ID_INSTAL = inst.DWC_ID_INSTAL AND inst.DWC_ID_ANYMES= 201805
- LEFT OUTER JOIN DWT_DMTC_LK_TIPO_INSTAL tip ON main.DWC_ID_TIPO_INSTAL = CAST(tip.DWC_ID_TIPO_INSTAL AS VARCHAR2(10))
- LEFT OUTER JOIN DWT_DMTC_LK_PERIODICIDAD perdad ON main.DWC_ID_PERIODICIDAD = perdad.DWC_ID_PERIODICIDAD
- LEFT OUTER JOIN DWT_DMTC_LK_PERIODO periodo ON main.DWC_ID_PERIODO = periodo.DWC_ID_PERIODO AND main.DWC_ID_PERIODICIDAD = periodo.DWC_ID_PERIODICIDAD
- LEFT OUTER JOIN ( SELECT ID_USER, MIN(DS_USER) DS_USER FROM SEG_USERS GROUP BY ID_USER) usuarios ON main.DWC_ID_USUARIO = usuarios.ID_USER
- --WHERE (DWC_ID_ANYO >= el que sigui) OR (DWC_ID_ANYO >= el que sigui-1) + " AND main.DWC_ID_PERIODICIDAD=1)
- WHERE CAST(to_char(DWC_ID_FEC_INICIO+90, 'YYYY') AS INT) >= " + year + "
- ORDER BY DWC_ID_FEC_INICIO DESC, DWC_ID_FEC_CIERRE DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement