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_TRADE_TACTICS_MAPPING

Object Details

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

OZF_TRADE_TACTICS_MAPPING stores details all distinct trade medium ids and their respective column names to be used whilst determining best filt lift. This information is derived from ozf_lift_factor_facts table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_TRADE_TACTICS_MAPPING_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_SOURCE TRADE_TACTIC_ID TRADE_TACTIC_COLUMN_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TRADE_TACTICS_MAPPING_ID	NUMBER		Yes	Primary Key
DATA_SOURCE	VARCHAR2	(30)	Yes	Data Source Identifier: Look Code for 3rd Party Data Source as seeded in the extensible lookup
TRADE_TACTIC_COLUMN_NAME	VARCHAR2	(30)	Yes	Trade Medium Tactics Column Name
TRADE_TACTIC_ID	NUMBER		Yes	Trade Medium Tactics Id
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
CREATED_FROM	VARCHAR2	(30)		Standard Who Column

Query Text

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


SELECT TRADE_TACTICS_MAPPING_ID
,      DATA_SOURCE
,      TRADE_TACTIC_COLUMN_NAME
,      TRADE_TACTIC_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_FROM
FROM OZF.OZF_TRADE_TACTICS_MAPPING;

Dependencies

[top of page]

OZF.OZF_TRADE_TACTICS_MAPPING does not reference any database object

OZF.OZF_TRADE_TACTICS_MAPPING is referenced by following:

OZF: OZF_TRADE_TACTICS_MAPPING#