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_CAB_MV

Object Details

Object Name:	BIM_I_BGT_CAB_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.BIM_I_BGT_CAB_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_CAB_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_TX_DATA	SYS_OP_MAP_NONNULL("TRANSACTION_CREATE_DATE") 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")

Columns

Name	Datatype	Length
TRANSACTION_CREATE_DATE	DATE
FUND_ID	NUMBER
PARENT_FUND_ID	NUMBER
CATEGORY_ID	NUMBER
PARENT_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
,      PARENT_FUND_ID
,      CATEGORY_ID
,      PARENT_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_CAB_MV;

Dependencies

[top of page]

APPS.BIM_I_BGT_CAB_MV does not reference any database object

APPS.BIM_I_BGT_CAB_MV is referenced by following:

APPS: BIM_I_BGT_CAB_MV; BIM_I_BGT_CAT_MV