eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OSM.AS_PROMOTIONS_ALL#

Source

View Text - Preformatted


select PROMOTION_ID PROMOTION_ID, CODE CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, NAME NAME, TYPE TYPE, ENABLED_FLAG ENABLED_FLAG, COUNTRY COUNTRY, STATUS STATUS, LANGUAGE LANGUAGE, CURRENCY_CODE CURRENCY_CODE, EXPECTED_PROMOTION_COST EXPECTED_PROMOTION_COST, EXPECTED_NUM_OF_RESPONSES EXPECTED_NUM_OF_RESPONSES, ACTUAL_PROMOTION_COST ACTUAL_PROMOTION_COST, ACTUAL_NUM_OF_RESPONSES ACTUAL_NUM_OF_RESPONSES, COMMENTS COMMENTS, DESCRIPTION DESCRIPTION, LONG_DESCRIPTION LONG_DESCRIPTION, OWNER_PERSON_ID OWNER_PERSON_ID, ASSIGN_PERSON_ID ASSIGN_PERSON_ID, PUBLIC_FLAG PUBLIC_FLAG, WORD_PROCESSOR_ID WORD_PROCESSOR_ID, EXTERNAL_FILE_NAME EXTERNAL_FILE_NAME, EXPECTED_REACH EXPECTED_REACH, AD_RUN_DATE_START AD_RUN_DATE_START, AD_RUN_DATE_END AD_RUN_DATE_END, AD_AGENCY_NAME AD_AGENCY_NAME, AD_MEDIA_TYPE AD_MEDIA_TYPE, AD_PUBLICATION_TYPE AD_PUBLICATION_TYPE, AD_PUBLICATION_NAME AD_PUBLICATION_NAME, BLITZ_TYPE BLITZ_TYPE, COLLATERAL_INVENTORY_FLAG COLLATERAL_INVENTORY_FLAG, COLLATERAL_QTY_ON_HAND COLLATERAL_QTY_ON_HAND, COLLATERAL_PICK_FLAG COLLATERAL_PICK_FLAG, COLLATERAL_ONLINE_FLAG COLLATERAL_ONLINE_FLAG, COLLATERAL_INVENTORY_ITEM_ID COLLATERAL_INVENTORY_ITEM_ID, COLLATERAL_ORGANIZATION_ID COLLATERAL_ORGANIZATION_ID, COLLATERAL_KIT_FLAG COLLATERAL_KIT_FLAG, COLLATERAL_CHARGEBACK_AMT COLLATERAL_CHARGEBACK_AMT, LETTER_PURPOSE_CODE LETTER_PURPOSE_CODE, SCRIPT_TYPE SCRIPT_TYPE, SCRIPT_LETTER_ID SCRIPT_LETTER_ID, CALLBLITZ_LIST_ID CALLBLITZ_LIST_ID, MAILBLITZ_DONOTMAIL_FLAG MAILBLITZ_DONOTMAIL_FLAG, EVENT_NAME_ID EVENT_NAME_ID, EVENT_FOOD_AVAILABLE_FLAG EVENT_FOOD_AVAILABLE_FLAG, EVENT_COORDIN_PERSON_ID EVENT_COORDIN_PERSON_ID, EVENT_FACILITY_ID EVENT_FACILITY_ID, EVENT_FAC_ROOM_ID EVENT_FAC_ROOM_ID, EVENT_FAC_ROOM_NAME EVENT_FAC_ROOM_NAME, EVENT_FAC_STAFF_ID EVENT_FAC_STAFF_ID, EVENT_FAC_STAFF_LAST EVENT_FAC_STAFF_LAST, EVENT_FAC_STAFF_FIRST EVENT_FAC_STAFF_FIRST, EVENT_FAC_STAFF_ACODE EVENT_FAC_STAFF_ACODE, EVENT_FAC_STAFF_PHONE EVENT_FAC_STAFF_PHONE, EVENT_FAC_STAFF_EXT EVENT_FAC_STAFF_EXT, EVENT_START_DATE EVENT_START_DATE, EVENT_START_TIME EVENT_START_TIME, EVENT_END_DATE EVENT_END_DATE, EVENT_END_TIME EVENT_END_TIME, EVENT_REG_TIME EVENT_REG_TIME, EVENT_ENROLLMENT_FEE EVENT_ENROLLMENT_FEE, EVENT_ENROLLMENT_FROZEN_FLAG EVENT_ENROLLMENT_FROZEN_FLAG, EVENT_MAX_ATTENDEES EVENT_MAX_ATTENDEES, EVENT_OVERBOOK_PERCENT EVENT_OVERBOOK_PERCENT, EVENT_NUM_REGISTERED EVENT_NUM_REGISTERED, EVENT_SCRIPT_ID EVENT_SCRIPT_ID, PRICE_LIST_ID PRICE_LIST_ID, SCRIPT_EVENT_EVAL_FLAG SCRIPT_EVENT_EVAL_FLAG, EVENT_MAILBLITZ_ID EVENT_MAILBLITZ_ID, ORG_ID ORG_ID, PRIORITY PRIORITY, CALL_START_DATE CALL_START_DATE, CALL_END_DATE CALL_END_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15 from "OSM"."AS_PROMOTIONS_ALL"

View Text - HTML Formatted

SELECT PROMOTION_ID PROMOTION_ID
, CODE CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, NAME NAME
, TYPE TYPE
, ENABLED_FLAG ENABLED_FLAG
, COUNTRY COUNTRY
, STATUS STATUS
, LANGUAGE LANGUAGE
, CURRENCY_CODE CURRENCY_CODE
, EXPECTED_PROMOTION_COST EXPECTED_PROMOTION_COST
, EXPECTED_NUM_OF_RESPONSES EXPECTED_NUM_OF_RESPONSES
, ACTUAL_PROMOTION_COST ACTUAL_PROMOTION_COST
, ACTUAL_NUM_OF_RESPONSES ACTUAL_NUM_OF_RESPONSES
, COMMENTS COMMENTS
, DESCRIPTION DESCRIPTION
, LONG_DESCRIPTION LONG_DESCRIPTION
, OWNER_PERSON_ID OWNER_PERSON_ID
, ASSIGN_PERSON_ID ASSIGN_PERSON_ID
, PUBLIC_FLAG PUBLIC_FLAG
, WORD_PROCESSOR_ID WORD_PROCESSOR_ID
, EXTERNAL_FILE_NAME EXTERNAL_FILE_NAME
, EXPECTED_REACH EXPECTED_REACH
, AD_RUN_DATE_START AD_RUN_DATE_START
, AD_RUN_DATE_END AD_RUN_DATE_END
, AD_AGENCY_NAME AD_AGENCY_NAME
, AD_MEDIA_TYPE AD_MEDIA_TYPE
, AD_PUBLICATION_TYPE AD_PUBLICATION_TYPE
, AD_PUBLICATION_NAME AD_PUBLICATION_NAME
, BLITZ_TYPE BLITZ_TYPE
, COLLATERAL_INVENTORY_FLAG COLLATERAL_INVENTORY_FLAG
, COLLATERAL_QTY_ON_HAND COLLATERAL_QTY_ON_HAND
, COLLATERAL_PICK_FLAG COLLATERAL_PICK_FLAG
, COLLATERAL_ONLINE_FLAG COLLATERAL_ONLINE_FLAG
, COLLATERAL_INVENTORY_ITEM_ID COLLATERAL_INVENTORY_ITEM_ID
, COLLATERAL_ORGANIZATION_ID COLLATERAL_ORGANIZATION_ID
, COLLATERAL_KIT_FLAG COLLATERAL_KIT_FLAG
, COLLATERAL_CHARGEBACK_AMT COLLATERAL_CHARGEBACK_AMT
, LETTER_PURPOSE_CODE LETTER_PURPOSE_CODE
, SCRIPT_TYPE SCRIPT_TYPE
, SCRIPT_LETTER_ID SCRIPT_LETTER_ID
, CALLBLITZ_LIST_ID CALLBLITZ_LIST_ID
, MAILBLITZ_DONOTMAIL_FLAG MAILBLITZ_DONOTMAIL_FLAG
, EVENT_NAME_ID EVENT_NAME_ID
, EVENT_FOOD_AVAILABLE_FLAG EVENT_FOOD_AVAILABLE_FLAG
, EVENT_COORDIN_PERSON_ID EVENT_COORDIN_PERSON_ID
, EVENT_FACILITY_ID EVENT_FACILITY_ID
, EVENT_FAC_ROOM_ID EVENT_FAC_ROOM_ID
, EVENT_FAC_ROOM_NAME EVENT_FAC_ROOM_NAME
, EVENT_FAC_STAFF_ID EVENT_FAC_STAFF_ID
, EVENT_FAC_STAFF_LAST EVENT_FAC_STAFF_LAST
, EVENT_FAC_STAFF_FIRST EVENT_FAC_STAFF_FIRST
, EVENT_FAC_STAFF_ACODE EVENT_FAC_STAFF_ACODE
, EVENT_FAC_STAFF_PHONE EVENT_FAC_STAFF_PHONE
, EVENT_FAC_STAFF_EXT EVENT_FAC_STAFF_EXT
, EVENT_START_DATE EVENT_START_DATE
, EVENT_START_TIME EVENT_START_TIME
, EVENT_END_DATE EVENT_END_DATE
, EVENT_END_TIME EVENT_END_TIME
, EVENT_REG_TIME EVENT_REG_TIME
, EVENT_ENROLLMENT_FEE EVENT_ENROLLMENT_FEE
, EVENT_ENROLLMENT_FROZEN_FLAG EVENT_ENROLLMENT_FROZEN_FLAG
, EVENT_MAX_ATTENDEES EVENT_MAX_ATTENDEES
, EVENT_OVERBOOK_PERCENT EVENT_OVERBOOK_PERCENT
, EVENT_NUM_REGISTERED EVENT_NUM_REGISTERED
, EVENT_SCRIPT_ID EVENT_SCRIPT_ID
, PRICE_LIST_ID PRICE_LIST_ID
, SCRIPT_EVENT_EVAL_FLAG SCRIPT_EVENT_EVAL_FLAG
, EVENT_MAILBLITZ_ID EVENT_MAILBLITZ_ID
, ORG_ID ORG_ID
, PRIORITY PRIORITY
, CALL_START_DATE CALL_START_DATE
, CALL_END_DATE CALL_END_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
FROM "OSM"."AS_PROMOTIONS_ALL"