Product: | ASF - Sales Online |
---|---|
Description: | Used for email popup |
Implementation/DBA Data: | Not implemented in this database |
SELECT EML.ROWID
, EML.CONTACT_POINT_ID
, EML.CONTACT_POINT_TYPE
, EML.STATUS
, CODE_STATUS.MEANING
, EML.OWNER_TABLE_NAME
, EML.OWNER_TABLE_ID
, EML.LAST_UPDATE_DATE /*
, TO_CHAR(EML.LAST_UPDATE_DATE
, 'YYYY-MM-DD HH:MI:SS')||'.0' */
, EML.LAST_UPDATED_BY
, EML.CREATION_DATE
, EML.CREATED_BY
, EML.EMAIL_FORMAT
, EML.EMAIL_ADDRESS
, EML.PRIMARY_FLAG
, EML.DO_NOT_USE_FLAG
, EML.LAST_UPDATE_LOGIN
, EML.REQUEST_ID
, EML.PROGRAM_APPLICATION_ID
, EML.PROGRAM_ID
, EML.PROGRAM_UPDATE_DATE
, EML.ORIG_SYSTEM_REFERENCE
, EML.ATTRIBUTE_CATEGORY
, EML.ATTRIBUTE1
, EML.ATTRIBUTE2
, EML.ATTRIBUTE3
, EML.ATTRIBUTE4
, EML.ATTRIBUTE5
, EML.ATTRIBUTE6
, EML.ATTRIBUTE7
, EML.ATTRIBUTE8
, EML.ATTRIBUTE9
, EML.ATTRIBUTE10
, EML.ATTRIBUTE11
, EML.ATTRIBUTE12
, EML.ATTRIBUTE13
, EML.ATTRIBUTE14
, EML.ATTRIBUTE15
FROM HZ_CONTACT_POINTS EML
, AR_LOOKUPS CODE_STATUS
WHERE EML.CONTACT_POINT_TYPE = 'EMAIL'
AND EML.STATUS = CODE_STATUS.LOOKUP_CODE(+)
AND CODE_STATUS.LOOKUP_TYPE(+) = 'CODE_STATUS'
AND EML.STATUS IN ('A'
, 'I')