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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OZF.OZF_ACTIVITY_HL_DENORM

Object Details

Object Name:	OZF_ACTIVITY_HL_DENORM
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_ACTIVITY_HL_DENORM
Subobject Name:
Status:	VALID

OZF_ACTIVITY_HL_DENORM stores the change information of Campaign Schedules of type Deal and Trade Promotions. This table is used when incremental refresh is given as a parameter for the Trade Management Activity Denorm program

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_ACTIVITY_HL_DENORM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCHEDULE_ID
OZF_ACTIVITY_HL_DENORM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCHEDULE_UPDATE_DATE
OZF_ACTIVITY_HL_DENORM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCHEDULE_STATUS
OZF_ACTIVITY_HL_DENORM_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID
OZF_ACTIVITY_HL_DENORM_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE
OZF_ACTIVITY_HL_DENORM_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_HL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_HL_ID	NUMBER			Unique Identifier
SCHEDULE_ID	NUMBER			Schedule Identifier
CAMPAIGN_ID	NUMBER		Yes	Campaign Identifier
CAMPAIGN_STATUS	VARCHAR2	(30)		Campaign Status
CAMPAIGN_CLASS	VARCHAR2	(30)		Campaign Class
CAMPAIGN_TYPE	VARCHAR2	(30)		Campaign Type
CAMPAIGN_NAME	VARCHAR2	(240)		Campaign Name
ITEM	NUMBER			Item Identifier for the value given in Item Type
ITEM_TYPE	VARCHAR2	(30)		Type of Product Identifier. Valid values are ITEM for Inventory Item. FAMILY for Product category
LIST_HEADER_ID	NUMBER		Yes	Offer Identifier
CONFIDENTIAL_FLAG	VARCHAR2	(1)		Offer confidential flag
CUSTOM_SETUP_ID	NUMBER			Custom Setup Identifier
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER			Standard WHO Column
CREATION_DATE	DATE			Standard WHO Column
CREATED_BY	NUMBER			Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
SCHEDULE_STATUS	VARCHAR2	(30)		Status of the schedule
SCHEDULE_UPDATE_DATE	DATE			Date when the schedule was last updated
PRODUCT_UPDATE_DATE	DATE			Date when the product eligibility of a schedule was last updated
LIST_UPDATE_DATE	DATE			Date when the list attached to the schedule was last genereated.

Query Text

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


SELECT ACTIVITY_HL_ID
,      SCHEDULE_ID
,      CAMPAIGN_ID
,      CAMPAIGN_STATUS
,      CAMPAIGN_CLASS
,      CAMPAIGN_TYPE
,      CAMPAIGN_NAME
,      ITEM
,      ITEM_TYPE
,      LIST_HEADER_ID
,      CONFIDENTIAL_FLAG
,      CUSTOM_SETUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SCHEDULE_STATUS
,      SCHEDULE_UPDATE_DATE
,      PRODUCT_UPDATE_DATE
,      LIST_UPDATE_DATE
FROM OZF.OZF_ACTIVITY_HL_DENORM;

Dependencies

[top of page]

OZF.OZF_ACTIVITY_HL_DENORM does not reference any database object

OZF.OZF_ACTIVITY_HL_DENORM is referenced by following:

APPS: OZF_ACTIVITY_HL_DENORM