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.MLOG$_BIM_I_MARKETING_FACT

Object Details

Object Name:	MLOG$_BIM_I_MARKETING_FACT
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

snapshot log for master table BIM.BIM_I_MARKETING_FACTS

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
ACTIVITY_ID	NUMBER
ACTIVITY_TYPE	VARCHAR2	(30)
ATTENDANCE	NUMBER
BUDGET_APPROVED	NUMBER
BUDGET_REQUESTED	NUMBER
BUSINESS_UNIT_ID	NUMBER
CANCELLATIONS	NUMBER
CATEGORY_ID	NUMBER
CHILD_OBJECT_COUNTRY	VARCHAR2	(30)
CHILD_OBJECT_ID	NUMBER
CHILD_OBJECT_PURPOSE	VARCHAR2	(240)
CHILD_OBJECT_REGION	VARCHAR2	(30)
CHILD_OBJECT_STATUS	VARCHAR2	(30)
CHILD_OBJECT_TYPE	VARCHAR2	(30)
COST_ACTUAL	NUMBER
COST_FORECASTED	NUMBER
CUSTOMERS_TARGETED	NUMBER
END_DATE	DATE
OBJECT_COUNTRY	VARCHAR2	(30)
OBJECT_ID	NUMBER
OBJECT_PURPOSE	VARCHAR2	(240)
OBJECT_REGION	VARCHAR2	(30)
OBJECT_STATUS	VARCHAR2	(30)
OBJECT_TYPE	VARCHAR2	(30)
OPPORTUNITIES	NUMBER
OPPORTUNITIES_OPEN	NUMBER
OPPORTUNITY_AMT	NUMBER
REGISTRATIONS	NUMBER
RESPONSES_FORECASTED	NUMBER
RESPONSES_POSITIVE	NUMBER
REVENUE_ACTUAL	NUMBER
REVENUE_FORECASTED	NUMBER
SOURCE_CODE_ID	NUMBER
START_DATE	DATE
TRANSACTION_CREATE_DATE	DATE
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)
BUDGET_APPROVED_S	NUMBER
BUDGET_REQUESTED_S	NUMBER
COST_ACTUAL_S	NUMBER
COST_FORECASTED_S	NUMBER
METRIC1	NUMBER
METRIC2	NUMBER
REVENUE_ACTUAL_S	NUMBER
REVENUE_FORECASTED_S	NUMBER

Query Text

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


SELECT ACTIVITY_ID
,      ACTIVITY_TYPE
,      ATTENDANCE
,      BUDGET_APPROVED
,      BUDGET_REQUESTED
,      BUSINESS_UNIT_ID
,      CANCELLATIONS
,      CATEGORY_ID
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_ID
,      CHILD_OBJECT_PURPOSE
,      CHILD_OBJECT_REGION
,      CHILD_OBJECT_STATUS
,      CHILD_OBJECT_TYPE
,      COST_ACTUAL
,      COST_FORECASTED
,      CUSTOMERS_TARGETED
,      END_DATE
,      OBJECT_COUNTRY
,      OBJECT_ID
,      OBJECT_PURPOSE
,      OBJECT_REGION
,      OBJECT_STATUS
,      OBJECT_TYPE
,      OPPORTUNITIES
,      OPPORTUNITIES_OPEN
,      OPPORTUNITY_AMT
,      REGISTRATIONS
,      RESPONSES_FORECASTED
,      RESPONSES_POSITIVE
,      REVENUE_ACTUAL
,      REVENUE_FORECASTED
,      SOURCE_CODE_ID
,      START_DATE
,      TRANSACTION_CREATE_DATE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      BUDGET_APPROVED_S
,      BUDGET_REQUESTED_S
,      COST_ACTUAL_S
,      COST_FORECASTED_S
,      METRIC1
,      METRIC2
,      REVENUE_ACTUAL_S
,      REVENUE_FORECASTED_S
FROM BIM.MLOG$_BIM_I_MARKETING_FACT;

Dependencies

[top of page]

BIM.MLOG$_BIM_I_MARKETING_FACT does not reference any database object

BIM.MLOG$_BIM_I_MARKETING_FACT is referenced by following:

APPS: MLOG$_BIM_I_MARKETING_FACT