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: BIM.BIM_EDW_EVTFRCST_FSTG

Object Details

Object Name:	BIM_EDW_EVTFRCST_FSTG
Object Type:	TABLE
Owner:	BIM
FND Design Data:	BIM.BIM_EDW_EVTFRCST_FSTG
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_EDW_EVTFRCST_FSTG_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	COLLECTION_STATUS

Columns

Name	Datatype	Length	Comments
EVTFRCST_PK	VARCHAR2	(320)	Unique identifier for event forecast fact .
CMPGN_FK	VARCHAR2	(320)	Foreign key to Campaign dimension .
CMPGN_FK_KEY	NUMBER		System generated foreign key to Campaign dimension .
CMPGN_STATUS_FK	VARCHAR2	(240)	Foreign key to Campaign status dimension .
CMPGN_STATUS_FK_KEY	NUMBER		System generated foreign key to Campaign status dimension .
EVENT_FK	VARCHAR2	(320)	Foreign key to Event dimension .
EVENT_FK_KEY	NUMBER		System generated foreign key to Event dimension .
MEDCHNL_FK	VARCHAR2	(320)	Foreign key to Media Channel dimension .
MEDCHNL_FK_KEY	NUMBER		System generated foreign key to Media Channel dimension .
MKTSGMT_FK	VARCHAR2	(240)	Foreign key to Market Segment dimension .
MKTSGMT_FK_KEY	NUMBER		System generated foreign key to Market Segment dimension .
TGTSGMT_FK	VARCHAR2	(120)	Foreign key to target segment dimension .
TGTSGMT_FK_KEY	NUMBER		System generated foreign key to target segment dimension .
SRCLST_FK	VARCHAR2	(320)	Foreign key to Source List dimension .
SRCLST_FK_KEY	NUMBER		System generated foreign key to Surce List dimension .
OFFER_FK	VARCHAR2	(320)	Foreign key to Marketing Offer dimension .
OFFER_FK_KEY	NUMBER		System generated foreign key to Marketing Offer dimension .
CUSTOMER_FK	VARCHAR2	(320)	Foreign key to Trading Partner dimension .
CUSTOMER_FK_KEY	NUMBER		System generated foreign key to Trading Partner dimension .
TIME_FK	VARCHAR2	(120)	Foreign key to Time dimension .
TIME_FK_KEY	NUMBER		System generated foreign key to Time dimension .
ORG_FK	VARCHAR2	(120)	Foreign Key to Internal Organization dimension .
ORG_FK_KEY	NUMBER		System generated foreign key to Internal Organization dimension .
ITEM_FK	VARCHAR2	(320)	Foreign Key to Item dimension .
ITEM_FK_KEY	NUMBER		System generated foreign key to Item dimension .
UOM_FK	VARCHAR2	(40)	Foreign key to UOM dimension .
UOM_FK_KEY	NUMBER		System generated foreign key to UOM dimension .
SLSCHNL_FK	VARCHAR2	(120)	Foreign Key to Sales Channel dimension .
SLSCHNL_FK_KEY	NUMBER		System generated foreign key to Sales Channel dimension .
BASE_CURRENCY_FK	VARCHAR2	(20)	Foreign key to Currency dimension .
BASE_CURRENCY_FK_KEY	NUMBER		System generated foreign key to Currency dimension .
GLOBAL_CURRENCY_FK	VARCHAR2	(20)	Foreign key to Currency dimension .
GLOBAL_CURRENCY_FK_KEY	NUMBER		System generated foreign key to Currency dimension .
TRX_CURRENCY_FK	VARCHAR2	(20)	Foreign key to Currency dimension .
TRX_CURRENCY_FK_KEY	NUMBER		System generated foreign key to Currency dimension .
BILL_TO_SITE_FK	VARCHAR2	(240)	Foreign Key to Geography dimension .
BILL_TO_SITE_FK_KEY	NUMBER		System generated foreign key to Geography dimension .
SHIP_TO_SITE_FK	VARCHAR2	(240)	Foreign Key to Geography dimension .
SHIP_TO_SITE_FK_KEY	NUMBER		System generated foreign key to Geography dimension .
INSTANCE_FK	VARCHAR2	(40)	Foreign Key to Instance dimension .
INSTANCE_FK_KEY	NUMBER		System generated foreign key to Instance dimension .
EVENT_ACTUAL_COST_G	NUMBER		Actual Cost of the Event in global currency .
EVENT_ACTUAL_COST_B	NUMBER		Actual Cost of the Event in base currency .
EVENT_ACTUAL_COST_T	NUMBER		Actual Cost of the Event in transaction currency .
EVENT_FRCST_COST_G	NUMBER		Forecast Cost of the Event in global currency .
EVENT_FRCST_COST_B	NUMBER		Forecast Cost of the Event in base currency .
EVENT_FRCST_COST_T	NUMBER		Forecast Cost of the Event in transaction currency .
EVENT_FRCST_REVENUE_G	NUMBER		Forecast Revenue of the Event in global currency .
EVENT_FRCST_REVENUE_B	NUMBER		Forecast Revenue of the Event in base currency .
EVENT_FRCST_REVENUE_T	NUMBER		Forecast Revenue of the Event in transaction currency .
EVENT_NUMBER_ENROLLED	NUMBER		Total number enrolled in the event .
EVENT_NUMBER_CANCELLED	NUMBER		Total number of cancellations for the event .
EVENT_NUMBER_AVAILABLE	NUMBER		Total number of available seats for the event .
EVENT_NUMBER_ATTENDED	NUMBER		Total number of attendees for the event .
USER_MEASURE1	NUMBER		User defined measure .
USER_MEASURE2	NUMBER		User defined measure .
USER_MEASURE3	NUMBER		User defined measure .
USER_MEASURE4	NUMBER		User defined measure .
USER_MEASURE5	NUMBER		User defined measure .
USER_FK1	VARCHAR2	(2000)	Foreign key to user defined dimension .
USER_FK1_KEY	NUMBER		System generated foreign key for user defined dimension .
USER_FK2	VARCHAR2	(2000)	Foreign key to user defined dimension .
USER_FK2_KEY	NUMBER		System generated foreign key for user defined dimension .
USER_FK3	VARCHAR2	(2000)	Foreign key to user defined dimension .
USER_FK3_KEY	NUMBER		System generated foreign key for user defined dimension .
USER_FK4	VARCHAR2	(2000)	Foreign key to user defined dimension .
USER_FK4_KEY	NUMBER		System generated foreign key for user defined dimension .
USER_FK5	VARCHAR2	(2000)	Foreign key to user defined dimension .
USER_FK5_KEY	NUMBER		System generated foreign key for user defined dimension .
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE6	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE7	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE8	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE9	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE10	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE11	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE12	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE13	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE14	VARCHAR2	(240)	User defined attribute .
USER_ATTRIBUTE15	VARCHAR2	(240)	User defined attribute .
REQUEST_ID	NUMBER		Standard Who Column .
ROW_ID	ROWID	(10)	Row Identifier .
OPERATION_CODE	VARCHAR2	(30)	Code used during warehouse collection .
ERROR_CODE	VARCHAR2	(2000)	Code used to store error messages .
COLLECTION_STATUS	VARCHAR2	(30)	Collection status code for the record .
SECURITY_GROUP_ID	NUMBER		Standard Who Column .

Query Text

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


SELECT EVTFRCST_PK
,      CMPGN_FK
,      CMPGN_FK_KEY
,      CMPGN_STATUS_FK
,      CMPGN_STATUS_FK_KEY
,      EVENT_FK
,      EVENT_FK_KEY
,      MEDCHNL_FK
,      MEDCHNL_FK_KEY
,      MKTSGMT_FK
,      MKTSGMT_FK_KEY
,      TGTSGMT_FK
,      TGTSGMT_FK_KEY
,      SRCLST_FK
,      SRCLST_FK_KEY
,      OFFER_FK
,      OFFER_FK_KEY
,      CUSTOMER_FK
,      CUSTOMER_FK_KEY
,      TIME_FK
,      TIME_FK_KEY
,      ORG_FK
,      ORG_FK_KEY
,      ITEM_FK
,      ITEM_FK_KEY
,      UOM_FK
,      UOM_FK_KEY
,      SLSCHNL_FK
,      SLSCHNL_FK_KEY
,      BASE_CURRENCY_FK
,      BASE_CURRENCY_FK_KEY
,      GLOBAL_CURRENCY_FK
,      GLOBAL_CURRENCY_FK_KEY
,      TRX_CURRENCY_FK
,      TRX_CURRENCY_FK_KEY
,      BILL_TO_SITE_FK
,      BILL_TO_SITE_FK_KEY
,      SHIP_TO_SITE_FK
,      SHIP_TO_SITE_FK_KEY
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      EVENT_ACTUAL_COST_G
,      EVENT_ACTUAL_COST_B
,      EVENT_ACTUAL_COST_T
,      EVENT_FRCST_COST_G
,      EVENT_FRCST_COST_B
,      EVENT_FRCST_COST_T
,      EVENT_FRCST_REVENUE_G
,      EVENT_FRCST_REVENUE_B
,      EVENT_FRCST_REVENUE_T
,      EVENT_NUMBER_ENROLLED
,      EVENT_NUMBER_CANCELLED
,      EVENT_NUMBER_AVAILABLE
,      EVENT_NUMBER_ATTENDED
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_FK1
,      USER_FK1_KEY
,      USER_FK2
,      USER_FK2_KEY
,      USER_FK3
,      USER_FK3_KEY
,      USER_FK4
,      USER_FK4_KEY
,      USER_FK5
,      USER_FK5_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      REQUEST_ID
,      ROW_ID
,      OPERATION_CODE
,      ERROR_CODE
,      COLLECTION_STATUS
,      SECURITY_GROUP_ID
FROM BIM.BIM_EDW_EVTFRCST_FSTG;

Dependencies

[top of page]

BIM.BIM_EDW_EVTFRCST_FSTG does not reference any database object

BIM.BIM_EDW_EVTFRCST_FSTG is referenced by following:

APPS: BIM_EDW_EVTFRCST_FSTG