Product: | AS - Sales Foundation |
---|---|
Description: | Scripts view |
Implementation/DBA Data: | Not implemented in this database |
SELECT P.ROWID
, P.PROMOTION_ID
, P.CODE
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, P.NAME
, P.TYPE
, P.ENABLED_FLAG
, P.OWNER_PERSON_ID
, P.COUNTRY
, P.STATUS
, P.LANGUAGE
, P.CURRENCY_CODE
, P.EXPECTED_PROMOTION_COST
, P.ACTUAL_PROMOTION_COST
, P.EXPECTED_REACH
, P.EXPECTED_NUM_OF_RESPONSES
, P.ACTUAL_NUM_OF_RESPONSES
, P.DESCRIPTION
, P.SCRIPT_TYPE
, P.SCRIPT_LETTER_ID
, P.SCRIPT_EVENT_EVAL_FLAG
, P.ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, LKUP1.MEANING
, LKUP2.MEANING
, T.TERRITORY_SHORT_NAME
, L.CODE
, L.NAME
, LKUP3.MEANING
, LKUP3.DESCRIPTION
FROM AS_LOOKUPS LKUP1
, AS_LOOKUPS LKUP2
, FND_TERRITORIES_TL T
, AS_LOOKUPS LKUP3
, AS_PROMOTIONS P
, AS_PROMOTIONS L
WHERE P.TYPE = 'S'
AND P.STATUS = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'SCRIPT_STATUS'
AND P.COUNTRY = T.TERRITORY_CODE(+)
AND T.LANGUAGE(+) = USERENV('LANG')
AND P.LANGUAGE = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'LANGUAGE'
AND P.SCRIPT_LETTER_ID = L.PROMOTION_ID(+)
AND P.SCRIPT_TYPE = LKUP3.LOOKUP_CODE(+)
AND LKUP3.LOOKUP_TYPE(+) = 'SCRIPT_TYPE'