eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AS_PROMOTION_LETTERS_V

Product:	AS - Sales Foundation
Description:	Promotion letters view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PROM.PROMOTION_ID
, PROM.CODE
, PROM.NAME
, PROM.TYPE
, PROM.ENABLED_FLAG
, PROM.DESCRIPTION
, PROM.OWNER_PERSON_ID
, PROM.PUBLIC_FLAG
, PROM.WORD_PROCESSOR_ID
, WP.WORD_PROCESSOR_ID
FROM AS_WORD_PROCESSORS WP
, AS_PROMOTIONS PROM
WHERE PROM.TYPE = 'L'
AND PROM.ENABLED_FLAG = 'Y'
AND PROM.WORD_PROCESSOR_ID = WP.WORD_PROCESSOR_ID

Columns

Name
PROMOTION_ID
PROMOTION_CODE
PROMOTION_NAME
PROMOTION_TYPE
PROMOTION_ENABLED_FLAG
PROMOTION_DESCRIPTION
PROMOTION_OWNER_PERSON_ID
PROMOTION_PUBLIC_FLAG
PROMOTION_WORD_PROCESSOR_ID
WP_WORD_PROCESSOR_ID