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

VIEW: APPS.OZF_FUNDS_CUST_V

Object Details
Object Name: OZF_FUNDS_CUST_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
FUND_ID NUMBER

Fund Identifier
FUND_NUMBER VARCHAR2 (30)
Fund Number
SHORT_NAME VARCHAR2 (240)
Fund Short Name
CURRENCY VARCHAR2 (15)
Fund Currency
CUSTOM_SETUP_ID NUMBER

Custom Setup Identifier of the fund
OWNER NUMBER

Fund Owner
CUST_NAME VARCHAR2 (2000)
Customer Name , the fund is eligible for.
PARTY_ID NUMBER

Party Identifier
ACCOUNT_NAME VARCHAR2 (402)
Account Name
ACCOUNT_ID NUMBER

Account Identifier
PLANNED_AMT NUMBER

Planned Amount of the fund
COMMITTED_AMT NUMBER

Committed Amount for the fund
UTILIZED_AMT NUMBER

Utilized Amount for the Fund
EARNED_AMT NUMBER

Earned Amount
PAID_AMT NUMBER

Paid Amount for the fund
RECAL_COMMITTED NUMBER

Recalculated Committed Amount
TOTAL NUMBER

Total Amount of the fund.
Query Text

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


SELECT FUND_ID
,      FUND_NUMBER
,      SHORT_NAME
,      CURRENCY
,      CUSTOM_SETUP_ID
,      OWNER
,      CUST_NAME
,      PARTY_ID
,      ACCOUNT_NAME
,      ACCOUNT_ID
,      PLANNED_AMT
,      COMMITTED_AMT
,      UTILIZED_AMT
,      EARNED_AMT
,      PAID_AMT
,      RECAL_COMMITTED
,      TOTAL
FROM APPS.OZF_FUNDS_CUST_V;

Dependencies

[top of page]

APPS.OZF_FUNDS_CUST_V references the following:

SchemaAPPS
SynonymAMS_ACT_MARKET_SEGMENTS
ViewAMS_CELLS_VL
ViewAMS_LIST_HEADERS_VL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
ViewOZF_FUNDS_ALL_VL
ViewOZF_TERR_V
SynonymQP_QUALIFIERS

APPS.OZF_FUNDS_CUST_V is not referenced by any database object