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

TABLE: APPS.BIM_R_LEAD_QU_BIN_MV

Object Details
Object Name: BIM_R_LEAD_QU_BIN_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

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

LEAD_STATUS VARCHAR2 (30)
OPEN_FLAG VARCHAR2 (3)
REGION VARCHAR2 (30)
COUNTRY VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

YEAR VARCHAR2 (30)
QTR VARCHAR2 (30)
MONTH VARCHAR2 (30)
MONTH_ORDER NUMBER

AGGREGATE_BY VARCHAR2 (9)
DISPLAY_TYPE VARCHAR2 (7)
CURR_A NUMBER

PREV_A NUMBER

CURR_B NUMBER

PREV_B NUMBER

CURR_C NUMBER

PREV_C NUMBER

CURR_D NUMBER

PREV_D NUMBER

CURR_E NUMBER

PREV_E NUMBER

CURR_F NUMBER

PREV_F NUMBER

CURR_G NUMBER

PREV_G NUMBER

CURR_H NUMBER

PREV_H NUMBER

CURR_I NUMBER

PREV_I NUMBER

CURR_J NUMBER

PREV_J NUMBER

CURR_OTHERS NUMBER

PREV_OTHERS NUMBER

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 APPS.BIM_R_LEAD_QU_BIN_MV;

Dependencies

[top of page]

APPS.BIM_R_LEAD_QU_BIN_MV does not reference any database object

APPS.BIM_R_LEAD_QU_BIN_MV is referenced by following:

SchemaAPPS
Package BodyAMS_DCF_LEADS_TITLE - show dependent code