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: APPS.BIM_I_BGT_CAT_MV

Object Details

Object Name:	BIM_I_BGT_CAT_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.BIM_I_BGT_CAT_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_BIM_I_BGT_CAT_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_TX_DATA	SYS_OP_MAP_NONNULL("DUMMY1_FR") SYS_OP_MAP_NONNULL("DUMMY2_FR") SYS_OP_MAP_NONNULL("DUMMY3_FR") SYS_OP_MAP_NONNULL("DUMMY4_FR") SYS_OP_MAP_NONNULL("DUMMY5_FR") SYS_OP_MAP_NONNULL("CATEGORY_ID") SYS_OP_MAP_NONNULL("PARENT_CATEGORY_ID") SYS_OP_MAP_NONNULL("FUND_ID") SYS_OP_MAP_NONNULL("PARENT_FUND_ID") SYS_OP_MAP_NONNULL("LEAF_NODE_FLAG") SYS_OP_MAP_NONNULL("DUMMY6_FR")
BIM_I_BGT_CAT_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID PERIOD_TYPE_ID PARENT_CATEGORY_ID LEAF_NODE_FLAG CATEGORY_ID

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 does not reference any database object

APPS.BIM_I_BGT_CAT_MV is referenced by following:

APPS: BIM_I_BGT_CAT_MV