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

TABLE: BIM.BIM_R_FD_SUMMARY_MV_TEMP2

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


Temporary table which contains Fund Summary Information


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

Fund Identifier
FUND_NAME VARCHAR2 (240)
Name of the fund
PARENT_FUND_ID NUMBER

Parent fund identifier
FUND_NUMBER VARCHAR2 (30)
Fund number
START_DATE DATE

Start date
END_DATE DATE

End date
START_PERIOD VARCHAR2 (30)
Start period
END_PERIOD VARCHAR2 (30)
End period
FUND_TYPE VARCHAR2 (30)
Type of the fund
AREA1_CODE VARCHAR2 (30)
Area1 code
AREA2_CODE VARCHAR2 (30)
Area2 code
COUNTRY_CODE VARCHAR2 (30)
Country code
CATEGORY_ID NUMBER

Category Identifier
STATUS VARCHAR2 (30)
Status
MONTH VARCHAR2 (30)
Month
QTR VARCHAR2 (30)
Quarter
YEAR VARCHAR2 (30)
Year
AGGREGATE_BY VARCHAR2 (9)
Summation By
ORIGINAL_BUDGET NUMBER

Original Budget Amount
HOLDBACK_AMT NUMBER

Holdback Amount
CURRENCY_CODE_FC VARCHAR2 (15)
Currency code in functional currency
TOTAL_BUDGET NUMBER

Total Budget Amount
AVAILABLE_BUDGET NUMBER

Available budget amount
PRE_BALANCE NUMBER

pre balance
BALANCE NUMBER

balance
PRE_COMMITED NUMBER

pre commited
COMMITED NUMBER

commited
PRE_UTILIZED NUMBER

pre utilized
UTILIZED NUMBER

utilized
PLANNED NUMBER

planned
PAID NUMBER

paid amount
DISPLAY_TYPE VARCHAR2 (7)
Type of display
BUSINESS_UNIT_ID NUMBER

Business unit identifier
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
FROM BIM.BIM_R_FD_SUMMARY_MV_TEMP2;

Dependencies

[top of page]

BIM.BIM_R_FD_SUMMARY_MV_TEMP2 does not reference any database object

BIM.BIM_R_FD_SUMMARY_MV_TEMP2 is referenced by following:

SchemaBIM
ViewBIM_R_FD_SUMMARY_MV_TEMP2#