Skip to content

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

TABLE: BIM.BIM_R_LEAD_QU_FACTS_TEMP

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


Lead Quality Region Fact table


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

Group Identifier
TRANSACTION_CREATE_DATE DATE

Date of transaction creation
LEAD_STATUS VARCHAR2 (30)
Status of the lead
OPEN_FLAG VARCHAR2 (3)
open flag
OBJECT_TYPE VARCHAR2 (30)
Type of object
OBJECT_ID NUMBER

object identifier
REGION VARCHAR2 (30)
region
COUNTRY VARCHAR2 (30)
country
BUSINESS_UNIT_ID NUMBER

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

A
B NUMBER

B
C NUMBER

C
D NUMBER

D
E NUMBER

E
F NUMBER

F
G NUMBER

G
H NUMBER

H
I NUMBER

I
J NUMBER

J
OTHERS NUMBER

Others
Query Text

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


SELECT GROUP_ID
,      TRANSACTION_CREATE_DATE
,      LEAD_STATUS
,      OPEN_FLAG
,      OBJECT_TYPE
,      OBJECT_ID
,      REGION
,      COUNTRY
,      BUSINESS_UNIT_ID
,      MONTH
,      QTR
,      YEAR
,      A
,      B
,      C
,      D
,      E
,      F
,      G
,      H
,      I
,      J
,      OTHERS
FROM BIM.BIM_R_LEAD_QU_FACTS_TEMP;

Dependencies

[top of page]

BIM.BIM_R_LEAD_QU_FACTS_TEMP does not reference any database object

BIM.BIM_R_LEAD_QU_FACTS_TEMP is referenced by following:

SchemaBIM
ViewBIM_R_LEAD_QU_FACTS_TEMP#