[Home] [Help]
View: AS_MAIL_BLITZ_LETTERS_ACTIVE_V
| Product: | AS - Sales Foundation |
|---|
| Description: | Active mail blitzes view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT P.PROMOTION_ID
, P.CODE
, P.NAME
, P.PUBLIC_FLAG
, DECODE(P.PUBLIC_FLAG
, 'Y'
, '*'
, NULL)
, P.DESCRIPTION
, P.OWNER_PERSON_ID
FROM AS_PROMOTIONS P
WHERE TYPE = 'L'
AND LETTER_PURPOSE_CODE IN ('GENERIC_TOKEN'
, 'MAILBLITZ_TOKEN')
AND ENABLED_FLAG = 'Y'
Columns
| Name |
| LETTER_ID |
| CODE |
| NAME |
| PUBLIC_FLAG |
| PUBLIC_LETTER |
| DESCRIPTION |
| OWNER_PERSON_ID |