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_RVCT_DLY_F

Object Details

Object Name:	BIM_EDW_RVCT_DLY_F
Object Type:	TABLE
Owner:	BIM
FND Design Data:	BIM.BIM_EDW_RVCT_DLY_F
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_RVCT_DLY_F_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CMPGN_FK_KEY ITEM_FK_KEY UOM_FK_KEY EVENT_FK_KEY MEDCHNL_FK_KEY CMPGN_STATUS_FK_KEY LEAD_FK_KEY LEADSTATUS_FK_KEY OPPORTUNITY_FK_KEY OPPSTATUS_FK_KEY HEADER_OFFER_FK_KEY TGTSGMT_FK_KEY ORG_FK_KEY SLSCHNL_FK_KEY TIME_FK_KEY CUSTOMER_FK_KEY MKTSGMT_FK_KEY BILL_TO_SITE_FK_KEY TRX_CURRENCY_FK_KEY SRCLST_FK_KEY LINE_OFFER_FK_KEY BASE_CURRENCY_FK_KEY SHIP_TO_SITE_FK_KEY GLOBAL_CURRENCY_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
REVCOST_PK_KEY	NUMBER			System generated unique identifier for daily derived fact .
REVCOST_PK	VARCHAR2	(320)		Unique identifier for daily derived fact .
CMPGN_FK_KEY	NUMBER		Yes	System generated foreign key to Campaign dimension .
CMPGN_STATUS_FK_KEY	NUMBER		Yes	System generated foreign key to Campaign status dimension .
EVENT_FK_KEY	NUMBER		Yes	System generated foreign key to Event dimension .
MEDCHNL_FK_KEY	NUMBER		Yes	System generated foreign key to Media Channel dimension .
MKTSGMT_FK_KEY	NUMBER		Yes	System generated foreign key to Market Segment dimension .
TGTSGMT_FK_KEY	NUMBER		Yes	System generated foreign key to target segment dimension .
SRCLST_FK_KEY	NUMBER		Yes	System generated foreign key to Surce List dimension .
HEADER_OFFER_FK_KEY	NUMBER		Yes	System generated foreign key to Marketing Offer dimension .
LINE_OFFER_FK_KEY	NUMBER		Yes	System generated foreign key to Marketing Offer dimension .
LEAD_FK_KEY	NUMBER		Yes	System generated foreign key to Lead dimension .
LEADSTATUS_FK_KEY	NUMBER		Yes	System generated foreign key to Lead Status dimension .
OPPORTUNITY_FK_KEY	NUMBER		Yes	System generated foreign key to Opportunity dimension .
OPPSTATUS_FK_KEY	NUMBER		Yes	System generated foreign key to Opportunity Status dimension .
CUSTOMER_FK_KEY	NUMBER		Yes	System generated foreign key to Trading Partner dimension .
TIME_FK_KEY	NUMBER		Yes	System generated foreign key to Time dimension .
ORG_FK_KEY	NUMBER		Yes	System generated foreign key to Internal Organization dimension .
ITEM_FK_KEY	NUMBER		Yes	System generated foreign key to Item dimension .
UOM_FK_KEY	NUMBER		Yes	System generated foreign key to UOM dimension .
SLSCHNL_FK_KEY	NUMBER		Yes	System generated foreign key to Sales Channel dimension .
BASE_CURRENCY_FK_KEY	NUMBER		Yes	System generated foreign key to Currency dimension .
GLOBAL_CURRENCY_FK_KEY	NUMBER		Yes	System generated foreign key to Currency dimension .
TRX_CURRENCY_FK_KEY	NUMBER		Yes	System generated foreign key to Currency dimension .
BILL_TO_SITE_FK_KEY	NUMBER		Yes	System generated foreign key to Geography dimension .
SHIP_TO_SITE_FK_KEY	NUMBER		Yes	System generated foreign key to Geography dimension .
CMPGN_ACTUAL_COST_G	NUMBER			Actual Cost of the Campaign in global currency .
CMPGN_ACTUAL_COST_T	NUMBER			Actual Cost of the Campaign in transaction currency .
CMPGN_ACTUAL_COST_B	NUMBER			Actual Cost of the Campaign in base currency .
CMPGN_FRCST_COST_G	NUMBER			Forecast Cost of the Campaign in global currency .
CMPGN_FRCST_COST_T	NUMBER			Forecast Cost of the Campaign in transaction currency .
CMPGN_FRCST_COST_B	NUMBER			Forecast Cost of the Campaign in base currency .
CMPGN_FRCST_REVENUE_G	NUMBER			Forecast Revenue of the Campaign in global currency .
CMPGN_FRCST_REVENUE_T	NUMBER			Forecast Revenue of the Campaign in transaction currency .
CMPGN_FRCST_REVENUE_B	NUMBER			Forecast Revenue of the Campaign in base currency .
EVENT_ACTUAL_COST_G	NUMBER			Actual Cost of the event in global currency .
EVENT_ACTUAL_COST_T	NUMBER			Actual Cost of the event in transaction currency .
EVENT_ACTUAL_COST_B	NUMBER			Actual Cost of the event in base currency .
EVENT_REGISTRATION_REVENUE_G	NUMBER			Registration revenue of the event in global currency .
EVENT_REGISTRATION_REVENUE_T	NUMBER			Registration revenue of the event in transaction currency .
EVENT_REGISTRATION_REVENUE_B	NUMBER			Registration revenue of the event in base currency .
EVENT_FRCST_COST_G	NUMBER			Forecast Cost of the event in global currency .
EVENT_FRCST_COST_T	NUMBER			Forecast Cost of the event in transaction currency .
EVENT_FRCST_COST_B	NUMBER			Forecast Cost of the event in base currency .
EVENT_FRCST_REVENUE_G	NUMBER			Forecast Revenue of the event in global currency .
EVENT_FRCST_REVENUE_T	NUMBER			Forecast Revenue of the event in transaction currency .
EVENT_FRCST_REVENUE_B	NUMBER			Forecast Revenue of the event in base currency .
EVENT_NUMBER_ENROLLED	NUMBER			Total number enrolled in the event .
EVENT_NUMBER_AVAILABLE	NUMBER			Total number of available seats in the event .
EVENT_NUMBER_CANCELLED	NUMBER			Total number of cancellations in the event .
EVENT_NUMBER_ATTENDED	NUMBER			Total number of attendees in the event .
NUMBER_TARGETED	NUMBER			Total number of targets .
NUMBER_RESPONDED	NUMBER			Total number of responses .
LEAD_AMOUNT_G	NUMBER			Expected amount of sales for the lead in global currency .
LEAD_AMOUNT_T	NUMBER			Expected amount of sales for the lead in transaction currency .
LEAD_AMOUNT_B	NUMBER			Expected amount of sales for the lead in base currency .
OPPORTUNITY_AMOUNT_G	NUMBER			Expected amount of sales for the opportunity in global currency .
OPPORTUNITY_AMOUNT_B	NUMBER			Expected amount of sales for the opportunity in base currency .
OPPORTUNITY_AMOUNT_T	NUMBER			Expected amount of sales for the opportunity in transaction currency .
SLIST_ACTUAL_COST_G	NUMBER			Not Used .
SLIST_ACTUAL_COST_T	NUMBER			Not Used .
SLIST_ACTUAL_COST_B	NUMBER			Not Used .
COGS_G	NUMBER			Not Used .
COGS_T	NUMBER			Not Used .
COGS_B	NUMBER			Not Used .
ACTUAL_REVENUE_G	NUMBER			Actual Revenue in global currency .
ACTUAL_REVENUE_T	NUMBER			Actual Revenue in transaction currency .
ACTUAL_REVENUE_B	NUMBER			Actual Revenue in base currency .
INITIATED_REVENUE_G	NUMBER			Initiated Revenue in global currency .
INITIATED_REVENUE_T	NUMBER			Initiated Revenue in transaction currency .
INITIATED_REVENUE_B	NUMBER			Initiated Revenue in base currency .
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_KEY	NUMBER			System generated foreign key for user defined dimension .
USER_FK2_KEY	NUMBER			System generated foreign key for user defined dimension .
USER_FK3_KEY	NUMBER			System generated foreign key for user defined dimension .
USER_FK4_KEY	NUMBER			System generated foreign key for 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 .
CREATION_DATE	DATE		Yes	Standard Who Column .
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column .
SECURITY_GROUP_ID	NUMBER			.
INITIATED_COGS_G	NUMBER			Initiated COGS in global currency .
INITIATED_COGS_B	NUMBER			Initiated COGS in base currency .
INITIATED_COGS_T	NUMBER			Initiated COGS in transaction currency .
ACTUAL_COGS_G	NUMBER			Actual COGS in global currency .
ACTUAL_COGS_B	NUMBER			Actual COGS in base currency .
ACTUAL_COGS_T	NUMBER			Actual COGS in transaction currency .
INITIATED_ORDER_AMT_G	NUMBER
INITIATED_ORDER_AMT_B	NUMBER
INITIATED_ORDER_AMT_T	NUMBER
ACTUAL_ORDER_AMT_G	NUMBER
ACTUAL_ORDER_AMT_B	NUMBER
ACTUAL_ORDER_AMT_T	NUMBER
INITIATED_NO_OF_ORDERS	NUMBER
ACTUAL_NO_OF_ORDERS	NUMBER

Query Text

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


SELECT REVCOST_PK_KEY
,      REVCOST_PK
,      CMPGN_FK_KEY
,      CMPGN_STATUS_FK_KEY
,      EVENT_FK_KEY
,      MEDCHNL_FK_KEY
,      MKTSGMT_FK_KEY
,      TGTSGMT_FK_KEY
,      SRCLST_FK_KEY
,      HEADER_OFFER_FK_KEY
,      LINE_OFFER_FK_KEY
,      LEAD_FK_KEY
,      LEADSTATUS_FK_KEY
,      OPPORTUNITY_FK_KEY
,      OPPSTATUS_FK_KEY
,      CUSTOMER_FK_KEY
,      TIME_FK_KEY
,      ORG_FK_KEY
,      ITEM_FK_KEY
,      UOM_FK_KEY
,      SLSCHNL_FK_KEY
,      BASE_CURRENCY_FK_KEY
,      GLOBAL_CURRENCY_FK_KEY
,      TRX_CURRENCY_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      CMPGN_ACTUAL_COST_G
,      CMPGN_ACTUAL_COST_T
,      CMPGN_ACTUAL_COST_B
,      CMPGN_FRCST_COST_G
,      CMPGN_FRCST_COST_T
,      CMPGN_FRCST_COST_B
,      CMPGN_FRCST_REVENUE_G
,      CMPGN_FRCST_REVENUE_T
,      CMPGN_FRCST_REVENUE_B
,      EVENT_ACTUAL_COST_G
,      EVENT_ACTUAL_COST_T
,      EVENT_ACTUAL_COST_B
,      EVENT_REGISTRATION_REVENUE_G
,      EVENT_REGISTRATION_REVENUE_T
,      EVENT_REGISTRATION_REVENUE_B
,      EVENT_FRCST_COST_G
,      EVENT_FRCST_COST_T
,      EVENT_FRCST_COST_B
,      EVENT_FRCST_REVENUE_G
,      EVENT_FRCST_REVENUE_T
,      EVENT_FRCST_REVENUE_B
,      EVENT_NUMBER_ENROLLED
,      EVENT_NUMBER_AVAILABLE
,      EVENT_NUMBER_CANCELLED
,      EVENT_NUMBER_ATTENDED
,      NUMBER_TARGETED
,      NUMBER_RESPONDED
,      LEAD_AMOUNT_G
,      LEAD_AMOUNT_T
,      LEAD_AMOUNT_B
,      OPPORTUNITY_AMOUNT_G
,      OPPORTUNITY_AMOUNT_B
,      OPPORTUNITY_AMOUNT_T
,      SLIST_ACTUAL_COST_G
,      SLIST_ACTUAL_COST_T
,      SLIST_ACTUAL_COST_B
,      COGS_G
,      COGS_T
,      COGS_B
,      ACTUAL_REVENUE_G
,      ACTUAL_REVENUE_T
,      ACTUAL_REVENUE_B
,      INITIATED_REVENUE_G
,      INITIATED_REVENUE_T
,      INITIATED_REVENUE_B
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      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
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      INITIATED_COGS_G
,      INITIATED_COGS_B
,      INITIATED_COGS_T
,      ACTUAL_COGS_G
,      ACTUAL_COGS_B
,      ACTUAL_COGS_T
,      INITIATED_ORDER_AMT_G
,      INITIATED_ORDER_AMT_B
,      INITIATED_ORDER_AMT_T
,      ACTUAL_ORDER_AMT_G
,      ACTUAL_ORDER_AMT_B
,      ACTUAL_ORDER_AMT_T
,      INITIATED_NO_OF_ORDERS
,      ACTUAL_NO_OF_ORDERS
FROM BIM.BIM_EDW_RVCT_DLY_F;

Dependencies

[top of page]

BIM.BIM_EDW_RVCT_DLY_F does not reference any database object

BIM.BIM_EDW_RVCT_DLY_F is referenced by following:

APPS: BIM_EDW_RVCT_DLY_F