Europe(Expiring)
|
| No. |
Name of Partners |
Agreement Name |
Agreement Level |
Subordinating Unit of KU |
Subordinating Unit of Partner |
Effective Date |
Expired Date |
Duration |
Auto - Renewal |
Download
(Only authorized persons) |
SELECT DISTINCT M_INSTITUTE.INSTITUTE_NAME,
FPI.PARTNER_INS_OTHER_NAME,
MM.MOU_ID,
MM.MOU_NAME,
MM.MOU_EFFECT_DATE,
MM.MOU_EXPIRE_DATE,
MM.MOU_DU_MONTH,
MM.MOU_DURATION,
MM.MOU_AUTO_RENEWAL,
MM.UNSPECIFIED,
WF_FILE.FILE_SAVE_NAME,
MOU_LEVEL,
LEVEL_KU_CAMPUS,
MOU_CAMPUS_ETC,
LEVEL_KU_OFFICE,
MOU_OFFICE_ETC,
LEVEL_KU_INS,
MOU_LEVEL_INS
FROM M_MOU MM
LEFT JOIN FRM_PARTNER_INS FPI ON MM.MOU_ID = FPI.WFR_ID AND FPI.WF_MAIN_ID = 108 AND FPI.PARTNER_INSTITUTE::INTEGER != 0
LEFT JOIN M_CONTINENT ON FPI.PARTNER_CONTINENT::INTEGER = M_CONTINENT.CONTINENT_ID
LEFT JOIN M_COUNTRY ON FPI.PARTNER_COUNTRY::INTEGER = M_COUNTRY.COUNTRY_ID
LEFT JOIN M_INSTITUTE ON FPI.PARTNER_INSTITUTE::INTEGER = M_INSTITUTE.INSTITUTE_ID
LEFT JOIN M_MOU_LEVEL ON MM.MOU_LEVEL = M_MOU_LEVEL.MOU_LEVEL_ID::TEXT
LEFT JOIN FRM_KU_SUB FKS ON MM.MOU_ID = FKS.WFR_ID AND FKS.WF_MAIN_ID = '108'
LEFT JOIN M_FACULTY MF ON FKS.MOU_KU_FACULTY = MF.FACULTY_ID
LEFT JOIN FRM_PARTNER_SUB FPS ON MM.MOU_ID = FPS.WFR_ID AND FPS.WF_MAIN_ID = '108'
LEFT JOIN WF_FILE ON MM.MOU_ID = WF_FILE.WFR_ID AND WF_FILE.WF_MAIN_ID = '108' AND WF_FILE.WFS_FIELD_NAME = 'MOU_FILE' AND WF_FILE.FILE_STATUS = 'Y'
WHERE 1=1 AND M_CONTINENT.CONTINENT_ID = '4' AND SYSDATE >= ADD_MONTHS(MOU_EXPIRE_DATE ,- 6)
AND SYSDATE < MOU_EXPIRE_DATE UNION ALL SELECT DISTINCT M_INSTITUTE.INSTITUTE_NAME,
M_ORGANIZATION.INSTITUTE_NAME AS PARTNER_INS_OTHER_NAME,
MM.MOU_ID,
MM.MOU_NAME,
MM.MOU_EFFECT_DATE,
MM.MOU_EXPIRE_DATE,
MM.MOU_DU_MONTH,
MM.MOU_DURATION,
MM.MOU_AUTO_RENEWAL,
MM.UNSPECIFIED,
WF_FILE.FILE_SAVE_NAME,
MOU_LEVEL,
LEVEL_KU_CAMPUS,
MOU_CAMPUS_ETC,
LEVEL_KU_OFFICE,
MOU_OFFICE_ETC,
LEVEL_KU_INS,
MOU_LEVEL_INS
FROM M_MOU MM
LEFT JOIN FRM_COOPERATIVE_ORG FCO ON MM.MOU_ID = FCO.WFR_ID AND FCO.WF_MAIN_ID = 108 AND FCO.CO_PARTNER_INSTITUTE::INTEGER != 0
LEFT JOIN M_CONTINENT ON FCO.CO_PARTNER_CONTINENT::INTEGER = M_CONTINENT.CONTINENT_ID
LEFT JOIN M_COUNTRY ON FCO.CO_PARTNER_COUNTRY = M_COUNTRY.COUNTRY_NAME
LEFT JOIN M_INSTITUTE ON FCO.CO_PARTNER_INSTITUTE::INTEGER = M_INSTITUTE.INSTITUTE_ID
LEFT JOIN M_ORGANIZATION ON FCO.CO_ORG_NAME::INTEGER = M_ORGANIZATION.ORGANIZATION_ID
LEFT JOIN M_MOU_LEVEL ON MM.MOU_LEVEL = M_MOU_LEVEL.MOU_LEVEL_ID::TEXT
LEFT JOIN FRM_KU_SUB FKS ON MM.MOU_ID = FKS.WFR_ID AND FKS.WF_MAIN_ID = '108'
LEFT JOIN M_FACULTY MF ON FKS.MOU_KU_FACULTY = MF.FACULTY_ID
LEFT JOIN FRM_PARTNER_SUB FPS ON MM.MOU_ID = FPS.WFR_ID AND FPS.WF_MAIN_ID = '108'
LEFT JOIN WF_FILE ON MM.MOU_ID = WF_FILE.WFR_ID AND WF_FILE.WF_MAIN_ID = '108' AND WF_FILE.WFS_FIELD_NAME = 'MOU_FILE' AND WF_FILE.FILE_STATUS = 'Y'
WHERE 1=1 AND M_CONTINENT.CONTINENT_ID = '4' AND SYSDATE >= ADD_MONTHS(MOU_EXPIRE_DATE ,- 6)
AND SYSDATE < MOU_EXPIRE_DATE Error Description: ERROR: column "sysdate" does not exist
LINE 29: ...ERE 1=1 AND M_CONTINENT.CONTINENT_ID = '4' AND SYSDATE >=...
^
