(Expired) All
|
| 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
INNER JOIN FRM_PARTNER_INS FPI ON MM.MOU_ID = FPI.WFR_ID AND FPI.WF_MAIN_ID = 108
LEFT JOIN M_CONTINENT ON FPI.PARTNER_CONTINENT = M_CONTINENT.CONTINENT_ID
LEFT JOIN M_COUNTRY ON FPI.PARTNER_COUNTRY = M_COUNTRY.COUNTRY_ID
LEFT JOIN M_INSTITUTE ON FPI.PARTNER_INSTITUTE = M_INSTITUTE.INSTITUTE_ID
LEFT JOIN M_MOU_LEVEL ON MM.MOU_LEVEL = to_char(M_MOU_LEVEL.MOU_LEVEL_ID)
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 PARTNER_INSTITUTE != 0 AND FPI.PARTNER_CONTINENT in ('1','2','3','4','5','6') AND ((SYSDATE > MOU_EXPIRE_DATE) AND (MOU_DU_UNSPEC IS NULL)) 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
INNER JOIN FRM_COOPERATIVE_ORG FCO ON MM.MOU_ID = FCO.WFR_ID AND FCO.WF_MAIN_ID = 108
LEFT JOIN M_CONTINENT ON FCO.CO_PARTNER_CONTINENT = 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 = M_INSTITUTE.INSTITUTE_ID
LEFT JOIN M_ORGANIZATION ON FCO.CO_ORG_NAME = M_ORGANIZATION.ORGANIZATION_ID
LEFT JOIN M_MOU_LEVEL ON MM.MOU_LEVEL = to_char(M_MOU_LEVEL.MOU_LEVEL_ID)
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 CO_PARTNER_INSTITUTE != 0 AND FCO.CO_PARTNER_CONTINENT in ('1','2','3','4','5','6') AND ((SYSDATE > MOU_EXPIRE_DATE) AND (MOU_DU_UNSPEC IS NULL)) Error Description: ERROR: operator does not exist: character varying = numeric
LINE 21: ... LEFT JOIN M_CONTINENT ON FPI.PARTNER_CONTINENT = M_CONTIN...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
