Product: | AS - Sales Foundation |
---|---|
Description: | Promotions view (multi-org) |
Implementation/DBA Data: | Not implemented in this database |
SELECT PROMOTION_ID
, CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, NAME
, TYPE
, ENABLED_FLAG
, COUNTRY
, STATUS
, LANGUAGE
, CURRENCY_CODE
, EXPECTED_PROMOTION_COST
, EXPECTED_NUM_OF_RESPONSES
, ACTUAL_PROMOTION_COST
, ACTUAL_NUM_OF_RESPONSES
, COMMENTS
, DESCRIPTION
, LONG_DESCRIPTION
, OWNER_PERSON_ID
, ASSIGN_PERSON_ID
, PUBLIC_FLAG
, WORD_PROCESSOR_ID
, EXTERNAL_FILE_NAME
, EXPECTED_REACH
, AD_RUN_DATE_START
, AD_RUN_DATE_END
, AD_AGENCY_NAME
, AD_MEDIA_TYPE
, AD_PUBLICATION_TYPE
, AD_PUBLICATION_NAME
, BLITZ_TYPE
, COLLATERAL_INVENTORY_FLAG
, COLLATERAL_QTY_ON_HAND
, COLLATERAL_PICK_FLAG
, COLLATERAL_ONLINE_FLAG
, COLLATERAL_INVENTORY_ITEM_ID
, COLLATERAL_ORGANIZATION_ID
, COLLATERAL_KIT_FLAG
, COLLATERAL_CHARGEBACK_AMT
, LETTER_PURPOSE_CODE
, SCRIPT_TYPE
, SCRIPT_LETTER_ID
, CALLBLITZ_LIST_ID
, MAILBLITZ_DONOTMAIL_FLAG
, EVENT_NAME_ID
, EVENT_FOOD_AVAILABLE_FLAG
, EVENT_COORDIN_PERSON_ID
, EVENT_FACILITY_ID
, EVENT_FAC_ROOM_ID
, EVENT_FAC_ROOM_NAME
, EVENT_FAC_STAFF_ID
, EVENT_FAC_STAFF_LAST
, EVENT_FAC_STAFF_FIRST
, EVENT_FAC_STAFF_ACODE
, EVENT_FAC_STAFF_PHONE
, EVENT_FAC_STAFF_EXT
, EVENT_START_DATE
, EVENT_START_TIME
, EVENT_END_DATE
, EVENT_END_TIME
, EVENT_REG_TIME
, EVENT_ENROLLMENT_FEE
, EVENT_ENROLLMENT_FROZEN_FLAG
, EVENT_MAX_ATTENDEES
, EVENT_OVERBOOK_PERCENT
, EVENT_NUM_REGISTERED
, EVENT_SCRIPT_ID
, PRICE_LIST_ID
, EVENT_MAILBLITZ_ID
, SCRIPT_EVENT_EVAL_FLAG
, ORG_ID
, PRIORITY
, CALL_START_DATE
, CALL_END_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM AS_PROMOTIONS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)