[Home] [Help] [Dependency Information]

TABLE: ENG.ENG_REVISED_ITEMS_TEMP

Object Details

Object Name:	ENG_REVISED_ITEMS_TEMP
Object Type:	TABLE
Owner:	ENG
FND Design Data:	ENG.ENG_REVISED_ITEMS_TEMP
Subobject Name:
Status:	VALID

Temporary Table Details

ENG.ENG_REVISED_ITEMS_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 TEMP_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      TRANSFER_OR_COPY_ITEM
,      TRANSFER_OR_COPY_BILL
,      TRANSFER_OR_COPY_ROUTING
,      NEW_ITEM_REVISION
,      NEW_ROUTING_REVISION
,      DESIGNATOR_SELECTION_TYPE
,      ALTERNATE_BOM_DESIGNATOR
,      CHANGE_NOTICE
,      COPY_TO_ITEM
,      COPY_TO_ITEM_DESC
,      TRANSFER_OR_COPY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM ENG.ENG_REVISED_ITEMS_TEMP;

Dependencies

[top of page]

ENG.ENG_REVISED_ITEMS_TEMP does not reference any database object

ENG.ENG_REVISED_ITEMS_TEMP is referenced by following:

APPS

ENG_REVISED_ITEMS_TEMP