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

TABLE: BIM.BIM_R_LEAD_ST_FACTS_TEMP

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


Temporary fact Table for Lead Status Campaign


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

Group Identifier
TRANSACTION_CREATE_DATE DATE

Date of transaction creation
OBJECT_TYPE VARCHAR2 (30)
Object type
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
,      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_ST_FACTS_TEMP;

Dependencies

[top of page]

BIM.BIM_R_LEAD_ST_FACTS_TEMP does not reference any database object

BIM.BIM_R_LEAD_ST_FACTS_TEMP is referenced by following:

SchemaBIM
ViewBIM_R_LEAD_ST_FACTS_TEMP#