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_OPRNTIES_F

Object Details

Object Name:	BIM_EDW_OPRNTIES_F
Object Type:	TABLE
Owner:	BIM
FND Design Data:	BIM.BIM_EDW_OPRNTIES_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_OPRNTIES_F_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	OPPR_LINE_PK
BIM_EDW_OPRNTIES_F_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CMPGN_FK_KEY
BIM_EDW_OPRNTIES_F_N10	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SLSCHNL_FK_KEY
BIM_EDW_OPRNTIES_F_N11	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TIME_FK_KEY
BIM_EDW_OPRNTIES_F_N12	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CUSTOMER_FK_KEY
BIM_EDW_OPRNTIES_F_N13	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	MKTSGMT_FK_KEY
BIM_EDW_OPRNTIES_F_N14	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BILL_TO_SITE_FK_KEY
BIM_EDW_OPRNTIES_F_N15	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BASE_CURRENCY_FK_KEY
BIM_EDW_OPRNTIES_F_N16	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SRCLST_FK_KEY
BIM_EDW_OPRNTIES_F_N17	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	OPPLINE_FK_KEY
BIM_EDW_OPRNTIES_F_N18	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	OPPSTATUS_FK_KEY
BIM_EDW_OPRNTIES_F_N19	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	INSTANCE_FK_KEY
BIM_EDW_OPRNTIES_F_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ITEM_FK_KEY
BIM_EDW_OPRNTIES_F_N20	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	GLOBAL_CURRENCY_FK_KEY
BIM_EDW_OPRNTIES_F_N21	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SHIP_TO_SITE_FK_KEY
BIM_EDW_OPRNTIES_F_N22	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TRX_CURRENCY_FK_KEY
BIM_EDW_OPRNTIES_F_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	UOM_FK_KEY
BIM_EDW_OPRNTIES_F_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EVENT_FK_KEY
BIM_EDW_OPRNTIES_F_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	MDCHNL_FK_KEY
BIM_EDW_OPRNTIES_F_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CMPGN_STATUS_FK_KEY
BIM_EDW_OPRNTIES_F_N7	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	OFFER_FK_KEY
BIM_EDW_OPRNTIES_F_N8	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TGTSGMT_FK_KEY
BIM_EDW_OPRNTIES_F_N9	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORG_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
OPPR_LINE_PK_KEY	NUMBER			System generated unique identifier for opportunity fact .
OPPR_LINE_PK	VARCHAR2	(320)		Unique identifier for opportunity 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 .
MDCHNL_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 .
OFFER_FK_KEY	NUMBER			System generated foreign key to Marketing Offer dimension .
OPPLINE_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 .
INSTANCE_FK_KEY	NUMBER		Yes	System generated foreign key to Instance dimension .
OPPR_AMOUNT_G	NUMBER			Expected sales amount for the opportuntiy in global currency .
OPPR_AMOUNT_B	NUMBER			Expected sales amount for the opportuntiy in base currency .
OPPR_AMOUNT_T	NUMBER			Expected sales amount for the opportuntiy in transaction currency .
OPPR_UNITS	NUMBER			Expected number of units to be sold for the opportunity .
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			Standard Who Column .

Query Text

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


SELECT OPPR_LINE_PK_KEY
,      OPPR_LINE_PK
,      CMPGN_FK_KEY
,      CMPGN_STATUS_FK_KEY
,      EVENT_FK_KEY
,      MDCHNL_FK_KEY
,      MKTSGMT_FK_KEY
,      TGTSGMT_FK_KEY
,      SRCLST_FK_KEY
,      OFFER_FK_KEY
,      OPPLINE_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
,      INSTANCE_FK_KEY
,      OPPR_AMOUNT_G
,      OPPR_AMOUNT_B
,      OPPR_AMOUNT_T
,      OPPR_UNITS
,      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
FROM BIM.BIM_EDW_OPRNTIES_F;

Dependencies

[top of page]

BIM.BIM_EDW_OPRNTIES_F does not reference any database object

BIM.BIM_EDW_OPRNTIES_F is referenced by following:

APPS: BIM_EDW_OPRNTIES_F