[Home] [Help]
View: AS_PROMOTION_CODES_V
| Product: | AS - Sales Foundation |
|---|
| Description: | Promotion codes view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PROM.PROMOTION_ID
, PROM.CODE
, LOOK.MEANING
, PROM.NAME
, PROM.TYPE
, PROM.DESCRIPTION
, PROM.ENABLED_FLAG
, DECODE(PROM.ENABLED_FLAG
, 'Y'
, '*'
, NULL)
FROM AS_PROMOTIONS PROM
, AS_LOOKUPS LOOK
WHERE PROM.TYPE = LOOK.LOOKUP_CODE
AND LOOK.LOOKUP_TYPE = 'PROMOTION_TYPE'
Columns
| Name |
| PROMOTION_ID |
| CODE |
| TYPE |
| NAME |
| TYPE_CODE |
| DESCRIPTION |
| ENABLED_FLAG |
| ENABLED |