[Home] [Help] [Dependency Information]

TABLE: OSM.AS_PROMOTIONS_ALL

Object Details

Object Name:	AS_PROMOTIONS_ALL
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_PROMOTIONS_ALL
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_PROMOTIONS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	PROMOTION_ID
AS_PROMOTIONS_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CODE ORG_ID
AS_PROMOTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	OWNER_PERSON_ID
AS_PROMOTIONS_N10	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_MAILBLITZ_ID
AS_PROMOTIONS_N11	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	COLLATERAL_INVENTORY_ITEM_ID COLLATERAL_ORGANIZATION_ID ORG_ID
AS_PROMOTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TYPE NAME
AS_PROMOTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_NAME_ID
AS_PROMOTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_COORDIN_PERSON_ID
AS_PROMOTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_FACILITY_ID
AS_PROMOTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_FAC_ROOM_ID
AS_PROMOTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_FAC_STAFF_ID
AS_PROMOTIONS_N9	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_SCRIPT_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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
,      SCRIPT_EVENT_EVAL_FLAG
,      EVENT_MAILBLITZ_ID
,      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 OSM.AS_PROMOTIONS_ALL;

Dependencies

[top of page]

OSM.AS_PROMOTIONS_ALL does not reference any database object

OSM.AS_PROMOTIONS_ALL is referenced by following:

OSM

AS_PROMOTIONS_ALL#