[Home] [Help] [Dependency Information]
Object Name: | BOM_DIAG_TEMP_TAB |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.BOM_DIAG_TEMP_TAB does not reference any database object
APPS.BOM_DIAG_TEMP_TAB is referenced by following:
|
|
|