VIEW: APPS.ALR_INSTALLATIONS_VIEW

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'