[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIM_R_FUND_DIMSUM |
|---|---|
| Object Type: | TABLE |
| Owner: | BIM |
| Subobject Name: | |
| Status: | VALID |
This table is used for creating Fund level Materialized view
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CREATION_DATE | DATE | Standard who column | ||
| CREATED_BY | NUMBER | Standard who column | ||
| LAST_UPDATE_DATE | DATE | Standard who column | ||
| LAST_UPDATED_BY | DATE | Standard who column | ||
| LAST_UPDATE_LOGIN | DATE | Standard who column | ||
| FUND_ID | NUMBER | Fund Identifier | ||
| FUND_NAME | VARCHAR2 | (240) | Fund Name | |
| PARENT_FUND_ID | NUMBER | Parent of the default fund | ||
| FUND_NUMBER | VARCHAR2 | (30) | Fund Number | |
| START_DATE | DATE | Start date of the fund | ||
| END_DATE | DATE | ENd Date of the fund | ||
| START_PERIOD | VARCHAR2 | (30) | Start period of the Fund | |
| END_PERIOD | VARCHAR2 | (30) | End period of the fund | |
| FUND_TYPE | VARCHAR2 | (30) | Type of the fund | |
| AREA1_CODE | VARCHAR2 | (30) | Region of the fund | |
| AREA2_CODE | VARCHAR2 | (30) | Regions Next Level | |
| COUNTRY_CODE | VARCHAR2 | (30) | Country Code of the fund | |
| CATEGORY_ID | NUMBER | Category of the fund | ||
| STATUS | VARCHAR2 | (30) | Status of the fund | |
| MONTH | VARCHAR2 | (30) | Month in which we are interested | |
| QTR | VARCHAR2 | (30) | Quarter in which we are interested | |
| YEAR | VARCHAR2 | (30) | Year in which we are interested | |
| AGGREGATE_BY | VARCHAR2 | (9) | Aggregate type of the period | |
| ORIGINAL_BUDGET | NUMBER | Original Budget | ||
| HOLDBACK_AMT | NUMBER | Hold back amount of the fund | ||
| CURRENCY_CODE_FC | VARCHAR2 | (15) | Functional Currency code of the Fund | |
| TOTAL_BUDGET | NUMBER | Total Budget amount | ||
| AVAILABLE_BUDGET | NUMBER | Available Budget | ||
| BALANCE | NUMBER | Balance Budget | ||
| PRE_BALANCE | NUMBER | Balance in the previous period | ||
| COMMITTED | NUMBER | Committed Amount | ||
| PRE_COMMITTED | NUMBER | Committed in the previous period | ||
| UTILIZED | NUMBER | Utilized amount | ||
| PRE_UTILIZED | NUMBER | Utilized in the previous period | ||
| DISPLAY_TYPE | VARCHAR2 | (7) | Display type by the period (Aggregate Increment can have 5 display types - daily, weekly, monthly, quarterly,yearly) | |
| BUSINESS_UNIT_ID | NUMBER | business unit it of fund | ||
| PLANNED | NUMBER | planned amount | ||
| PAID | NUMBER | paid amount |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, 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
, BALANCE
, PRE_BALANCE
, COMMITTED
, PRE_COMMITTED
, UTILIZED
, PRE_UTILIZED
, DISPLAY_TYPE
, BUSINESS_UNIT_ID
, PLANNED
, PAID
FROM BIM.BIM_R_FUND_DIMSUM;
BIM.BIM_R_FUND_DIMSUM does not reference any database object
BIM.BIM_R_FUND_DIMSUM is referenced by following:
APPS
BIM_R_FUND_DIMSUM
|
|
|
|