View: ALR_INSTALLATIONS_VIEW

Product:	ALR - Alert
Description:
Implementation/DBA Data:	APPS.ALR_INSTALLATIONS_VIEW

View Text

SELECT I.APPLICATION_ID
, A.APPLICATION_NAME
, A.DESCRIPTION APPLICATION_DESCRIPTION
, O.ORACLE_ID
, O.ORACLE_USERNAME
, O.DESCRIPTION ORACLE_DESCRIPTION
, 3 ORDER_BY
FROM FND_ORACLE_USERID O
, FND_APPLICATION_VL A
, FND_PRODUCT_INSTALLATIONS I
WHERE I.ORACLE_ID = O.ORACLE_ID
AND I.APPLICATION_ID = A.APPLICATION_ID
AND I.STATUS IN ('I'
, 'L') UNION ALL SELECT -1
, D.MEANING
, D.DESCRIPTION
, DECODE(M.LOOKUP_CODE
, 'S'
, -2
, 'R'
, -1)
, M.MEANING
, M.DESCRIPTION
, 1 ORDER_BY
FROM ALR_LOOKUPS M
, ALR_LOOKUPS D
WHERE M.LOOKUP_TYPE = 'MAIL_ACCOUNTS'
AND D.LOOKUP_TYPE = 'DEFAULT_INSTALLATION'

Columns