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_CAT_MV

Object Details

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

M-View Details

Container:	BIM_I_BGT_CAT_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_BGT_CAB_MV
     BIM_I_BUDGETS_DENORM
     BIM_I_BUDGET_FACTS
FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length
TIME_ID	NUMBER
PERIOD_TYPE_ID	NUMBER
FUND_ID	NUMBER
PARENT_FUND_ID	NUMBER
CATEGORY_ID	NUMBER
LEAF_NODE_FLAG	VARCHAR2	(1)
PARENT_CATEGORY_ID	NUMBER
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
DUMMY1_FR	NUMBER
DUMMY2_FR	NUMBER
DUMMY3_FR	NUMBER
DUMMY4_FR	NUMBER
DUMMY5_FR	NUMBER
DUMMY6_FR	NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      FUND_ID
,      PARENT_FUND_ID
,      CATEGORY_ID
,      LEAF_NODE_FLAG
,      PARENT_CATEGORY_ID
,      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
,      DUMMY1_FR
,      DUMMY2_FR
,      DUMMY3_FR
,      DUMMY4_FR
,      DUMMY5_FR
,      DUMMY6_FR
FROM APPS.BIM_I_BGT_CAT_MV;

Dependencies

[top of page]

APPS.BIM_I_BGT_CAT_MV references the following:

APPS: BIM_I_BGT_CAB_MV; BIM_I_BGT_CAB_MV; BIM_I_BGT_CAT_MV
FII: FII_TIME_DAY

APPS.BIM_I_BGT_CAT_MV is not referenced by any database object