eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIM.BIM_R_FUND_LOAD

Object Details

Object Name:	BIM_R_FUND_LOAD
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

this a tempory table when load fund facts

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FUND_TRANSACTION_ID	NUMBER		Yes	unique identifier
CREATION_DATE	DATE		Yes	standard who column
CREATED_BY	NUMBER		Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who column
LAST_UPDATED_BY	NUMBER		Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER		Yes	standard who column
FUND_ID	NUMBER		Yes	id for the fund
PARENT_FUND_ID	NUMBER			parent fund id for fund
FUND_NUMBER	VARCHAR2	(30)		fund number
START_DATE	DATE			fund start date
END_DATE	DATE			fund end date
START_PERIOD	VARCHAR2	(30)		fund start period
END_PERIOD	VARCHAR2	(30)		fund end date
SET_OF_BOOKS_ID	NUMBER			set of books id for fund
FUND_TYPE	VARCHAR2	(30)		fund type for fund
REGION	VARCHAR2	(30)		region where fund was issued
COUNTRY	VARCHAR2	(30)		country where fund was issued
CATEGORY_ID	NUMBER			category id for fund
STATUS	VARCHAR2	(30)		status for fund
ORIGINAL_BUDGET	NUMBER			amount of original budget for fund
TRANSFER_IN	NUMBER			amount of transfer in for fund
TRANSFER_OUT	NUMBER			amount of transfer out for fund
HOLDBACK_AMT	NUMBER			amount holdback for fund
CURRENCY_CODE_FC	VARCHAR2	(15)		currency code
DELETE_FLAG	VARCHAR2	(1)		delete flag are used when records need to be deleted
TRANSACTION_CREATE_DATE	DATE		Yes	Creation date of the transaction.
LOAD_DATE	DATE			This column provides the week end date of the transaction create date.
ORG_ID	NUMBER			organization id
SECURITY_GROUP_ID	NUMBER			This column is used in hosted environments
FIS_MONTH	VARCHAR2	(30)		Fiscal period month
FIS_QTR	VARCHAR2	(30)		Fiscal period quarter
FIS_YEAR	VARCHAR2	(30)		Fiscal period year
BUSINESS_UNIT_ID	NUMBER			Business_unit_id

Query Text

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


SELECT FUND_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUND_ID
,      PARENT_FUND_ID
,      FUND_NUMBER
,      START_DATE
,      END_DATE
,      START_PERIOD
,      END_PERIOD
,      SET_OF_BOOKS_ID
,      FUND_TYPE
,      REGION
,      COUNTRY
,      CATEGORY_ID
,      STATUS
,      ORIGINAL_BUDGET
,      TRANSFER_IN
,      TRANSFER_OUT
,      HOLDBACK_AMT
,      CURRENCY_CODE_FC
,      DELETE_FLAG
,      TRANSACTION_CREATE_DATE
,      LOAD_DATE
,      ORG_ID
,      SECURITY_GROUP_ID
,      FIS_MONTH
,      FIS_QTR
,      FIS_YEAR
,      BUSINESS_UNIT_ID
FROM BIM.BIM_R_FUND_LOAD;

Dependencies

[top of page]

BIM.BIM_R_FUND_LOAD does not reference any database object

BIM.BIM_R_FUND_LOAD is referenced by following:

APPS: BIM_R_FUND_LOAD