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


TABLE: BIM.EDW_BIM_OPPORTUNITIES_M_TEMP

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

Temporary Table Details

BIM.EDW_BIM_OPPORTUNITIES_M_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
L2_OPPLINE_PK_KEY NUMBER

L1_OPPORTUNITY_PK_KEY NUMBER

L0_ALL_PK_KEY NUMBER

L0_ALL_PK VARCHAR2 (40)
L0_NAME VARCHAR2 (80)
L1_OPPORTUNITY_PK VARCHAR2 (240)
L1_OPPORTUNITY_DP VARCHAR2 (240)
L1_NAME VARCHAR2 (240)
L1_OPPORTUNITY_LEAD_ID NUMBER

L1_OPP_LEAD_NUMBER VARCHAR2 (240)
L1_WIN_PROBABILITY NUMBER

L1_SALES_STAGE_ID NUMBER

L1_PRICE_LIST_ID NUMBER

L1_INITIATING_CONTACT_ID NUMBER

L1_CLOSE_COMPETITOR_ID NUMBER

L1_SOURCE_PROMOTION_ID NUMBER

L1_ADDRESS_ID NUMBER

L1_CUSTOMER_ID NUMBER

L1_RANK VARCHAR2 (240)
L1_PARENT_PROJECT VARCHAR2 (240)
L1_NO_OPP_ALLOWED_FLAG VARCHAR2 (40)
L1_LEAD_SOURCE_CODE VARCHAR2 (240)
L1_END_USER_CUSTOMER_NAME VARCHAR2 (240)
L1_DELETE_ALLOWED_FLAG VARCHAR2 (40)
L1_DECISION_DATE_FLAG VARCHAR2 (40)
L1_CURRENCY_CODE VARCHAR2 (240)
L1_TOTAL_AMOUNT NUMBER

L1_CLOSE_REASON VARCHAR2 (240)
L1_CLOSE_COMPETITOR_CODE VARCHAR2 (240)
L1_CLOSE_COMPETITOR VARCHAR2 (240)
L1_CLOSE_COMMENT VARCHAR2 (240)
L1_CHANNEL_CODE VARCHAR2 (80)
L1_DECISION_DATE DATE

L1_OPP_DESCRIPTION VARCHAR2 (2000)
L1_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
L1_DECISION_TIMEFRAME_CODE VARCHAR2 (80)
L1_VEHICLE_RESPONSE_CODE VARCHAR2 (80)
L1_DELETED_FLAG VARCHAR2 (20)
L1_INSTANCE VARCHAR2 (240)
L1_USER_ATTRIBUTE1 VARCHAR2 (240)
L1_USER_ATTRIBUTE2 VARCHAR2 (240)
L1_USER_ATTRIBUTE3 VARCHAR2 (240)
L1_USER_ATTRIBUTE4 VARCHAR2 (240)
L1_USER_ATTRIBUTE5 VARCHAR2 (240)
L2_OPPLINE_PK VARCHAR2 (240)
L2_OPPLINE_DP VARCHAR2 (240)
L2_NAME VARCHAR2 (240)
L2_OPP_LEAD_LINE_ID NUMBER

L2_LEAD_ID NUMBER

L2_WIN_PROBABILITY NUMBER

L2_SALES_STAGE_ID NUMBER

L2_PRICE_VOLUME_MARGIN NUMBER

L2_PRICE NUMBER

L2_ORIG_OPPORTUNITY_LINE_ID NUMBER

L2_ORIGINAL_LEAD_LINE_ID NUMBER

L2_QUOTED_LINE_FLAG VARCHAR2 (240)
L2_CHANNEL_CODE VARCHAR2 (80)
L2_SHIP_DATE DATE

L2_DECISION_DATE DATE

L2_INSTANCE VARCHAR2 (240)
L2_USER_ATTRIBUTE1 VARCHAR2 (240)
L2_USER_ATTRIBUTE2 VARCHAR2 (240)
L2_USER_ATTRIBUTE3 VARCHAR2 (240)
L2_USER_ATTRIBUTE4 VARCHAR2 (240)
L2_USER_ATTRIBUTE5 VARCHAR2 (240)
L2_LAST_UPDATE_DATE DATE

L2_CREATION_DATE DATE

SECURITY_GROUP_ID NUMBER

ROW_ID1 ROWID (10)
ROW_ID2 ROWID (10)
OPERATION_CODE1 VARCHAR2 (40)
OPERATION_CODE2 VARCHAR2 (40)
Query Text

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


SELECT L2_OPPLINE_PK_KEY
,      L1_OPPORTUNITY_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_OPPORTUNITY_PK
,      L1_OPPORTUNITY_DP
,      L1_NAME
,      L1_OPPORTUNITY_LEAD_ID
,      L1_OPP_LEAD_NUMBER
,      L1_WIN_PROBABILITY
,      L1_SALES_STAGE_ID
,      L1_PRICE_LIST_ID
,      L1_INITIATING_CONTACT_ID
,      L1_CLOSE_COMPETITOR_ID
,      L1_SOURCE_PROMOTION_ID
,      L1_ADDRESS_ID
,      L1_CUSTOMER_ID
,      L1_RANK
,      L1_PARENT_PROJECT
,      L1_NO_OPP_ALLOWED_FLAG
,      L1_LEAD_SOURCE_CODE
,      L1_END_USER_CUSTOMER_NAME
,      L1_DELETE_ALLOWED_FLAG
,      L1_DECISION_DATE_FLAG
,      L1_CURRENCY_CODE
,      L1_TOTAL_AMOUNT
,      L1_CLOSE_REASON
,      L1_CLOSE_COMPETITOR_CODE
,      L1_CLOSE_COMPETITOR
,      L1_CLOSE_COMMENT
,      L1_CHANNEL_CODE
,      L1_DECISION_DATE
,      L1_OPP_DESCRIPTION
,      L1_ORIG_SYSTEM_REFERENCE
,      L1_DECISION_TIMEFRAME_CODE
,      L1_VEHICLE_RESPONSE_CODE
,      L1_DELETED_FLAG
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_OPPLINE_PK
,      L2_OPPLINE_DP
,      L2_NAME
,      L2_OPP_LEAD_LINE_ID
,      L2_LEAD_ID
,      L2_WIN_PROBABILITY
,      L2_SALES_STAGE_ID
,      L2_PRICE_VOLUME_MARGIN
,      L2_PRICE
,      L2_ORIG_OPPORTUNITY_LINE_ID
,      L2_ORIGINAL_LEAD_LINE_ID
,      L2_QUOTED_LINE_FLAG
,      L2_CHANNEL_CODE
,      L2_SHIP_DATE
,      L2_DECISION_DATE
,      L2_INSTANCE
,      L2_USER_ATTRIBUTE1
,      L2_USER_ATTRIBUTE2
,      L2_USER_ATTRIBUTE3
,      L2_USER_ATTRIBUTE4
,      L2_USER_ATTRIBUTE5
,      L2_LAST_UPDATE_DATE
,      L2_CREATION_DATE
,      SECURITY_GROUP_ID
,      ROW_ID1
,      ROW_ID2
,      OPERATION_CODE1
,      OPERATION_CODE2
FROM BIM.EDW_BIM_OPPORTUNITIES_M_TEMP;

Dependencies

[top of page]

BIM.EDW_BIM_OPPORTUNITIES_M_TEMP does not reference any database object

BIM.EDW_BIM_OPPORTUNITIES_M_TEMP is referenced by following:

SchemaAPPS
SynonymEDW_BIM_OPPORTUNITIES_M_TEMP