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]

MATERIALIZED VIEW: APPS.BIM_I_BGT_FCT_MV

Object Details

Object Name:	BIM_I_BGT_FCT_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	BIM_I_BGT_FCT_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	GENERAL
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


BIM_I_BUDGETS_DENORM
BIM_I_BUDGET_FACTS

[View Source Query]

Columns

Name	Datatype	Length
TRANSACTION_CREATE_DATE	DATE
FUND_ID	NUMBER
FUND_TYPE	VARCHAR2	(30)
PARENT_FUND_ID	NUMBER
CATEGORY_ID	NUMBER
LEAF_NODE_FLAG	VARCHAR2	(1)
ORIGINAL_BUDGET	NUMBER
ORIGINAL_BUDGET_C	NUMBER
HOLDBACK	NUMBER
HOLDBACK_C	NUMBER
TRANSFER_IN	NUMBER
TRANSFER_IN_C	NUMBER
TRANSFER_OUT	NUMBER
TRANSFER_OUT_C	NUMBER
ACCRUAL	NUMBER
ACCRUAL_C	NUMBER
COMMITTED	NUMBER
COMMITTED_C	NUMBER
PLANNED	NUMBER
PLANNED_C	NUMBER
UTILIZED	NUMBER
UTILIZED_C	NUMBER
ORIGINAL_BUDGET_S	NUMBER
ORIGINAL_BUDGET_S_C	NUMBER
HOLDBACK_S	NUMBER
HOLDBACK_S_C	NUMBER
TRANSFER_IN_S	NUMBER
TRANSFER_IN_S_C	NUMBER
TRANSFER_OUT_S	NUMBER
TRANSFER_OUT_S_C	NUMBER
ACCRUAL_S	NUMBER
ACCRUAL_S_C	NUMBER
COMMITTED_S	NUMBER
COMMITTED_S_C	NUMBER
PLANNED_S	NUMBER
PLANNED_S_C	NUMBER
UTILIZED_S	NUMBER
UTILIZED_S_C	NUMBER
COUNT_ALL	NUMBER

Query Text

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


SELECT TRANSACTION_CREATE_DATE
,      FUND_ID
,      FUND_TYPE
,      PARENT_FUND_ID
,      CATEGORY_ID
,      LEAF_NODE_FLAG
,      ORIGINAL_BUDGET
,      ORIGINAL_BUDGET_C
,      HOLDBACK
,      HOLDBACK_C
,      TRANSFER_IN
,      TRANSFER_IN_C
,      TRANSFER_OUT
,      TRANSFER_OUT_C
,      ACCRUAL
,      ACCRUAL_C
,      COMMITTED
,      COMMITTED_C
,      PLANNED
,      PLANNED_C
,      UTILIZED
,      UTILIZED_C
,      ORIGINAL_BUDGET_S
,      ORIGINAL_BUDGET_S_C
,      HOLDBACK_S
,      HOLDBACK_S_C
,      TRANSFER_IN_S
,      TRANSFER_IN_S_C
,      TRANSFER_OUT_S
,      TRANSFER_OUT_S_C
,      ACCRUAL_S
,      ACCRUAL_S_C
,      COMMITTED_S
,      COMMITTED_S_C
,      PLANNED_S
,      PLANNED_S_C
,      UTILIZED_S
,      UTILIZED_S_C
,      COUNT_ALL
FROM APPS.BIM_I_BGT_FCT_MV;

Dependencies

[top of page]

APPS.BIM_I_BGT_FCT_MV references the following:

APPS: BIM_I_BGT_FCT_MV
BIM: BIM_I_BUDGETS_DENORM; BIM_I_BUDGET_FACTS

APPS.BIM_I_BGT_FCT_MV is referenced by following:

APPS: BIM_I_BGT_LVL_MV