[Home] [Help] [Dependency Information]

TABLE: BIM.EDW_BIM_SRCLSTS_M_TEMP

Object Details

Temporary Table Details

BIM.EDW_BIM_SRCLSTS_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

Query Text

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

SELECT L1_SRCLST_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_SRCLST_PK
,      L1_SRCLST_DP
,      L1_NAME
,      L1_IMPORT_LIST_HEADER_ID
,      L1_LIST_SOURCE_TYPE_ID
,      L1_LIST_SOURCE_TYPE
,      L1_USER_STATUS_ID
,      L1_STATUS_CODE
,      L1_STATUS_DATE
,      L1_VENDOR_ID
,      L1_VENDOR_FK
,      L1_VENDOR_FK_KEY
,      L1_TRANSACTIONAL_COST
,      L1_TRANSACTIONAL_CURRENCY_CODE
,      L1_FUNCTIONAL_COST
,      L1_FUNCTIONAL_CURRENCY_CODE
,      L1_PIN_ID
,      L1_ORG_ID
,      L1_SOURCE_SYSTEM
,      L1_KEYWORDS
,      L1_SOURCE_LIST_NAME
,      L1_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L1_LAST_UPDATE_DATE
,      L1_CREATION_DATE
,      SECURITY_GROUP_ID
,      ROW_ID1
,      ROW_ID2
,      OPERATION_CODE1
,      OPERATION_CODE2
FROM BIM.EDW_BIM_SRCLSTS_M_TEMP;

Dependencies

[top of page]

BIM.EDW_BIM_SRCLSTS_M_TEMP does not reference any database object

BIM.EDW_BIM_SRCLSTS_M_TEMP is referenced by following:

APPS

EDW_BIM_SRCLSTS_M_TEMP