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

TABLE: APPS.BIM_R_FD_SUMMARY_MV

Object Details
Object Name: BIM_R_FD_SUMMARY_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FUND_ID NUMBER

FUND_NAME VARCHAR2 (240)
PARENT_FUND_ID NUMBER

FUND_NUMBER VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

START_PERIOD VARCHAR2 (30)
END_PERIOD VARCHAR2 (30)
FUND_TYPE VARCHAR2 (30)
AREA1_CODE VARCHAR2 (30)
AREA2_CODE VARCHAR2 (30)
COUNTRY_CODE VARCHAR2 (30)
CATEGORY_ID NUMBER

STATUS VARCHAR2 (30)
MONTH VARCHAR2 (30)
QTR VARCHAR2 (30)
YEAR VARCHAR2 (30)
AGGREGATE_BY VARCHAR2 (9)
ORIGINAL_BUDGET NUMBER

HOLDBACK_AMT NUMBER

CURRENCY_CODE_FC VARCHAR2 (15)
TOTAL_BUDGET NUMBER

AVAILABLE_BUDGET NUMBER

PRE_BALANCE NUMBER

BALANCE NUMBER

PRE_COMMITED NUMBER

COMMITED NUMBER

PRE_UTILIZED NUMBER

UTILIZED NUMBER

PLANNED NUMBER

PAID NUMBER

DISPLAY_TYPE VARCHAR2 (7)
BUSINESS_UNIT_ID NUMBER

RESOURCE_ID NUMBER

Query Text

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


SELECT FUND_ID
,      FUND_NAME
,      PARENT_FUND_ID
,      FUND_NUMBER
,      START_DATE
,      END_DATE
,      START_PERIOD
,      END_PERIOD
,      FUND_TYPE
,      AREA1_CODE
,      AREA2_CODE
,      COUNTRY_CODE
,      CATEGORY_ID
,      STATUS
,      MONTH
,      QTR
,      YEAR
,      AGGREGATE_BY
,      ORIGINAL_BUDGET
,      HOLDBACK_AMT
,      CURRENCY_CODE_FC
,      TOTAL_BUDGET
,      AVAILABLE_BUDGET
,      PRE_BALANCE
,      BALANCE
,      PRE_COMMITED
,      COMMITED
,      PRE_UTILIZED
,      UTILIZED
,      PLANNED
,      PAID
,      DISPLAY_TYPE
,      BUSINESS_UNIT_ID
,      RESOURCE_ID
FROM APPS.BIM_R_FD_SUMMARY_MV;

Dependencies

[top of page]

APPS.BIM_R_FD_SUMMARY_MV does not reference any database object

APPS.BIM_R_FD_SUMMARY_MV is not referenced by any database object