[Home] [Help] [Dependency Information]
Object Name: | BIC_P_SUMM_CC_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 0 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_START_DATE | DATE | Yes | ||
CUST_CAT | VARCHAR2 | (30) | ||
START_DATE | DATE | Yes | ||
ACT_YEAR | NUMBER | |||
ACT_QUARTER | NUMBER | |||
ACT_HALF_YEAR | NUMBER | |||
AVG_SATISFACTION | NUMBER | |||
COUNT_SATISFACTION | NUMBER | |||
SUM_SATISFACTION | NUMBER | |||
AVG_LOYALTY | NUMBER | |||
COUNT_LOYALTY | NUMBER | |||
SUM_LOYALTY | NUMBER | |||
COGS | NUMBER | |||
COUNT_COGS | NUMBER | |||
SALES | NUMBER | |||
COUNT_SALES | NUMBER | |||
RECS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_START_DATE
, CUST_CAT
, START_DATE
, ACT_YEAR
, ACT_QUARTER
, ACT_HALF_YEAR
, AVG_SATISFACTION
, COUNT_SATISFACTION
, SUM_SATISFACTION
, AVG_LOYALTY
, COUNT_LOYALTY
, SUM_LOYALTY
, COGS
, COUNT_COGS
, SALES
, COUNT_SALES
, RECS
FROM APPS.BIC_P_SUMM_CC_MV;
APPS.BIC_P_SUMM_CC_MV does not reference any database object
APPS.BIC_P_SUMM_CC_MV is not referenced by any database object
|
|
|