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

TABLE: BIM.BIM_R_LEAD_SO_BIN_MV_BASE

Object Details
Object Name: BIM_R_LEAD_SO_BIN_MV_BASE
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


Base MV for Lead Source Region Bin


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

Group Identifier
LEAD_STATUS VARCHAR2 (30)
Lead Status
OPEN_FLAG VARCHAR2 (3)
Open flag
REGION VARCHAR2 (30)
Region
COUNTRY VARCHAR2 (30)
Country
BUSINESS_UNIT_ID NUMBER

Business unit identifier
YEAR VARCHAR2 (30)
Year
QTR VARCHAR2 (30)
Quarter
MONTH VARCHAR2 (30)
Month
MONTH_ORDER NUMBER

Month Order
AGGREGATE_BY VARCHAR2 (9)
Summation By
DISPLAY_TYPE VARCHAR2 (7)
Type of display
CURR_A NUMBER

Current A
PREV_A NUMBER

Previous A
CURR_B NUMBER

Current B
PREV_B NUMBER

Previous B
CURR_C NUMBER

Current C
PREV_C NUMBER

Previous C
CURR_D NUMBER

Current D
PREV_D NUMBER

Previous D
CURR_E NUMBER

Current E
PREV_E NUMBER

Previous E
CURR_F NUMBER

Current F
PREV_F NUMBER

Previous F
CURR_G NUMBER

Current G
PREV_G NUMBER

Previous G
CURR_H NUMBER

Current H
PREV_H NUMBER

Previous H
CURR_I NUMBER

Current I
PREV_I NUMBER

Previous I
CURR_J NUMBER

Current J
PREV_J NUMBER

Previous J
CURR_OTHERS NUMBER

Current Others
PREV_OTHERS NUMBER

Previous Others
Query Text

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


SELECT GROUP_ID
,      LEAD_STATUS
,      OPEN_FLAG
,      REGION
,      COUNTRY
,      BUSINESS_UNIT_ID
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      CURR_A
,      PREV_A
,      CURR_B
,      PREV_B
,      CURR_C
,      PREV_C
,      CURR_D
,      PREV_D
,      CURR_E
,      PREV_E
,      CURR_F
,      PREV_F
,      CURR_G
,      PREV_G
,      CURR_H
,      PREV_H
,      CURR_I
,      PREV_I
,      CURR_J
,      PREV_J
,      CURR_OTHERS
,      PREV_OTHERS
FROM BIM.BIM_R_LEAD_SO_BIN_MV_BASE;

Dependencies

[top of page]

BIM.BIM_R_LEAD_SO_BIN_MV_BASE does not reference any database object

BIM.BIM_R_LEAD_SO_BIN_MV_BASE is referenced by following:

SchemaBIM
ViewBIM_R_LEAD_SO_BIN_MV_BASE#