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: APPS.BOM_DIAG_TEMP_TAB

Object Details

Object Name:	BOM_DIAG_TEMP_TAB
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.BOM_DIAG_TEMP_TAB 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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
INVENTORY_ITEM_ID	NUMBER
ORGANIZATION_ID	NUMBER
DESCRIPTION	VARCHAR2	(240)
LONG_DESCRIPTION	VARCHAR2	(4000)
NUM_COL1	NUMBER
NUM_COL2	NUMBER
NUM_COL3	NUMBER
NUM_COL4	NUMBER
NUM_COL5	NUMBER
NUM_COL6	NUMBER
NUM_COL7	NUMBER
NUM_COL8	NUMBER
NUM_COL9	NUMBER
NUM_COL10	NUMBER
CHAR_COL1	VARCHAR2	(240)
CHAR_COL2	VARCHAR2	(240)
CHAR_COL3	VARCHAR2	(240)
CHAR_COL4	VARCHAR2	(240)
CHAR_COL5	VARCHAR2	(240)
CHAR_COL6	VARCHAR2	(240)
CHAR_COL7	VARCHAR2	(240)
CHAR_COL8	VARCHAR2	(240)
CHAR_COL9	VARCHAR2	(240)
CHAR_COL10	VARCHAR2	(240)
DATE_COL1	DATE
DATE_COL2	DATE
DATE_COL3	DATE
DATE_COL4	DATE
DATE_COL5	DATE
DATE_COL6	DATE
DATE_COL7	DATE
DATE_COL8	DATE
DATE_COL9	DATE
DATE_COL10	DATE

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      DESCRIPTION
,      LONG_DESCRIPTION
,      NUM_COL1
,      NUM_COL2
,      NUM_COL3
,      NUM_COL4
,      NUM_COL5
,      NUM_COL6
,      NUM_COL7
,      NUM_COL8
,      NUM_COL9
,      NUM_COL10
,      CHAR_COL1
,      CHAR_COL2
,      CHAR_COL3
,      CHAR_COL4
,      CHAR_COL5
,      CHAR_COL6
,      CHAR_COL7
,      CHAR_COL8
,      CHAR_COL9
,      CHAR_COL10
,      DATE_COL1
,      DATE_COL2
,      DATE_COL3
,      DATE_COL4
,      DATE_COL5
,      DATE_COL6
,      DATE_COL7
,      DATE_COL8
,      DATE_COL9
,      DATE_COL10
FROM APPS.BOM_DIAG_TEMP_TAB;

Dependencies

[top of page]

APPS.BOM_DIAG_TEMP_TAB does not reference any database object

APPS.BOM_DIAG_TEMP_TAB is referenced by following:

APPS: BOM_DIAGUNITTEST_ITMHLCHK - show dependent code; BOM_DIAGUNITTEST_TSDATA - show dependent code