[Home] [Help] [Dependency Information]
Object Name: | BIM_I_BGT_FCT_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIM_I_BGT_FCT_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIM_I_BGT_FCT_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_TX_DATA |
SYS_OP_MAP_NONNULL("TRANSACTION_CREATE_DATE")
SYS_OP_MAP_NONNULL("FUND_ID") SYS_OP_MAP_NONNULL("FUND_TYPE") SYS_OP_MAP_NONNULL("PARENT_FUND_ID") SYS_OP_MAP_NONNULL("CATEGORY_ID") SYS_OP_MAP_NONNULL("LEAF_NODE_FLAG") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.BIM_I_BGT_FCT_MV does not reference any database object
APPS.BIM_I_BGT_FCT_MV is referenced by following:
|
|
|