[Home] [Help] [Dependency Information]
Object Name: | BIM_I_BGT_LVL_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIM_I_BGT_LVL_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIM_I_BGT_FCT_MV
BIM_I_BUDGETS_DENORM
BIM_I_BUDGET_FACTS
FII_TIME_DAY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
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 | |||
DUMMY1_FR | NUMBER | |||
DUMMY2_FR | NUMBER | |||
DUMMY3_FR | NUMBER | |||
DUMMY4_FR | NUMBER | |||
DUMMY5_FR | NUMBER | |||
DUMMY6_FR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, 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
, DUMMY1_FR
, DUMMY2_FR
, DUMMY3_FR
, DUMMY4_FR
, DUMMY5_FR
, DUMMY6_FR
FROM APPS.BIM_I_BGT_LVL_MV;
APPS.BIM_I_BGT_LVL_MV is not referenced by any database object
|
|
|