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

VIEW: APPS.OZF_FUNDS

Object Details
Object Name: OZF_FUNDS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOZF.OZF_FUNDS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Funds View VL, MO


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
FUND_ID NUMBER
Yes Fund Identifier
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)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Identifier for the record used in HTML screens.
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 Fund Identifier
CATEGORY_ID NUMBER
Yes Budget Category Identifier
FUND_TYPE VARCHAR2 (30)
Fund Type Identifier
FUND_USAGE VARCHAR2 (30)
For Future Use
STATUS_CODE VARCHAR2 (30) Yes Budget Status Code
STATUS_DATE DATE

For Future Use
USER_STATUS_ID NUMBER

User Status Identifier
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

For Future use
START_PERIOD_ID NUMBER

Obsolete .Start Period Identifier
END_PERIOD_ID NUMBER

Obsolete .End Period Identifier
START_DATE_ACTIVE DATE

Budget Start Date
END_DATE_ACTIVE DATE

Budget End Date
BUDGET_AMOUNT_TC NUMBER

Obsolete.
BUDGET_AMOUNT_FC NUMBER

Obsolete
AVAILABLE_AMOUNT NUMBER

Obsolete
DISTRIBUTED_AMOUNT NUMBER

Obsolete
CURRENCY_CODE_TC VARCHAR2 (15)
Budget Transactional Currency Code
CURRENCY_CODE_FC VARCHAR2 (15)
For Future Use
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Obsolete. For Future Use
EXCHANGE_RATE_DATE DATE

Obsolete. For Future Use
EXCHANGE_RATE NUMBER

Obsolete. For Future Use
DEPARTMENT_ID NUMBER

Obsolete. For Future Use
COSTCENTRE_ID NUMBER

Obsolete. For Future Use
OWNER NUMBER
Yes Budget Owner Identifier
ACCRUAL_METHOD VARCHAR2 (30)
Accrual Bucket
ACCRUAL_OPERAND VARCHAR2 (30)
Accrual Operand
ACCRUAL_RATE NUMBER

Accrual Rate
ACCRUAL_BASIS VARCHAR2 (30)
Accrual Basis
HIERARCHY VARCHAR2 (30)
Obsolete
HIERARCHY_ID NUMBER

Obsolete
HIERARCHY_LEVEL VARCHAR2 (30)
Obsolete
PARENT_NODE_ID NUMBER

Obsolete
NODE_ID NUMBER

Obsolete
BUDGET_FLAG VARCHAR2 (1)
Obsolete
EARNED_FLAG VARCHAR2 (1)
Obsolete
APPLY_ACCRUAL_ON VARCHAR2 (30)
Obsolete
ACCRUAL_PHASE VARCHAR2 (30)
Accrual Phase
ACCRUAL_CAP NUMBER

Accrual Cap
ACCRUAL_UOM VARCHAR2 (30)
Accrual UOM
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_ID NUMBER

Obsolete
LIABLE_ACCNT_SEGMENTS VARCHAR2 (155)
Obsolete
ADJUSTMENT_ACCNT_SEGMENTS VARCHAR2 (155)
Obsolete
COUNTRY_ID NUMBER

Country Identifier
TASK_ID NUMBER

Task Identifier.
CUSTOM_SETUP_ID NUMBER

Custom Setup Identifier.
THRESHOLD_ID NUMBER

Fund Threshold Identifier.
FUND_CALENDAR VARCHAR2 (30)
Fund Calendar Identifier.
START_PERIOD_NAME VARCHAR2 (30)
The period from which the Budget is active.
END_PERIOD_NAME VARCHAR2 (30)
The period till which the Budget is active.
ACCRUE_TO_LEVEL_ID NUMBER

Accrued To Territory Level Identifier for Sales type Fully Accrued fund
ACCRUAL_QUANTITY NUMBER

Accrual Quantity
ACCRUAL_DISCOUNT_LEVEL VARCHAR2 (30)
Modifier Level code for Fully Accrued Budgets .Populated from QP modifier(offer) Level Code for eg.'ORDER','LINE'.
BUSINESS_UNIT_ID NUMBER

Business Unit Identifier
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)
Business Unit Identifier
RECAL_COMMITTED NUMBER

Stores Recalcualted Committed amount.
ROLLUP_ORIGINAL_BUDGET NUMBER

Rolled Up Original Budget
ROLLUP_TRANSFERED_IN_AMT NUMBER

Rolled Up Transfered In Amount
ROLLUP_TRANSFERED_OUT_AMT NUMBER

Rolled Up Transfered Out Amount
ROLLUP_HOLDBACK_AMT NUMBER

Rolled Up Holdback Amount
ROLLUP_PLANNED_AMT NUMBER

Rolled Up Planned Amount
ROLLUP_COMMITTED_AMT NUMBER

Rolled Up Committed Amount
ROLLUP_RECAL_COMMITTED NUMBER

Rolled Up Recalculated Committed Amount
ROLLUP_EARNED_AMT NUMBER

Rolled Up Earned Amount
ROLLUP_PAID_AMT NUMBER

Rolled Up Paid Amount
RETROACTIVE_FLAG VARCHAR2 (1)
Retroactive Flag for Volume Offer Accrual Fund
QUALIFIER_ID NUMBER

Cumulative Order Volume Type Fully Accrued Budget Qualifier id
Query Text

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


SELECT ROW_ID
,      FUND_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      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
,      USER_STATUS_ID
,      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_ID
,      HIERARCHY_LEVEL
,      PARENT_NODE_ID
,      NODE_ID
,      BUDGET_FLAG
,      EARNED_FLAG
,      APPLY_ACCRUAL_ON
,      ACCRUAL_PHASE
,      ACCRUAL_CAP
,      ACCRUAL_UOM
,      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
,      COUNTRY_ID
,      TASK_ID
,      CUSTOM_SETUP_ID
,      THRESHOLD_ID
,      FUND_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      ACCRUE_TO_LEVEL_ID
,      ACCRUAL_QUANTITY
,      ACCRUAL_DISCOUNT_LEVEL
,      BUSINESS_UNIT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      RECAL_COMMITTED
,      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
FROM APPS.OZF_FUNDS;

Dependencies

[top of page]

APPS.OZF_FUNDS references the following:

SchemaAPPS
SynonymOZF_FUNDS_ALL_B

APPS.OZF_FUNDS is not referenced by any database object