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

VIEW: APPS.OZF_CUST_FUND_SUMMARY_MV#

Object Details
Object Name: OZF_CUST_FUND_SUMMARY_MV#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

PARTY_ID NUMBER (15)
CUST_ACCOUNT_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

SHIP_TO_SITE_USE_ID NUMBER

PRODUCT_LEVEL_TYPE VARCHAR2 (30)
PRODUCT_ID NUMBER

PLAN_TYPE VARCHAR2 (30)
PLAN_ID NUMBER

FUND_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
STATUS_CODE VARCHAR2 (30)
OWNER NUMBER

CATEGORY_ID NUMBER

ORG_ID NUMBER

UTILIZED_AMT NUMBER

EARNED_AMT NUMBER

PAID_AMT NUMBER

FUNC_CURR_UTILIZED_AMT NUMBER

FUNC_CURR_EARNED_AMT NUMBER

FUNC_CURR_PAID_AMT NUMBER

PLAN_CURR_UTILIZED_AMT NUMBER

PLAN_CURR_EARNED_AMT NUMBER

PLAN_CURR_PAID_AMT NUMBER

UNIV_CURR_UTILIZED_AMT NUMBER

UNIV_CURR_EARNED_AMT NUMBER

UNIV_CURR_PAID_AMT NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      PRODUCT_LEVEL_TYPE
,      PRODUCT_ID
,      PLAN_TYPE
,      PLAN_ID
,      FUND_ID
,      CURRENCY_CODE
,      STATUS_CODE
,      OWNER
,      CATEGORY_ID
,      ORG_ID
,      UTILIZED_AMT
,      EARNED_AMT
,      PAID_AMT
,      FUNC_CURR_UTILIZED_AMT
,      FUNC_CURR_EARNED_AMT
,      FUNC_CURR_PAID_AMT
,      PLAN_CURR_UTILIZED_AMT
,      PLAN_CURR_EARNED_AMT
,      PLAN_CURR_PAID_AMT
,      UNIV_CURR_UTILIZED_AMT
,      UNIV_CURR_EARNED_AMT
,      UNIV_CURR_PAID_AMT
FROM APPS.OZF_CUST_FUND_SUMMARY_MV#;

Dependencies

[top of page]

APPS.OZF_CUST_FUND_SUMMARY_MV# references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymOZF_FUNDS_ALL_B
ViewOZF_FUNDS_PAID_V
SynonymOZF_FUNDS_UTILIZED_ALL_B
SynonymOZF_TIME_DAY

APPS.OZF_CUST_FUND_SUMMARY_MV# is not referenced by any database object