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: OZF.OZF_OBJECT_FUND_SUMMARY

Object Details

Object Name:	OZF_OBJECT_FUND_SUMMARY
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_OBJECT_FUND_SUMMARY
Subobject Name:
Status:	VALID

ozf_object_fund_summary, captures object's planned/commited/utilized/earned/paid amount at object-budget level, in budget's currency, object's currency and TM universal currency

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_OBJECT_FUND_SUMMARY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJFUNDSUM_ID
OZF_OBJECT_FUND_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID
OZF_OBJECT_FUND_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUND_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJFUNDSUM_ID	NUMBER		Yes	Internal identifier for object fund summary
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER			Identifier for the record used in HTML screens.
FUND_ID	NUMBER		Yes	Fund Id
FUND_CURRENCY	VARCHAR2	(30)	Yes	Fund Currency
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object Type
OBJECT_ID	NUMBER		Yes	Object Id
OBJECT_CURRENCY	VARCHAR2	(30)	Yes	Object Currency
REFERENCE_OBJECT_TYPE	VARCHAR2	(30)		CAMP if campaign schedule/offer sourcing from parent, SOFT FUND for soft fund, while object type is OFFR, SPECIAL PRICE for special pricing, while object type is OFFR
REFERENCE_OBJECT_ID	NUMBER			Campaign id if campaign schedule/offer sourcing from parent, Soft fund id for soft fund, Special prcing id for special pricing
SOURCE_FROM_PARENT	VARCHAR2	(1)		The flag to indicate if the object is souced from parent
PLANNED_AMT	NUMBER			Planned amount in budget currency
COMMITTED_AMT	NUMBER			Committed amount in budget currency
RECAL_COMMITTED_AMT	NUMBER			Recalculated Committed amount in budget currency
UTILIZED_AMT	NUMBER			Utilized amount in budget currency
EARNED_AMT	NUMBER			Earned amount in budget currency
PAID_AMT	NUMBER			Paid Amount in budget currency
PLAN_CURR_PLANNED_AMT	NUMBER			Planned amount in object currency
PLAN_CURR_COMMITTED_AMT	NUMBER			Committed amount in object currency
PLAN_CURR_RECAL_COMMITTED_AMT	NUMBER			Recalculated Committed amount in object currency
PLAN_CURR_UTILIZED_AMT	NUMBER			Utilized amount in object currency
PLAN_CURR_EARNED_AMT	NUMBER			Earned amount in object currency
PLAN_CURR_PAID_AMT	NUMBER			Paid amount in object currency
UNIV_CURR_PLANNED_AMT	NUMBER			Planned amount in TM reporting currency
UNIV_CURR_COMMITTED_AMT	NUMBER			Committed amount in TM reporting currency
UNIV_CURR_RECAL_COMMITTED_AMT	NUMBER			Recalculated Committed amount in TM reporting currency
UNIV_CURR_UTILIZED_AMT	NUMBER			Utilized amount in TM reporting currency
UNIV_CURR_EARNED_AMT	NUMBER			Earned amount in TM reporting currency
UNIV_CURR_PAID_AMT	NUMBER			Paid amount in TM reporting currency
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flex structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flex segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flex segment

Query Text

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


SELECT OBJFUNDSUM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      FUND_ID
,      FUND_CURRENCY
,      OBJECT_TYPE
,      OBJECT_ID
,      OBJECT_CURRENCY
,      REFERENCE_OBJECT_TYPE
,      REFERENCE_OBJECT_ID
,      SOURCE_FROM_PARENT
,      PLANNED_AMT
,      COMMITTED_AMT
,      RECAL_COMMITTED_AMT
,      UTILIZED_AMT
,      EARNED_AMT
,      PAID_AMT
,      PLAN_CURR_PLANNED_AMT
,      PLAN_CURR_COMMITTED_AMT
,      PLAN_CURR_RECAL_COMMITTED_AMT
,      PLAN_CURR_UTILIZED_AMT
,      PLAN_CURR_EARNED_AMT
,      PLAN_CURR_PAID_AMT
,      UNIV_CURR_PLANNED_AMT
,      UNIV_CURR_COMMITTED_AMT
,      UNIV_CURR_RECAL_COMMITTED_AMT
,      UNIV_CURR_UTILIZED_AMT
,      UNIV_CURR_EARNED_AMT
,      UNIV_CURR_PAID_AMT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM OZF.OZF_OBJECT_FUND_SUMMARY;

Dependencies

[top of page]

OZF.OZF_OBJECT_FUND_SUMMARY does not reference any database object

OZF.OZF_OBJECT_FUND_SUMMARY is referenced by following:

OZF: OZF_OBJECT_FUND_SUMMARY#