eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIM.EDW_BIM_EVENTS_M_TEMP

Object Details

Object Name:	EDW_BIM_EVENTS_M_TEMP
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Temporary Table Details

BIM.EDW_BIM_EVENTS_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:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
L2_EVTOFFER_PK_KEY	NUMBER
L1_EVENT_PK_KEY	NUMBER
L0_ALL_PK_KEY	NUMBER
L0_ALL_PK	VARCHAR2	(40)
L0_NAME	VARCHAR2	(80)
L1_EVENT_PK	VARCHAR2	(320)
L1_EVENT_DP	VARCHAR2	(240)
L1_NAME	VARCHAR2	(320)
L1_EVENT_HEADER_ID	NUMBER
L1_PARENT_EVENT_HEADER_ID	NUMBER
L1_EVENT_LEVEL	VARCHAR2	(40)
L1_EVENT_TYPE_CODE	VARCHAR2	(40)
L1_USER_STATUS_ID	NUMBER
L1_SYSTEM_STATUS_CODE	VARCHAR2	(40)
L1_LAST_STATUS_DATE	DATE
L1_REG_REQUIRED_FLAG	VARCHAR2	(20)
L1_REG_INVITED_ONLY_FLAG	VARCHAR2	(20)
L1_REG_CHARGE_FLAG	VARCHAR2	(20)
L1_EVENT_STANDALONE_FLAG	VARCHAR2	(20)
L1_REG_MINIMUM_CAPACITY	NUMBER
L1_REG_MAXIMUM_CAPACITY	NUMBER
L1_SOURCE_CODE	VARCHAR2	(40)
L1_DURATION	NUMBER
L1_DURATION_UOM_CODE	VARCHAR2	(20)
L1_DAY_OF_EVENT	VARCHAR2	(40)
L1_COORDINATOR_ID	NUMBER
L1_OWNER_USER_ID	NUMBER
L1_INVENTORY_ITEM_ID	NUMBER
L1_ORG_ID	NUMBER
L1_CERT_CREDIT_TYPE_CODE	VARCHAR2	(40)
L1_CERTIFICATION_CREDITS	NUMBER
L1_STREAM_TYPE_CODE	VARCHAR2	(40)
L1_PARTNER_FLAG	VARCHAR2	(20)
L1_OVERFLOW_FLAG	VARCHAR2	(20)
L1_MAIN_LANGUAGE_CODE	VARCHAR2	(20)
L1_CANCELLATION_REASON_CODE	VARCHAR2	(320)
L1_PRIORITY_TYPE_CODE	VARCHAR2	(320)
L1_AGENDA_START_TIME	DATE
L1_AGENDA_END_TIME	DATE
L1_ACTIVE_FROM_DATE	DATE
L1_ACTIVE_TO_DATE	DATE
L1_INBOUND_SCRIPT_NAME	VARCHAR2	(320)
L1_EMAIL	VARCHAR2	(320)
L1_PHONE	VARCHAR2	(320)
L1_URL	VARCHAR2	(4000)
L1_EVENT_MKTG_MESSAGE	VARCHAR2	(4000)
L1_EVENT_HEADER_NAME	VARCHAR2	(320)
L1_DESCRIPTION	VARCHAR2	(4000)
L1_INSTANCE	VARCHAR2	(40)
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_EVTOFFER_PK	VARCHAR2	(320)
L2_EVTOFFER_DP	VARCHAR2	(240)
L2_NAME	VARCHAR2	(320)
L2_LEVEL_NAME	VARCHAR2	(80)
L2_EVTOFFER_ID	NUMBER
L2_PARENT_EVENT_OFFER_ID	NUMBER
L2_EVENT_HEADER_ID	NUMBER
L2_EVENT_LEVEL	VARCHAR2	(40)
L2_EVENT_TYPE_CODE	VARCHAR2	(40)
L2_USER_STATUS_ID	NUMBER
L2_SYSTEM_STATUS_CODE	VARCHAR2	(40)
L2_LAST_STATUS_DATE	DATE
L2_TIMEZONE_ID	NUMBER
L2_REG_WAITLIST_PCT	NUMBER
L2_REG_OVERBOOK_PCT	NUMBER
L2_REG_MINIMUM_CAPACITY	NUMBER
L2_REG_MAXIMUM_CAPACITY	NUMBER
L2_REG_EFFECTIVE_CAPACITY	NUMBER
L2_PRICELIST_LINE_ID	NUMBER
L2_PRICELIST_HEADER_ID	NUMBER
L2_OWNER_USER_ID	NUMBER
L2_ORG_ID	NUMBER
L2_INVENTORY_ITEM_ID	NUMBER
L2_EVENT_LOCATION_ID	NUMBER
L2_EVENT_DURATION	NUMBER
L2_EVENT_DELIVERY_METHOD_ID	NUMBER
L2_COORDINATOR_ID	NUMBER
L2_CERTIFICATION_CREDITS	NUMBER
L2_WAITLIST_ACTION_TYPE_CODE	VARCHAR2	(40)
L2_STREAM_TYPE_CODE	VARCHAR2	(40)
L2_SOURCE_CODE	VARCHAR2	(40)
L2_REG_WAITLIST_ALLOWED_FLAG	VARCHAR2	(20)
L2_REG_START_TIME	DATE
L2_REG_REQUIRED_FLAG	VARCHAR2	(20)
L2_REG_OVERBOOK_ALLOWED_FLAG	VARCHAR2	(20)
L2_REG_INVITED_ONLY_FLAG	VARCHAR2	(20)
L2_REG_FROZEN_FLAG	VARCHAR2	(20)
L2_REG_END_TIME	DATE
L2_REG_CHARGE_FLAG	VARCHAR2	(20)
L2_PRIORITY_TYPE_CODE	VARCHAR2	(40)
L2_PARTNER_FLAG	VARCHAR2	(20)
L2_OVERFLOW_FLAG	VARCHAR2	(20)
L2_EVENT_START_DATE_TIME	DATE
L2_EVENT_STANDALONE_FLAG	VARCHAR2	(20)
L2_EVENT_REQUIRED_FLAG	VARCHAR2	(20)
L2_EVENT_LANGUAGE_CODE	VARCHAR2	(40)
L2_EVENT_FULL_FLAG	VARCHAR2	(20)
L2_EVENT_END_DATE_TIME	DATE
L2_EVENT_DURATION_UOM_CODE	VARCHAR2	(20)
L2_CERT_CREDIT_TYPE_CODE	VARCHAR2	(40)
L2_CANCELLATION_REASON_CODE	VARCHAR2	(40)
L2_INBOUND_SCRIPT_NAME	VARCHAR2	(320)
L2_EMAIL	VARCHAR2	(320)
L2_PHONE	VARCHAR2	(320)
L2_URL	VARCHAR2	(4000)
L2_AUTO_REGISTER_FLAG	VARCHAR2	(20)
L2_EVENT_VENUE_ID	NUMBER
L2_REG_START_DATE	DATE
L2_REG_MINIMUM_REQ_BY_DATE	DATE
L2_REG_END_DATE	DATE
L2_EVENT_START_DATE	DATE
L2_EVENT_END_DATE	DATE
L2_EVENT_MKTG_MESSAGE	VARCHAR2	(320)
L2_EVENT_OFFER_NAME	VARCHAR2	(320)
L2_DESCRIPTION	VARCHAR2	(4000)
L2_INSTANCE	VARCHAR2	(40)
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_EVTOFFER_PK_KEY
,      L1_EVENT_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_EVENT_PK
,      L1_EVENT_DP
,      L1_NAME
,      L1_EVENT_HEADER_ID
,      L1_PARENT_EVENT_HEADER_ID
,      L1_EVENT_LEVEL
,      L1_EVENT_TYPE_CODE
,      L1_USER_STATUS_ID
,      L1_SYSTEM_STATUS_CODE
,      L1_LAST_STATUS_DATE
,      L1_REG_REQUIRED_FLAG
,      L1_REG_INVITED_ONLY_FLAG
,      L1_REG_CHARGE_FLAG
,      L1_EVENT_STANDALONE_FLAG
,      L1_REG_MINIMUM_CAPACITY
,      L1_REG_MAXIMUM_CAPACITY
,      L1_SOURCE_CODE
,      L1_DURATION
,      L1_DURATION_UOM_CODE
,      L1_DAY_OF_EVENT
,      L1_COORDINATOR_ID
,      L1_OWNER_USER_ID
,      L1_INVENTORY_ITEM_ID
,      L1_ORG_ID
,      L1_CERT_CREDIT_TYPE_CODE
,      L1_CERTIFICATION_CREDITS
,      L1_STREAM_TYPE_CODE
,      L1_PARTNER_FLAG
,      L1_OVERFLOW_FLAG
,      L1_MAIN_LANGUAGE_CODE
,      L1_CANCELLATION_REASON_CODE
,      L1_PRIORITY_TYPE_CODE
,      L1_AGENDA_START_TIME
,      L1_AGENDA_END_TIME
,      L1_ACTIVE_FROM_DATE
,      L1_ACTIVE_TO_DATE
,      L1_INBOUND_SCRIPT_NAME
,      L1_EMAIL
,      L1_PHONE
,      L1_URL
,      L1_EVENT_MKTG_MESSAGE
,      L1_EVENT_HEADER_NAME
,      L1_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_EVTOFFER_PK
,      L2_EVTOFFER_DP
,      L2_NAME
,      L2_LEVEL_NAME
,      L2_EVTOFFER_ID
,      L2_PARENT_EVENT_OFFER_ID
,      L2_EVENT_HEADER_ID
,      L2_EVENT_LEVEL
,      L2_EVENT_TYPE_CODE
,      L2_USER_STATUS_ID
,      L2_SYSTEM_STATUS_CODE
,      L2_LAST_STATUS_DATE
,      L2_TIMEZONE_ID
,      L2_REG_WAITLIST_PCT
,      L2_REG_OVERBOOK_PCT
,      L2_REG_MINIMUM_CAPACITY
,      L2_REG_MAXIMUM_CAPACITY
,      L2_REG_EFFECTIVE_CAPACITY
,      L2_PRICELIST_LINE_ID
,      L2_PRICELIST_HEADER_ID
,      L2_OWNER_USER_ID
,      L2_ORG_ID
,      L2_INVENTORY_ITEM_ID
,      L2_EVENT_LOCATION_ID
,      L2_EVENT_DURATION
,      L2_EVENT_DELIVERY_METHOD_ID
,      L2_COORDINATOR_ID
,      L2_CERTIFICATION_CREDITS
,      L2_WAITLIST_ACTION_TYPE_CODE
,      L2_STREAM_TYPE_CODE
,      L2_SOURCE_CODE
,      L2_REG_WAITLIST_ALLOWED_FLAG
,      L2_REG_START_TIME
,      L2_REG_REQUIRED_FLAG
,      L2_REG_OVERBOOK_ALLOWED_FLAG
,      L2_REG_INVITED_ONLY_FLAG
,      L2_REG_FROZEN_FLAG
,      L2_REG_END_TIME
,      L2_REG_CHARGE_FLAG
,      L2_PRIORITY_TYPE_CODE
,      L2_PARTNER_FLAG
,      L2_OVERFLOW_FLAG
,      L2_EVENT_START_DATE_TIME
,      L2_EVENT_STANDALONE_FLAG
,      L2_EVENT_REQUIRED_FLAG
,      L2_EVENT_LANGUAGE_CODE
,      L2_EVENT_FULL_FLAG
,      L2_EVENT_END_DATE_TIME
,      L2_EVENT_DURATION_UOM_CODE
,      L2_CERT_CREDIT_TYPE_CODE
,      L2_CANCELLATION_REASON_CODE
,      L2_INBOUND_SCRIPT_NAME
,      L2_EMAIL
,      L2_PHONE
,      L2_URL
,      L2_AUTO_REGISTER_FLAG
,      L2_EVENT_VENUE_ID
,      L2_REG_START_DATE
,      L2_REG_MINIMUM_REQ_BY_DATE
,      L2_REG_END_DATE
,      L2_EVENT_START_DATE
,      L2_EVENT_END_DATE
,      L2_EVENT_MKTG_MESSAGE
,      L2_EVENT_OFFER_NAME
,      L2_DESCRIPTION
,      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_EVENTS_M_TEMP;

Dependencies

[top of page]

BIM.EDW_BIM_EVENTS_M_TEMP does not reference any database object

BIM.EDW_BIM_EVENTS_M_TEMP is referenced by following:

APPS: EDW_BIM_EVENTS_M_TEMP