[Home] [Help] [Dependency Information]
Object Name: | OZF_EARNING_SUMMARY_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | OZF.OZF_EARNING_SUMMARY_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_ACCOUNT_ID | NUMBER | |||
ITEM_CATEGORY_ID | NUMBER | |||
OFFER_TYPE | VARCHAR2 | (30) | ||
OBJECT_TYPE | VARCHAR2 | (30) | ||
ACTIVITY_TYPE | NUMBER | |||
ORG_ID | NUMBER | |||
AMOUNT_EARNED | NUMBER | |||
AMOUNT_EARNED_CNT | NUMBER | |||
AMOUNT_PAID | NUMBER | |||
AMOUNT_PAID_CNT | NUMBER | |||
AMOUNT_BALANCE | NUMBER | |||
AMOUNT_BALANCE_CNT | NUMBER | |||
ALL_CNT | NUMBER | |||
GRP_CUST_ACCOUNT_ID | NUMBER | |||
GRP_ITEM_CATEGORY_ID | NUMBER | |||
GRP_OFFER_TYPE | NUMBER | |||
GRP_OBJECT_TYPE | NUMBER | |||
GRP_ACTIVITY_TYPE | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
TIME_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CUST_ACCOUNT_ID
, ITEM_CATEGORY_ID
, OFFER_TYPE
, OBJECT_TYPE
, ACTIVITY_TYPE
, ORG_ID
, AMOUNT_EARNED
, AMOUNT_EARNED_CNT
, AMOUNT_PAID
, AMOUNT_PAID_CNT
, AMOUNT_BALANCE
, AMOUNT_BALANCE_CNT
, ALL_CNT
, GRP_CUST_ACCOUNT_ID
, GRP_ITEM_CATEGORY_ID
, GRP_OFFER_TYPE
, GRP_OBJECT_TYPE
, GRP_ACTIVITY_TYPE
, PERIOD_TYPE_ID
, TIME_ID
FROM APPS.OZF_EARNING_SUMMARY_MV;
APPS.OZF_EARNING_SUMMARY_MV does not reference any database object
APPS.OZF_EARNING_SUMMARY_MV is referenced by following:
|
|
|