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_FUNDS_UTILIZED_ALL_B

Object Details

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

OZF_FUND_UTILIZATIONS_ALL stores the utilization details for a given Budget. The utilization may or may not contribute to the accruals in a given Budget detail.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_FUNDS_UTILIZED_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UTILIZATION_ID
OZF_FUNDS_UTILIZED_ALL_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID
OZF_FUNDS_UTILIZED_ALL_B_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
OZF_FUNDS_UTILIZED_ALL_B_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMS_ACTIVITY_BUDGET_ID
OZF_FUNDS_UTILIZED_ALL_B_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_TYPE REFERENCE_ID
OZF_FUNDS_UTILIZED_ALL_B_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_LINE_ID
OZF_FUNDS_UTILIZED_ALL_B_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_UTILIZATION_ID
OZF_FUNDS_UTILIZED_ALL_B_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_PRODUCT_ID
OZF_FUNDS_UTILIZED_ALL_B_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID
OZF_FUNDS_UTILIZED_ALL_B_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_ADJUSTMENT_ID OBJECT_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_TYPE_ID
OZF_FUNDS_UTILIZED_ALL_B_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILLTO_CUST_ACCOUNT_ID OBJECT_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_POSTED_FLAG PRICE_ADJUSTMENT_ID
OZF_FUNDS_UTILIZED_ALL_B_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_DATE PLAN_ID PLAN_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPONENT_ID
OZF_FUNDS_UTILIZED_ALL_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUND_ID PLAN_ID PLAN_TYPE CREATION_DATE
OZF_FUNDS_UTILIZED_ALL_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UTILIZATION_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRODUCT_ID PRODUCT_LEVEL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
UTILIZATION_ID	NUMBER		Yes	Internal identifier for fund utilization
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATED_FROM	VARCHAR2	(30)		Standard WHO column
REQUEST_ID	NUMBER	(15)		Standard WHO column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard WHO column
PROGRAM_ID	NUMBER	(15)		Standard WHO column
PROGRAM_UPDATE_DATE	DATE			Standard WHO column
UTILIZATION_TYPE	VARCHAR2	(30)		Type of utilization - Accrued, Utilized, Adjust.
FUND_ID	NUMBER		Yes	Budget against which the utilization is occuring
PLAN_TYPE	VARCHAR2	(30)		'C'ampaign or 'T'rade promotion
PLAN_ID	NUMBER			Internal identifier for the deal
COMPONENT_TYPE	VARCHAR2	(30)		Offer Type
COMPONENT_ID	NUMBER			Offer Identifier
OBJECT_TYPE	VARCHAR2	(30)		Type of object - Invoice, Order.
OBJECT_ID	NUMBER			Internal identifier for the object.
ORDER_ID	NUMBER			Internal identifier for the order.
INVOICE_ID	NUMBER			Invoice toed to the deal component
AMOUNT	NUMBER		Yes	Utilization amount
ACCTD_AMOUNT	NUMBER			Functional currency amount.
CURRENCY_CODE	VARCHAR2	(15)		Currency code.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Obsolete. Type of exchange rate.
EXCHANGE_RATE_DATE	DATE			Exchange Rate Date
EXCHANGE_RATE	NUMBER			Obsolete. Exchange rate.
ADJUSTMENT_TYPE	VARCHAR2	(30)		Adjustment Type. Default 'Standard'
ADJUSTMENT_DATE	DATE			Adjustment Date
OBJECT_VERSION_NUMBER	NUMBER			Identifier for the record used in HTML screens.
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
ORG_ID	NUMBER		Yes	Operating Unit Identifier
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CAMP_SCHEDULE_ID	NUMBER			Campaign Schedule Identifier.
ADJUSTMENT_TYPE_ID	NUMBER			Adjustment Type Identifier.
AMS_ACTIVITY_BUDGET_ID	NUMBER			Activity Budget Identifier.
PRODUCT_ID	NUMBER			Product Identifier
CUST_ACCOUNT_ID	NUMBER			Pay_to Customer Account Identifier.
GL_DATE	DATE			General Ledger Posting Date.
PRODUCT_LEVEL_TYPE	VARCHAR2	(30)		Product Level Code for eg. PRODUCT or PRODUCT_FAMILY
AMOUNT_REMAINING	NUMBER			Utilization amount not used by a claim
ACCTD_AMOUNT_REMAINING	NUMBER			Functional currency amount remaining
PRICE_ADJUSTMENT_ID	NUMBER			Price Adjustment Identifier
PLAN_CURR_AMOUNT	NUMBER			Amount in 'Plan Type' Currency
PLAN_CURR_AMOUNT_REMAINING	NUMBER			Amount Remaining in 'Plan Type' Currency
SCAN_UNIT	NUMBER			Scan Unit for Scan Data Offer
SCAN_UNIT_REMAINING	NUMBER			Scan Unit Remaining to be Paid for Scan Data Offer
ACTIVITY_PRODUCT_ID	NUMBER			Activity Product Id for Scan Data Offer
VOLUME_OFFER_TIERS_ID	NUMBER			Volume Offer Tier id ( FK from table ams_volume_offer_tiers)
GL_POSTED_FLAG	VARCHAR2	(1)		Gl Posted Flag
BILLTO_CUST_ACCOUNT_ID	NUMBER			Bill_to Customer Account Id
REFERENCE_TYPE	VARCHAR2	(30)		Reference Type
REFERENCE_ID	NUMBER			Reference Id
MONTH_ID	NUMBER
QUARTER_ID	NUMBER
YEAR_ID	NUMBER
ORDER_LINE_ID	NUMBER			Order line Id for accrual
ORIG_UTILIZATION_ID	NUMBER			original utilization id used for adjustment
SHIP_TO_SITE_USE_ID	NUMBER			Ship to Site Use Id
BILL_TO_SITE_USE_ID	NUMBER			Bill to Site Use Id
UNIV_CURR_AMOUNT	NUMBER			Amount in TM reporting currency
UNIV_CURR_AMOUNT_REMAINING	NUMBER			Amount Remaining in TM reporting currency

Query Text

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


SELECT UTILIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CREATED_FROM
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      UTILIZATION_TYPE
,      FUND_ID
,      PLAN_TYPE
,      PLAN_ID
,      COMPONENT_TYPE
,      COMPONENT_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      ORDER_ID
,      INVOICE_ID
,      AMOUNT
,      ACCTD_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      ADJUSTMENT_TYPE
,      ADJUSTMENT_DATE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      CAMP_SCHEDULE_ID
,      ADJUSTMENT_TYPE_ID
,      AMS_ACTIVITY_BUDGET_ID
,      PRODUCT_ID
,      CUST_ACCOUNT_ID
,      GL_DATE
,      PRODUCT_LEVEL_TYPE
,      AMOUNT_REMAINING
,      ACCTD_AMOUNT_REMAINING
,      PRICE_ADJUSTMENT_ID
,      PLAN_CURR_AMOUNT
,      PLAN_CURR_AMOUNT_REMAINING
,      SCAN_UNIT
,      SCAN_UNIT_REMAINING
,      ACTIVITY_PRODUCT_ID
,      VOLUME_OFFER_TIERS_ID
,      GL_POSTED_FLAG
,      BILLTO_CUST_ACCOUNT_ID
,      REFERENCE_TYPE
,      REFERENCE_ID
,      MONTH_ID
,      QUARTER_ID
,      YEAR_ID
,      ORDER_LINE_ID
,      ORIG_UTILIZATION_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      UNIV_CURR_AMOUNT
,      UNIV_CURR_AMOUNT_REMAINING
FROM OZF.OZF_FUNDS_UTILIZED_ALL_B;

Dependencies

[top of page]

OZF.OZF_FUNDS_UTILIZED_ALL_B does not reference any database object

OZF.OZF_FUNDS_UTILIZED_ALL_B is referenced by following:

APPS: OZF_CUST_FUND_SUMMARY_MV; OZF_EARNING_SUMMARY_MV; OZF_FUNDS_UTILIZED; OZF_FUNDS_UTILIZED_ALL_B