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

VIEW: BIM.BIM_R_KPI_FACTS#

Object Details
Object Name: BIM_R_KPI_FACTS#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

OBJECT_ID NUMBER

OBJECT_TYPE VARCHAR2 (4)
REGION VARCHAR2 (30)
COUNTRY NUMBER

BUSINESS_UNIT NUMBER

START_DATE DATE

END_DATE DATE

STATUS VARCHAR2 (30)
PERIOD_TYPE VARCHAR2 (15)
CALCULATION_TYPE VARCHAR2 (15)
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

ORDERS_CUR_PERIOD NUMBER

ORDERS_PRE_PERIOD NUMBER

RES_CUR_PERIOD NUMBER

RES_PRE_PERIOD NUMBER

ALEADS_CUR_PERIOD NUMBER

ALEADS_PRE_PERIOD NUMBER

Query Text

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


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
,      OBJECT_TYPE
,      REGION
,      COUNTRY
,      BUSINESS_UNIT
,      START_DATE
,      END_DATE
,      STATUS
,      PERIOD_TYPE
,      CALCULATION_TYPE
,      COST_CUR_PERIOD
,      COST_PRE_PERIOD
,      LEADS_CUR_PERIOD
,      LEADS_PRE_PERIOD
,      REG_CUR_PERIOD
,      REG_PRE_PERIOD
,      REV_CUR_PERIOD
,      REV_PRE_PERIOD
,      ORDERS_CUR_PERIOD
,      ORDERS_PRE_PERIOD
,      RES_CUR_PERIOD
,      RES_PRE_PERIOD
,      ALEADS_CUR_PERIOD
,      ALEADS_PRE_PERIOD
FROM BIM.BIM_R_KPI_FACTS#;

Dependencies

[top of page]

BIM.BIM_R_KPI_FACTS# references the following:

SchemaBIM
TableBIM_R_KPI_FACTS
BIM.BIM_R_KPI_FACTS# is referenced by following:

SchemaAPPS
SynonymBIM_R_KPI_FACTS