SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT NSC.CONFLICT_ID, NSC.FIELD_ID, NSC.NOTICE_ID, NSC.OPTION_ID, NSC.NOTICE_VALUE, NSC.MASTER_NOTICE_ID, NSC.MASTER_OPTION_ID, NSC.MASTER_NOTICE_VALUE, NSC.CONFLICT_INDICATOR_CD, NSC.CONFLICT_TYPE_CD, NSC.MASTER_SECURITY_MOVEMENT_ID, NSC.SECURITY_MOVEMENT_ID, NSC.MASTER_CASH_MOVEMENT_ID, NSC.CASH_MOVEMENT_ID, NSC.COUNTRY_CD, NSC.DATE_RECEIVED, NSC.LAST_UPDATE_DATE, NSC.UPD_USER_ID, NSC.AGENDA_ID, NSC.MASTER_AGENDA_ID, NSC.PARTICIPATION_ID, NSC.MASTER_PARTICIPATION_ID, NSC.MEETING_DETAIL_ID, NSC.MASTER_MEETING_DETAIL_ID , NSF.FIELD_NAME, NSF.FIELD_DB_REFERENCE, NSF.FIELD_OBJECT_REFERENCE, EFI.INSTITUTION_NAME , NSF.FIELD_SEQUENCE, (CASE WHEN CAOPT.MESSAGE_OPTION_NUMBER IS NOT NULL THEN CAOPT.MESSAGE_OPTION_NUMBER ELSE NO.CA_OPTION_NUMBER END) AS OPTION_NUMBER, TTD.TYPE_DESCRIPTION, TTD1.TYPE_DESCRIPTION, TTD2.TYPE_DESCRIPTION, TTD3.TYPE_DESCRIPTION, N.MESSAGE_ID, ML.MESSAGE_REFERENCE, B.BRAND_NAME, MTA.ISSUER_LABEL FROM ((NOTICE N LEFT OUTER JOIN BRAND B ON N.SOURCE_TYPE_CD = B.BRAND_CD) LEFT OUTER JOIN EF_INSTITUTION EFI ON N.SOURCE = EFI.INSTITUTION_ID) , NOTICE_SRC_FIELD NSF, MSG_LOG ML, (((((NOTICE_SRC_CONFLICT NSC LEFT OUTER JOIN NOTICE_OPTION NO ON NO.OPTION_ID = (CASE WHEN NSC.FIELD_ID = ? THEN NSC.MASTER_OPTION_ID ELSE NSC.OPTION_ID END ) LEFT OUTER JOIN MEETING_AGENDA MTA ON MTA.AGENDA_ID = (CASE WHEN NSC.AGENDA_ID IS NULL THEN NSC.MASTER_AGENDA_ID ELSE NSC.AGENDA_ID END ) LEFT OUTER JOIN CORP_ACTION_OPTION CAOPT ON NO.CAMA_OPTION_ID = CAOPT.OPTION_ID AND CAOPT.STATUS_CD = 'CAES_ACT') LEFT OUTER JOIN TYPE_TABLE_DESCRIPTION TTD ON TTD.TYPE_CD = NO.CA_OPTION_CODE AND TTD.LANGUAGE_CD = 'LANG_ENG') LEFT OUTER JOIN TYPE_TABLE_DESCRIPTION TTD1 ON TTD1.TYPE_CD = NO.CA_OPTION_CODE AND TTD1.LANGUAGE_CD = 'LANG_ENG') LEFT OUTER JOIN TYPE_TABLE_DESCRIPTION TTD2 ON TTD2.TYPE_CD = NSC.NOTICE_VALUE AND TTD2.LANGUAGE_CD = 'LANG_ENG') LEFT OUTER JOIN TYPE_TABLE_DESCRIPTION TTD3 ON TTD3.TYPE_CD = NSC.MASTER_NOTICE_VALUE AND TTD3.LANGUAGE_CD = 'LANG_ENG') WHERE NSC.MASTER_NOTICE_ID = (SELECT MAX(N.NOTICE_ID) FROM NOTICE N, NOTICE_SRC_CONFLICT NSC2 WHERE N.CORPORATE_ACTION_ID = ? AND N.MASTER_NOTICE_FLAG = 'Y' AND NSC2.MASTER_NOTICE_ID = N.NOTICE_ID) AND NSF.FIELD_ID = NSC.FIELD_ID AND N.NOTICE_ID = NSC.NOTICE_ID AND NSC.CONFLICT_INDICATOR_CD = ? AND ML.MESSAGE_ID = N.MESSAGE_ID AND NSC.CONFLICT_TYPE_CD = ? AND ((NSC.CONFLICT_INDICATOR_CD IN (?,?) AND NSC.CONFLICT_ID IN ( SELECT MAX(NSC1.CONFLICT_ID) FROM NOTICE_SRC_CONFLICT NSC1 WHERE NSC1.MASTER_NOTICE_ID +0= NSC.MASTER_NOTICE_ID AND NSC1.NOTICE_ID = NSC.NOTICE_ID AND NSC1.FIELD_ID = NSC.FIELD_ID AND NSC1.CONFLICT_TYPE_CD = NSC.CONFLICT_TYPE_CD AND NSC1.CONFLICT_INDICATOR_CD = NSC.CONFLICT_INDICATOR_CD AND NSC.NOTICE_VALUE = NSC1.NOTICE_VALUE AND NVL(NSC.OPTION_ID,0) = NVL(NSC1.OPTION_ID,0) AND NVL(NSC.SECURITY_MOVEMENT_ID,0) = NVL(NSC1.SECURITY_MOVEMENT_ID,0) AND NVL(NSC.CASH_MOVEMENT_ID,0) = NVL(NSC1.CASH_MOVEMENT_ID,0) )) OR (NSC.CONFLICT_INDICATOR_CD NOT IN (?, ?))) ORDER BY NSF.FIELD_NAME, NSF.FIELD_SEQUENCE
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear