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

VIEW: APPS.OZF_FUNDS_UTILIZED_ALL_VL

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

View Type

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


Funds Utilized details. VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROWID of the record.
UTILIZATION_ID NUMBER
Yes Utilization 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
UTILIZATION_TYPE VARCHAR2 (30)
Utilization Type
FUND_ID NUMBER
Yes Fund Identifier
PLAN_TYPE VARCHAR2 (30)
Plan Type for eg. 'CAMP','EVEH'
PLAN_ID NUMBER

Plan Identifier for eg. Campaign Id , Event Id
COMPONENT_TYPE VARCHAR2 (30)
Component Type for eg. 'CSCH'
COMPONENT_ID NUMBER

Component Identifier
OBJECT_TYPE VARCHAR2 (30)
Object Type for eg. ORDER, ORDER_LINE
OBJECT_ID NUMBER

Object Identifier for eg. Order Id
ORDER_ID NUMBER

Obsolete
INVOICE_ID NUMBER

Obsolete
AMOUNT NUMBER
Yes Adjusted Amount
AMOUNT_REMAINING NUMBER

Adjusted Amount remaining
ACCTD_AMOUNT NUMBER

Adjusted Amount in Functional Currency
ACCTD_AMOUNT_REMAINING NUMBER

Adjusted Amount Remaining in Functional Currency
CURRENCY_CODE VARCHAR2 (15)
Currency Code
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Type
EXCHANGE_RATE_DATE DATE

Exchange Rate Date
EXCHANGE_RATE NUMBER

Exchange Rate
ADJUSTMENT_TYPE VARCHAR2 (30)
Adjustment Type
ADJUSTMENT_DATE DATE

Adjustment Date
ADJUSTMENT_DESC VARCHAR2 (2000)
Adjustment Description
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
Yes Organization Identifier
ADJUSTMENT_TYPE_ID NUMBER

Adjustment Type Identifier
CAMP_SCHEDULE_ID NUMBER

Schedule Identifier
PRODUCT_ID NUMBER

Product Identifier
CUST_ACCOUNT_ID NUMBER

Customer Account Identifier
AMS_ACTIVITY_BUDGET_ID NUMBER

Activity Budget Identifier
PRODUCT_LEVEL_TYPE VARCHAR2 (30)
Product Level Type Identifier for eg. 'PRODUCT' or 'FAMILY'
GL_DATE DATE

Gl Date
PRICE_ADJUSTMENT_ID NUMBER

Price Adjustment Identifier
PLAN_CURR_AMOUNT NUMBER

Utilized Amount in Planned Curerncy
PLAN_CURR_AMOUNT_REMAINING NUMBER

Amount Remaining to be paid in Planned Curerncy
SCAN_UNIT NUMBER

Scan Unit for Scan Data Offer
SCAN_UNIT_REMAINING NUMBER

Scan Unit Remaining for Scan Data Offer
ACTIVITY_PRODUCT_ID NUMBER

Activity Product Id for Scan Data Offer
VOLUME_OFFER_TIERS_ID NUMBER

Volume Offer Tier Id for Volume Offers
GL_POSTED_FLAG VARCHAR2 (1)
GL Posted Flag
BILLTO_CUST_ACCOUNT_ID NUMBER

Bill_to Customer Account Id
SHIP_TO_SITE_USE_ID NUMBER

Ship to site use id
BILL_TO_SITE_USE_ID NUMBER

Bill to site use id
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
REFERENCE_ID NUMBER

Reference Id
ORDER_LINE_ID NUMBER

Order line Id for accrual
ORIG_UTILIZATION_ID NUMBER

original utlization id used for adjustment
UNIV_CURR_AMOUNT NUMBER

Amount in TM reporting currency
UNIV_CURR_AMOUNT_REMAINING NUMBER

Amount Remaining in TM reporting currency
FUND_REQUEST_AMOUNT_REMAINING NUMBER

Amount Remaining in Budget request currency
FUND_REQUEST_AMOUNT NUMBER

Amount in Budget request currency
FUND_REQUEST_CURRENCY_CODE VARCHAR2 (15)
Budget currency code
PLAN_CURRENCY_CODE VARCHAR2 (15)
Plan currency code
Query Text

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


SELECT ROW_ID
,      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
,      AMOUNT_REMAINING
,      ACCTD_AMOUNT
,      ACCTD_AMOUNT_REMAINING
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      ADJUSTMENT_TYPE
,      ADJUSTMENT_DATE
,      ADJUSTMENT_DESC
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      ADJUSTMENT_TYPE_ID
,      CAMP_SCHEDULE_ID
,      PRODUCT_ID
,      CUST_ACCOUNT_ID
,      AMS_ACTIVITY_BUDGET_ID
,      PRODUCT_LEVEL_TYPE
,      GL_DATE
,      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
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      REFERENCE_TYPE
,      REFERENCE_ID
,      ORDER_LINE_ID
,      ORIG_UTILIZATION_ID
,      UNIV_CURR_AMOUNT
,      UNIV_CURR_AMOUNT_REMAINING
,      FUND_REQUEST_AMOUNT_REMAINING
,      FUND_REQUEST_AMOUNT
,      FUND_REQUEST_CURRENCY_CODE
,      PLAN_CURRENCY_CODE
FROM APPS.OZF_FUNDS_UTILIZED_ALL_VL;

Dependencies

[top of page]

APPS.OZF_FUNDS_UTILIZED_ALL_VL references the following:

SchemaAPPS
SynonymOZF_FUNDS_UTILIZED_ALL_B
SynonymOZF_FUNDS_UTILIZED_ALL_TL
APPS.OZF_FUNDS_UTILIZED_ALL_VL is referenced by following:

SchemaAPPS
ViewOZF_AEL_GL_UTL_V
ViewOZF_AEL_SL_UTL_V
Package BodyOZF_CLAIM_ACCRUAL_PVT - show dependent code
ViewOZF_CLAIM_REQ_HEADER_V
Package BodyOZF_FUND_UTILIZED_PVT - show dependent code
ViewOZF_OBJECT_CHECKBOOK_V