Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: BIM.BIM_R_FP_DIM_SUM_MV

Object Details
Object Name: BIM_R_FP_DIM_SUM_MV
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


Fund Dimension Summary MV


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_FP_DIM_SUM_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnBUSINESS_UNIT_ID
ColumnOBJECT_TYPE
ColumnYEAR
ColumnQTR
ColumnMONTH
ColumnAGGREGATE_BY
Columns
Name Datatype Length Mandatory Comments
FUND_COUNT NUMBER

Fund count
BUSINESS_UNIT_ID NUMBER

Business Unit identifier
OBJECT_TYPE VARCHAR2 (30)
Type of the object
YEAR VARCHAR2 (30)
Year
QTR VARCHAR2 (30)
Quarter
MONTH VARCHAR2 (30)
Month
MONTH_ORDER NUMBER

Month Order
AGGREGATE_BY VARCHAR2 (9)
Summation By
UTILIZED NUMBER

Utilized Amount
COMMITED_AMT NUMBER

Commited Amount
PLANNED_AMT NUMBER

Planned Amount
PAID_AMT NUMBER

Paid Amount
DISPLAY_TYPE VARCHAR2 (7)
Display Type
FUND_TYPE VARCHAR2 (30)
Type of the fund
AREA2_CODE VARCHAR2 (30)
Area 2 code
COUNTRY_CODE VARCHAR2 (30)
Country code
FUND_BUSINESS_ID NUMBER

Fund Business Identifier
CATEGORY_ID NUMBER

Category Identifier
STATUS VARCHAR2 (30)
Status
RESOURCE_ID NUMBER

Resource Identifier
Query Text

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


SELECT FUND_COUNT
,      BUSINESS_UNIT_ID
,      OBJECT_TYPE
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      UTILIZED
,      COMMITED_AMT
,      PLANNED_AMT
,      PAID_AMT
,      DISPLAY_TYPE
,      FUND_TYPE
,      AREA2_CODE
,      COUNTRY_CODE
,      FUND_BUSINESS_ID
,      CATEGORY_ID
,      STATUS
,      RESOURCE_ID
FROM BIM.BIM_R_FP_DIM_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_FP_DIM_SUM_MV does not reference any database object

BIM.BIM_R_FP_DIM_SUM_MV is referenced by following:

SchemaBIM
ViewBIM_R_FP_DIM_SUM_MV#