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_BUDGET_FACTS

Object Details

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

snapshot log for master table BIM.BIM_I_BUDGET_FACTS

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
ACCRUAL	NUMBER
CATEGORY_ID	NUMBER
COMMITTED	NUMBER
FUND_ID	NUMBER
HOLDBACK_AMT	NUMBER
ORIGINAL_BUDGET	NUMBER
PARENT_FUND_ID	NUMBER
PLANNED	NUMBER
TRANSACTION_CREATE_DATE	DATE
TRANSFER_IN	NUMBER
TRANSFER_OUT	NUMBER
UTILIZED	NUMBER
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)
ACCRUAL_S	NUMBER
COMMITTED_S	NUMBER
HOLDBACK_AMT_S	NUMBER
ORIGINAL_BUDGET_S	NUMBER
PLANNED_S	NUMBER
TRANSFER_IN_S	NUMBER
TRANSFER_OUT_S	NUMBER
UTILIZED_S	NUMBER

Query Text

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


SELECT ACCRUAL
,      CATEGORY_ID
,      COMMITTED
,      FUND_ID
,      HOLDBACK_AMT
,      ORIGINAL_BUDGET
,      PARENT_FUND_ID
,      PLANNED
,      TRANSACTION_CREATE_DATE
,      TRANSFER_IN
,      TRANSFER_OUT
,      UTILIZED
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      ACCRUAL_S
,      COMMITTED_S
,      HOLDBACK_AMT_S
,      ORIGINAL_BUDGET_S
,      PLANNED_S
,      TRANSFER_IN_S
,      TRANSFER_OUT_S
,      UTILIZED_S
FROM BIM.MLOG$_BIM_I_BUDGET_FACTS;

Dependencies

[top of page]

BIM.MLOG$_BIM_I_BUDGET_FACTS does not reference any database object

BIM.MLOG$_BIM_I_BUDGET_FACTS is referenced by following:

APPS: MLOG$_BIM_I_BUDGET_FACTS