Product: | AS - Sales Foundation |
---|---|
Description: | Promotions view |
Implementation/DBA Data: | Not implemented in this database |
SELECT PROM.ROWID
, PROM.PROMOTION_ID
, PROM.CODE
, PROM.LAST_UPDATE_DATE
, PROM.LAST_UPDATED_BY
, PROM.CREATION_DATE
, PROM.CREATED_BY
, PROM.LAST_UPDATE_LOGIN
, PROM.NAME
, PROM.TYPE
, PROM.ENABLED_FLAG
, PROM.COUNTRY
, PROM.STATUS
, PROM.CURRENCY_CODE
, PROM.EXPECTED_PROMOTION_COST
, PROM.ACTUAL_PROMOTION_COST
, PROM.EXPECTED_NUM_OF_RESPONSES
, PROM.ACTUAL_NUM_OF_RESPONSES
, PROM.EXPECTED_REACH
, PROM.DESCRIPTION
, PROM.ATTRIBUTE_CATEGORY
, PROM.ATTRIBUTE1
, PROM.ATTRIBUTE2
, PROM.ATTRIBUTE3
, PROM.ATTRIBUTE4
, PROM.ATTRIBUTE5
, PROM.ATTRIBUTE6
, PROM.ATTRIBUTE7
, PROM.ATTRIBUTE8
, PROM.ATTRIBUTE9
, PROM.ATTRIBUTE10
, PROM.ATTRIBUTE11
, PROM.ATTRIBUTE12
, PROM.ATTRIBUTE13
, PROM.ATTRIBUTE14
, PROM.ATTRIBUTE15
, FNDTERR.TERRITORY_SHORT_NAME
FROM AS_PROMOTIONS PROM
, FND_TERRITORIES_TL FNDTERR
WHERE PROM.TYPE = 'P'
AND PROM.COUNTRY = FNDTERR.TERRITORY_CODE(+)
AND FNDTERR.LANGUAGE(+) = USERENV('LANG')