[Home] [Help] [Dependency Information]
Object Name: | BIC_P_SUMM_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) | ||
MKT_SEG | NUMBER | |||
ORG_ID | NUMBER | |||
CITY | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (60) | ||
COUNTRY | VARCHAR2 | (60) | ||
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 | |||
RECORDS | NUMBER | |||
ACT_YEAR | NUMBER | |||
ACT_QUARTER | NUMBER | |||
ACT_HALF_YEAR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_START_DATE
, CUST_CAT
, MKT_SEG
, ORG_ID
, CITY
, STATE
, COUNTRY
, AVG_SATISFACTION
, COUNT_SATISFACTION
, SUM_SATISFACTION
, AVG_LOYALTY
, COUNT_LOYALTY
, SUM_LOYALTY
, COGS
, COUNT_COGS
, SALES
, COUNT_SALES
, RECORDS
, ACT_YEAR
, ACT_QUARTER
, ACT_HALF_YEAR
FROM APPS.BIC_P_SUMM_MV;
APPS.BIC_P_SUMM_MV does not reference any database object
APPS.BIC_P_SUMM_MV is not referenced by any database object
|
|
|