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

VIEW: APPS.OZF_FUNDS_ALL_VL

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

View Type

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


Fund setup master base table and translation table view.VL


[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

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 Fund Identifier
CATEGORY_ID NUMBER
Yes Category Identifier
FUND_TYPE VARCHAR2 (30)
Fund Type
FUND_USAGE VARCHAR2 (30)
Obsolete
STATUS_CODE VARCHAR2 (30) Yes Status Code
STATUS_DATE DATE

For Future Use
USER_STATUS_ID NUMBER

User Status Identifier
ACCRUED_LIABLE_ACCOUNT NUMBER (15)
Obsolete
DED_ADJUSTMENT_ACCOUNT NUMBER (15)
Obsolete
LIABILITY_FLAG VARCHAR2 (1) Yes Liability Flag
SET_OF_BOOKS_ID NUMBER

Obsolete
START_PERIOD_ID NUMBER

Obsolete
END_PERIOD_ID NUMBER

Obsolete
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)
Transactional Currency Code
CURRENCY_CODE_FC VARCHAR2 (15)
Obsolete
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Obsolete
EXCHANGE_RATE_DATE DATE

Obsolete
EXCHANGE_RATE NUMBER

Obsolete
DEPARTMENT_ID NUMBER

Department Identfier -- For Future Use
COSTCENTRE_ID NUMBER

Obsolete
OWNER NUMBER
Yes Budget Owner
ACCRUAL_METHOD VARCHAR2 (30)
Accrual Method
ACCRUAL_OPERAND VARCHAR2 (30)
Accrual Operand
ACCRUAL_RATE NUMBER

Accrual Rate
ACCRUAL_BASIS VARCHAR2 (30)
Accrual Basis for eg 'Customer'
HIERARCHY VARCHAR2 (30)
Obsolete
HIERARCHY_ID NUMBER

Hierarchy Identifier
HIERARCHY_LEVEL VARCHAR2 (30)
Hierarchy Level Identifier
PARENT_NODE_ID NUMBER

Paren Node Identifier
NODE_ID NUMBER

Node Identifier
BUDGET_FLAG VARCHAR2 (1)
For Future Use
EARNED_FLAG VARCHAR2 (1)
For Future Use
APPLY_ACCRUAL_ON VARCHAR2 (30)
Obsolete
ACCRUAL_PHASE VARCHAR2 (30)
Accrual Phase
ACCRUAL_CAP NUMBER

Accrual Cap
ACCRUAL_UOM VARCHAR2 (30)
Accrual UOM -- For Future Use
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)
Plan Type -- used only for Accral Fund to store 'OFFR'
PLAN_ID NUMBER

Plan Identifier -- Stores Offer Id for Accrual Budget
LIABLE_ACCNT_SEGMENTS VARCHAR2 (155)
Liable Accnt Segments
ADJUSTMENT_ACCNT_SEGMENTS VARCHAR2 (155)
Adjustment Account Segments
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)
Start Period Identifier
END_PERIOD_NAME VARCHAR2 (30)
End Period Identifier
ACCRUE_TO_LEVEL_ID NUMBER

Accrue to Level Identifier
ACCRUAL_QUANTITY NUMBER

Accrual Quantity
ACCRUAL_DISCOUNT_LEVEL VARCHAR2 (30)
Accrual Discount Level
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)
Organization Identifier
RECAL_COMMITTED NUMBER

Recalculated 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
SHORT_NAME VARCHAR2 (240) Yes Fund Short Name
DESCRIPTION VARCHAR2 (4000)
Fund Description
RETROACTIVE_FLAG VARCHAR2 (1)
Retroactive Flag for Volume Offer Accrual Fund
QUALIFIER_ID NUMBER

Cumulative Order Volume Type Fully Accrued Budget Qualifier id
PREV_FUND_ID NUMBER

Previous Period Budget Id
TRANSFERED_FLAG VARCHAR2 (1)
If unutilized committed amount has been transferred from previous period budget
UTILIZED_AMT NUMBER

Utilized Amount
ROLLUP_UTILIZED_AMT NUMBER

Rollup Utilized Amount
PRODUCT_SPREAD_TIME_ID NUMBER

Product Spread Time Id
LEDGER_ID NUMBER

Ledger identifier
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
,      SHORT_NAME
,      DESCRIPTION
,      RETROACTIVE_FLAG
,      QUALIFIER_ID
,      PREV_FUND_ID
,      TRANSFERED_FLAG
,      UTILIZED_AMT
,      ROLLUP_UTILIZED_AMT
,      PRODUCT_SPREAD_TIME_ID
,      LEDGER_ID
FROM APPS.OZF_FUNDS_ALL_VL;

Dependencies

[top of page]

APPS.OZF_FUNDS_ALL_VL references the following:

SchemaAPPS
SynonymOZF_FUNDS_ALL_B
SynonymOZF_FUNDS_ALL_TL
APPS.OZF_FUNDS_ALL_VL is referenced by following:

SchemaAPPS
Package BodyAMS_APPROVAL_PVT - show dependent code
Package BodyAMS_GEN_APPROVAL_PVT - show dependent code
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyOZF_ACTBUDGETRULES_PVT - show dependent code
ViewOZF_AEL_GL_UTL_V
ViewOZF_AEL_SL_UTL_V
Package BodyOZF_ALLOCATION_ENGINE_PVT - show dependent code
Package BodyOZF_CLAIM_ACCRUAL_PVT - show dependent code
Package BodyOZF_FUNDRULES_PVT - show dependent code
ViewOZF_FUNDS_CUST_V
Package BodyOZF_FUNDS_PUB - show dependent code
Package BodyOZF_FUNDS_PVT - show dependent code
Package BodyOZF_FUND_ALLOCATIONS_PVT - show dependent code
Package BodyOZF_FUND_APPROVAL_PVT - show dependent code
ViewOZF_FUND_DETAILS_V
Package BodyOZF_FUND_EXTENSION_PVT - show dependent code
Package BodyOZF_FUND_RECONCILE_PVT - show dependent code
Package BodyOZF_FUND_REQUEST_APR_PVT - show dependent code
Package BodyOZF_FUND_UTILIZED_PUB - show dependent code
Package BodyOZF_OFFERADJ_APPROVAL_PVT - show dependent code
Package BodyOZF_QUOTA_ALLOCATIONS_PVT - show dependent code
ViewOZF_QUOTA_CLOB_V
Package BodyOZF_QUOTA_PUB - show dependent code
ViewOZF_TARGET_CLOB_V
Package BodyOZF_UTILITY_PVT - show dependent code
ViewOZF_XLA_ACC_HEADER_V