[Home] [Help] [Dependency Information]
Object Name: | BIM_R_KPI_SUMMARY_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | |||
OBJECT_ID | NUMBER | |||
OBJECT_NAME | VARCHAR2 | (240) | ||
OBJECT_TYPE | VARCHAR2 | (4) | ||
ONE_OFF_FLAG | VARCHAR2 | (1) | ||
PERIOD_TYPE | VARCHAR2 | (15) | ||
AREA1_CODE | VARCHAR2 | (30) | ||
AREA2_CODE | VARCHAR2 | (30) | ||
COUNTRY | VARCHAR2 | (30) | ||
BUSINESS_UNIT_ID | NUMBER | |||
STATUS | VARCHAR2 | (30) | ||
COST_CUR_PERIOD | NUMBER | |||
COST_PRE_PERIOD | NUMBER | |||
LEADS_CUR_PERIOD | NUMBER | |||
LEADS_PRE_PERIOD | NUMBER | |||
REG_CUR_PERIOD | NUMBER | |||
REG_PRE_PERIOD | NUMBER | |||
REV_CUR_PERIOD | NUMBER | |||
REV_PRE_PERIOD | NUMBER | |||
RES_CUR_PERIOD | NUMBER | |||
RES_PRE_PERIOD | NUMBER | |||
ORDERS_CUR_PERIOD | NUMBER | |||
ORDERS_PRE_PERIOD | NUMBER | |||
ALEADS_CUR_PERIOD | NUMBER | |||
ALEADS_PRE_PERIOD | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, OBJECT_ID
, OBJECT_NAME
, OBJECT_TYPE
, ONE_OFF_FLAG
, PERIOD_TYPE
, AREA1_CODE
, AREA2_CODE
, COUNTRY
, BUSINESS_UNIT_ID
, STATUS
, COST_CUR_PERIOD
, COST_PRE_PERIOD
, LEADS_CUR_PERIOD
, LEADS_PRE_PERIOD
, REG_CUR_PERIOD
, REG_PRE_PERIOD
, REV_CUR_PERIOD
, REV_PRE_PERIOD
, RES_CUR_PERIOD
, RES_PRE_PERIOD
, ORDERS_CUR_PERIOD
, ORDERS_PRE_PERIOD
, ALEADS_CUR_PERIOD
, ALEADS_PRE_PERIOD
FROM APPS.BIM_R_KPI_SUMMARY_MV;
APPS.BIM_R_KPI_SUMMARY_MV does not reference any database object
APPS.BIM_R_KPI_SUMMARY_MV is not referenced by any database object
|
|
|