Product: | AS - Sales Foundation |
---|---|
Description: | Letters 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.LETTER_PURPOSE_CODE
, PROM.OWNER_PERSON_ID
, PROM.PUBLIC_FLAG
, PROM.COUNTRY
, PROM.LANGUAGE
, PROM.EXPECTED_NUM_OF_RESPONSES
, PROM.ACTUAL_NUM_OF_RESPONSES
, PROM.DESCRIPTION
, PROM.WORD_PROCESSOR_ID
, PROM.EXTERNAL_FILE_NAME
, 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
, LOOK1.MEANING
, TERR.TERRITORY_SHORT_NAME
, WORD.WORD_PROCESSOR_NAME
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, WORD.PATH
, WORD.STARTUP_COMMAND
, WORD.LETTER_LOCATION_PATH
, WORD.SERVER_LETTER_LOC_PATH
, WORD.SERVER_MERGE_FILE_LOC_PATH
FROM AS_PROMOTIONS PROM
, FND_TERRITORIES_TL TERR
, AS_LOOKUPS LOOK1
, AS_WORD_PROCESSORS WORD
, PER_ALL_PEOPLE_F PEOPLE
WHERE PROM.LANGUAGE = LOOK1.LOOKUP_CODE(+)
AND LOOK1.LOOKUP_TYPE(+) = 'LANGUAGE'
AND PROM.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
AND PROM.WORD_PROCESSOR_ID = WORD.WORD_PROCESSOR_ID(+)
AND PROM.OWNER_PERSON_ID = PEOPLE.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+)
AND PEOPLE.EFFECTIVE_END_DATE(+)