[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 |