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_ALL_B

Object Details

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

OZF_FUNDS_ALL_B, stores the fund definition. This definition includes the fund name, active period, fund type, GL account mapping, budget amount(for fully accrued funds this field is blank at fund setup time), fund status, fund usage, owner and more. For a fully accrued fund this definition also stores the accrual parameters. In additionto the budget amount, the available amount and the distributed amounts are also stored.
The parent_fund_id column in the table enables to provide the functionality of a fund hierarchy.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_FUNDS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FUND_ID
OZF_FUNDS_ALL_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FUND_NUMBER
OZF_FUNDS_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID
OZF_FUNDS_ALL_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREV_FUND_ID
OZF_FUNDS_ALL_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THRESHOLD_ID
OZF_FUNDS_ALL_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HIERARCHY_ID
OZF_FUNDS_ALL_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER
OZF_FUNDS_ALL_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_FUND_ID
OZF_FUNDS_ALL_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEVEL_VALUE
OZF_FUNDS_ALL_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_ID
OZF_FUNDS_ALL_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HIERARCHY
OZF_FUNDS_ALL_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUND_TYPE STATUS_CODE FUND_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FUND_ID	NUMBER		Yes	Budget Unique identifier
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
FUND_NUMBER	VARCHAR2	(30)	Yes	Budget number
PARENT_FUND_ID	NUMBER			Parent Budget identifer
CATEGORY_ID	NUMBER		Yes	Budget Categrory identifer
FUND_TYPE	VARCHAR2	(30)		Budget Type identifier
FUND_USAGE	VARCHAR2	(30)		For future use . Usage of Budget. 'A' for activity or 'C' for customer.
STATUS_CODE	VARCHAR2	(30)	Yes	Budget Status
STATUS_DATE	DATE			Obsolete. Date on which the status is changed.
ACCRUED_LIABLE_ACCOUNT	NUMBER	(15)		Accrued promotion liability account for the Budget.
DED_ADJUSTMENT_ACCOUNT	NUMBER	(15)		Deduction adjustment expense account for the Budget.
LIABILITY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate Accrual Budget Liability.
SET_OF_BOOKS_ID	NUMBER			Obsolete .Set of Books Identifier
START_PERIOD_ID	NUMBER			Obsolete .For future use
END_PERIOD_ID	NUMBER			For future use
START_DATE_ACTIVE	DATE			The date from which the Budget is active
END_DATE_ACTIVE	DATE			The date till which the Budget is active
BUDGET_AMOUNT_TC	NUMBER			Obsolete. No longer used
BUDGET_AMOUNT_FC	NUMBER			Obsolete. No longer used
AVAILABLE_AMOUNT	NUMBER			Obsolete. No longer used
DISTRIBUTED_AMOUNT	NUMBER			Obsolete. No longer used
CURRENCY_CODE_TC	VARCHAR2	(15)		Currency Code
CURRENCY_CODE_FC	VARCHAR2	(15)		Obsolete. No longer used
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Obsolete. No longer used
EXCHANGE_RATE_DATE	DATE			Obsolete. No longer used
EXCHANGE_RATE	NUMBER			Obsolete. No longer used
DEPARTMENT_ID	NUMBER			For Future Use. Department identifier
COSTCENTRE_ID	NUMBER			For future use
OWNER	NUMBER		Yes	Owner of the Budget
ACCRUAL_METHOD	VARCHAR2	(30)		Bucket
ACCRUAL_OPERAND	VARCHAR2	(30)		Operand - Currency code, Percantage,etc. Only for 'Fully Accrued' Budgets
ACCRUAL_RATE	NUMBER			Accrual rate. Only for 'Fully Accrued' Budgets
ACCRUAL_BASIS	VARCHAR2	(30)		Accure to 'S'ales or 'C'ustomer. Only for Fully Accrued Budgets
HIERARCHY	VARCHAR2	(30)		Name of the hierarchy to which Budget is allocated
HIERARCHY_LEVEL	VARCHAR2	(30)		Obsolete. No longer used.
LEVEL_VALUE	VARCHAR2	(240)
BUDGET_FLAG	VARCHAR2	(1)		Obsolete. No longer used.
EARNED_FLAG	VARCHAR2	(1)		Obsolete. No longer used.
APPLY_ACCRUAL_ON	VARCHAR2	(30)		Obsolete. No longer used.
ACCRUAL_PHASE	VARCHAR2	(30)		For future use.
ACCRUAL_CAP	NUMBER			Cap to identify the limit for accrual computation.
ACCRUAL_UOM	VARCHAR2	(30)		Unit of measure for the accrual cap.
OBJECT_VERSION_NUMBER	NUMBER			Identifier for the record used in HTML screens.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield 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	(32)		Operating unit identifier
USER_STATUS_ID	NUMBER			User Status identifier
HIERARCHY_ID	NUMBER			Hierarchy identifier eg. Territory id
PARENT_NODE_ID	NUMBER			Budger allocation's Parent node identifier of the hierarchy tree
NODE_ID	NUMBER			Budger allocation's node identifier of the hierarchy tree
ORIGINAL_BUDGET	NUMBER			Original Budget
TRANSFERED_IN_AMT	NUMBER			Transfered In Amount
TRANSFERED_OUT_AMT	NUMBER			Transfered Out Amount
HOLDBACK_AMT	NUMBER			Holdback Amount
PLANNED_AMT	NUMBER			Planned Amount
COMMITTED_AMT	NUMBER			Committed Amount
EARNED_AMT	NUMBER			Earned Amount
PAID_AMT	NUMBER			Paid Amount
PLAN_TYPE	VARCHAR2	(30)		Obsolete. Plan Type eg. 'CAMP'
PLAN_ID	NUMBER			Obsolete. No longer used. Campaign identifier
LIABLE_ACCNT_SEGMENTS	VARCHAR2	(155)		Obsolete. No longer used.
ADJUSTMENT_ACCNT_SEGMENTS	VARCHAR2	(155)		Obsolete. No longer used.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
THRESHOLD_ID	NUMBER			Fund Threshold Identifier.
CUSTOM_SETUP_ID	NUMBER			Custom Setup Identifier.
COUNTRY_ID	NUMBER			Country Identifier
TASK_ID	NUMBER			Task Identifier
FUND_CALENDAR	VARCHAR2	(30)		Fund Calendar Identifier .
END_PERIOD_NAME	VARCHAR2	(30)		The period till which the Budget is active
START_PERIOD_NAME	VARCHAR2	(30)		The period from which the Budget is active
ACCRUAL_QUANTITY	NUMBER			Accrual Quantity of a Accrual Type Fund
ACCRUAL_DISCOUNT_LEVEL	VARCHAR2	(30)		Modifier Level code for Fully Accrued Budgets .Populated from QP modifier(offer) Level Code for eg.'ORDER','LINE'.
ACCRUE_TO_LEVEL_ID	NUMBER			Accrue To Territory Level Identifier
RECAL_COMMITTED	NUMBER			Stores Recalcualted Committed amount.
BUSINESS_UNIT_ID	NUMBER			Business Unit Id
ROLLUP_ORIGINAL_BUDGET	NUMBER			Original Budget of its and its whole family in profile currency
ROLLUP_TRANSFERED_IN_AMT	NUMBER			Transfered_in_amt of its and its whole family in profile currency .
ROLLUP_TRANSFERED_OUT_AMT	NUMBER			Transfered_out_amt of its and its whole family in profile currency .
ROLLUP_HOLDBACK_AMT	NUMBER			holdback_amt of its and its whole family in profile currency .
ROLLUP_PLANNED_AMT	NUMBER			Planned_amt of its and its whole family in profile currency .
ROLLUP_COMMITTED_AMT	NUMBER			Committed_amt of its and its whole family in profile currency .
ROLLUP_RECAL_COMMITTED	NUMBER			Recal_committed_amt of its and its whole family in profile currency .
ROLLUP_EARNED_AMT	NUMBER			Earned_amt of its and its whole family in profile currency .
ROLLUP_PAID_AMT	NUMBER			Paid_amt of its and its whole family in profile currency .
RETROACTIVE_FLAG	VARCHAR2	(1)		Retroactive Flag for Fully Accrued Volume Offer
QUALIFIER_ID	NUMBER			Market Qualifier for A Accrual Fund
PREV_FUND_ID	NUMBER			Previous Period Budget Id
TRANSFERED_FLAG	VARCHAR2	(1)		Flag to indicate whether unutilized committed amount has been transfered from previous period budget
UTILIZED_AMT	NUMBER			Utilized Amount
ROLLUP_UTILIZED_AMT	NUMBER			Utilized Amount of its and its whole family in profile currency
PRODUCT_SPREAD_TIME_ID	NUMBER			Product Spread Time Id
ACTIVATION_DATE	DATE			The date on which the Budget became active
LEDGER_ID	NUMBER			Ledger identifier

Query Text

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


SELECT FUND_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
,      FUND_NUMBER
,      PARENT_FUND_ID
,      CATEGORY_ID
,      FUND_TYPE
,      FUND_USAGE
,      STATUS_CODE
,      STATUS_DATE
,      ACCRUED_LIABLE_ACCOUNT
,      DED_ADJUSTMENT_ACCOUNT
,      LIABILITY_FLAG
,      SET_OF_BOOKS_ID
,      START_PERIOD_ID
,      END_PERIOD_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      BUDGET_AMOUNT_TC
,      BUDGET_AMOUNT_FC
,      AVAILABLE_AMOUNT
,      DISTRIBUTED_AMOUNT
,      CURRENCY_CODE_TC
,      CURRENCY_CODE_FC
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      DEPARTMENT_ID
,      COSTCENTRE_ID
,      OWNER
,      ACCRUAL_METHOD
,      ACCRUAL_OPERAND
,      ACCRUAL_RATE
,      ACCRUAL_BASIS
,      HIERARCHY
,      HIERARCHY_LEVEL
,      LEVEL_VALUE
,      BUDGET_FLAG
,      EARNED_FLAG
,      APPLY_ACCRUAL_ON
,      ACCRUAL_PHASE
,      ACCRUAL_CAP
,      ACCRUAL_UOM
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      USER_STATUS_ID
,      HIERARCHY_ID
,      PARENT_NODE_ID
,      NODE_ID
,      ORIGINAL_BUDGET
,      TRANSFERED_IN_AMT
,      TRANSFERED_OUT_AMT
,      HOLDBACK_AMT
,      PLANNED_AMT
,      COMMITTED_AMT
,      EARNED_AMT
,      PAID_AMT
,      PLAN_TYPE
,      PLAN_ID
,      LIABLE_ACCNT_SEGMENTS
,      ADJUSTMENT_ACCNT_SEGMENTS
,      SECURITY_GROUP_ID
,      THRESHOLD_ID
,      CUSTOM_SETUP_ID
,      COUNTRY_ID
,      TASK_ID
,      FUND_CALENDAR
,      END_PERIOD_NAME
,      START_PERIOD_NAME
,      ACCRUAL_QUANTITY
,      ACCRUAL_DISCOUNT_LEVEL
,      ACCRUE_TO_LEVEL_ID
,      RECAL_COMMITTED
,      BUSINESS_UNIT_ID
,      ROLLUP_ORIGINAL_BUDGET
,      ROLLUP_TRANSFERED_IN_AMT
,      ROLLUP_TRANSFERED_OUT_AMT
,      ROLLUP_HOLDBACK_AMT
,      ROLLUP_PLANNED_AMT
,      ROLLUP_COMMITTED_AMT
,      ROLLUP_RECAL_COMMITTED
,      ROLLUP_EARNED_AMT
,      ROLLUP_PAID_AMT
,      RETROACTIVE_FLAG
,      QUALIFIER_ID
,      PREV_FUND_ID
,      TRANSFERED_FLAG
,      UTILIZED_AMT
,      ROLLUP_UTILIZED_AMT
,      PRODUCT_SPREAD_TIME_ID
,      ACTIVATION_DATE
,      LEDGER_ID
FROM OZF.OZF_FUNDS_ALL_B;

Dependencies

[top of page]

OZF.OZF_FUNDS_ALL_B does not reference any database object

OZF.OZF_FUNDS_ALL_B is referenced by following:

APPS: OZF_CUST_FUND_SUMMARY_MV; OZF_FUNDS_ALL_B