[Home] [Help]
View: AS_PROMOTIONS_ACTIVE_V
Product: | AS - Sales Foundation |
Description: | Active promotions view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PROM.PROMOTION_ID
, PROM.CODE
, ASLKP.MEANING
, PROM.NAME
, PROM.TYPE
, PROM.PUBLIC_FLAG
, PROM.OWNER_PERSON_ID
, PROM.STATUS
, PROM.DESCRIPTION
FROM AS_PROMOTIONS PROM
, AS_LOOKUPS ASLKP
WHERE PROM.ENABLED_FLAG ='Y'
AND PROM.TYPE = ASLKP.LOOKUP_CODE
AND ASLKP.LOOKUP_TYPE = 'PROMOTION_TYPE'
Columns
Name |
PROMOTION_ID |
CODE |
TYPE |
NAME |
TYPE_CODE |
PUBLIC_FLAG |
OWNER_PERSON_ID |
STATUS_CODE |
DESCRIPTION |