View HLPDTEST.STATEGPS.T_APP_MAIL_SETUP_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Sun Jan 24 01:06 IST 2021 |
View Definition:
select APP.APPLICATION_ID,APP.APPLICATION_NAME,X.SMTP_HOST_ID,X.SMTP_HOST,Y.FROM_MAIL_ID_ID, Y.FROM_MAIL_ID FROM
(SELECT APPLICATION_ID,PROPERTY_ID SMTP_HOST_ID,PROPERTY_VALUE SMTP_HOST FROM t_gps_app_properties where PROPERTY_NAME = 'SMTP HOST') X,
(SELECT APPLICATION_ID,PROPERTY_ID FROM_MAIL_ID_ID,PROPERTY_VALUE FROM_MAIL_ID FROM t_gps_app_properties WHERE PROPERTY_NAME = 'FROM MAIL ID') Y,
T_GPS_APPLICATIONS APP
WHERE X.APPLICATION_ID = Y.APPLICATION_ID
AND APP.APPLICATION_ID = X.APPLICATION_ID
AND (APP.VISIBLE_FLAG IS NULL OR APP.VISIBLE_FLAG = 'true')
ORDER BY APP.APPLICATION_NAME
Possibly Referenced Tables/Views:
![]() ![]() |