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

VIEW: APPS.OZF_FUNDS_VL

Object Details
Object Name: OZF_FUNDS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOZF.OZF_FUNDS_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. MO,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
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 Identifier
CATEGORY_ID NUMBER
Yes Category Identifier
FUND_TYPE VARCHAR2 (30)
Budget Type
FUND_USAGE VARCHAR2 (30)
For Future Use
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)
Accrued Liable Account
DED_ADJUSTMENT_ACCOUNT NUMBER (15)
Deduction Adjusment Account
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

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
BUDGET_AMOUNT_TC NUMBER

Obsolete
BUDGET_AMOUNT_FC NUMBER

Obsolete
AVAILABLE_AMOUNT NUMBER

Obsolete
DISTRIBUTED_AMOUNT NUMBER

Obsolete
CURRENCY_CODE_TC VARCHAR2 (15)
Transaction 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

For Future Use
COSTCENTRE_ID NUMBER

For Future Use
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
HIERARCHY VARCHAR2 (30)
Obsolete
HIERARCHY_ID NUMBER

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

Parent 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)
For Future Use
ACCRUAL_PHASE VARCHAR2 (30)
Accrual Phase
ACCRUAL_CAP NUMBER

Accrual Cap
ACCRUAL_UOM VARCHAR2 (30)
Accrual UOM - For Future Use
SHORT_NAME VARCHAR2 (240) Yes Budget Short name
DESCRIPTION VARCHAR2 (4000)
Budget Description
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
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
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 Fully Accrued Budget to store 'OFFR'
PLAN_ID NUMBER

Plan Type - Used only for Fully Accrued Budget to store corresponding Offer Id
LIABLE_ACCNT_SEGMENTS VARCHAR2 (155)
Liable Account Segments
ADJUSTMENT_ACCNT_SEGMENTS VARCHAR2 (155)
Adjustment Account Segments
COUNTRY_ID NUMBER

Country Identifier
TASK_ID NUMBER

Task Identifier
CUSTOM_SETUP_ID NUMBER

Setup Type Identifier
THRESHOLD_ID NUMBER

Threshold Identifier
FUND_CALENDAR VARCHAR2 (30)
Budget Calendar Identifier
START_PERIOD_NAME VARCHAR2 (30)
Start Period Identifier
END_PERIOD_NAME VARCHAR2 (30)
End Period Identifier
ACCRUE_TO_LEVEL_ID NUMBER

Accrued to Level Identifier
ACCRUAL_QUANTITY NUMBER

For Future Use
ACCRUAL_DISCOUNT_LEVEL VARCHAR2 (30)
Accrual Discount Level
BUSINESS_UNIT_ID NUMBER

Business Unit Identifier
RECAL_COMMITTED NUMBER

Recal 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 OutAmount
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 Recalulated 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
,      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
,      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
,      SHORT_NAME
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_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
,      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
,      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_VL;

Dependencies

[top of page]

APPS.OZF_FUNDS_VL references the following:

SchemaAPPS
SynonymOZF_FUNDS_ALL_B
SynonymOZF_FUNDS_ALL_TL
APPS.OZF_FUNDS_VL is referenced by following:

SchemaAPPS
Package BodyAMS_WFCMPAPR_PVT - show dependent code
Package BodyOZF_AUTOPAY_PVT - show dependent code