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: POS.POS_EXASN_SERIALS

Object Details

Object Name:	POS_EXASN_SERIALS
Object Type:	TABLE
Owner:	POS
Subobject Name:
Status:	VALID

Temporary Table Details

POS.POS_EXASN_SERIALS 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	Mandatory
PO_LINE_LOC_ID	NUMBER
LOT_NUMBER	VARCHAR2	(60)
TRANSACTION_INTERFACE_ID	NUMBER
PRODUCT_TRANSACTION_ID	NUMBER
HEADER_ID	NUMBER
LINE_ID	NUMBER
LOT_ID	NUMBER
SERIAL_ID	NUMBER		Yes
FROM_SERIAL	VARCHAR2	(60)
TO_SERIAL	VARCHAR2	(60)
LICENSE_PLATE_NUMBER	VARCHAR2	(60)
QUANTITY	NUMBER
LINE_NUMBER	NUMBER
SERIAL_ATTRIBUTE_CATEGORY	VARCHAR2	(60)
CATTRIBUTE1	VARCHAR2	(2000)
CATTRIBUTE2	VARCHAR2	(2000)
CATTRIBUTE3	VARCHAR2	(2000)
CATTRIBUTE4	VARCHAR2	(2000)
CATTRIBUTE5	VARCHAR2	(2000)
CATTRIBUTE6	VARCHAR2	(2000)
CATTRIBUTE7	VARCHAR2	(2000)
CATTRIBUTE8	VARCHAR2	(2000)
CATTRIBUTE9	VARCHAR2	(2000)
CATTRIBUTE10	VARCHAR2	(2000)
CATTRIBUTE11	VARCHAR2	(2000)
CATTRIBUTE12	VARCHAR2	(2000)
CATTRIBUTE13	VARCHAR2	(2000)
CATTRIBUTE14	VARCHAR2	(2000)
CATTRIBUTE15	VARCHAR2	(2000)
CATTRIBUTE16	VARCHAR2	(2000)
CATTRIBUTE17	VARCHAR2	(2000)
CATTRIBUTE18	VARCHAR2	(2000)
CATTRIBUTE19	VARCHAR2	(2000)
CATTRIBUTE20	VARCHAR2	(2000)
DATTRIBUTE1	DATE
DATTRIBUTE2	DATE
DATTRIBUTE3	DATE
DATTRIBUTE4	DATE
DATTRIBUTE5	DATE
DATTRIBUTE6	DATE
DATTRIBUTE7	DATE
DATTRIBUTE8	DATE
DATTRIBUTE9	DATE
DATTRIBUTE10	DATE
NATTRIBUTE1	NUMBER
NATTRIBUTE2	NUMBER
NATTRIBUTE3	NUMBER
NATTRIBUTE4	NUMBER
NATTRIBUTE5	NUMBER
NATTRIBUTE6	NUMBER
NATTRIBUTE7	NUMBER
NATTRIBUTE8	NUMBER
NATTRIBUTE9	NUMBER
NATTRIBUTE10	NUMBER
STATUS_ID	NUMBER
TERRITORY_CODE	VARCHAR2	(30)
ORIGINATION_DATE	DATE

Query Text

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


SELECT PO_LINE_LOC_ID
,      LOT_NUMBER
,      TRANSACTION_INTERFACE_ID
,      PRODUCT_TRANSACTION_ID
,      HEADER_ID
,      LINE_ID
,      LOT_ID
,      SERIAL_ID
,      FROM_SERIAL
,      TO_SERIAL
,      LICENSE_PLATE_NUMBER
,      QUANTITY
,      LINE_NUMBER
,      SERIAL_ATTRIBUTE_CATEGORY
,      CATTRIBUTE1
,      CATTRIBUTE2
,      CATTRIBUTE3
,      CATTRIBUTE4
,      CATTRIBUTE5
,      CATTRIBUTE6
,      CATTRIBUTE7
,      CATTRIBUTE8
,      CATTRIBUTE9
,      CATTRIBUTE10
,      CATTRIBUTE11
,      CATTRIBUTE12
,      CATTRIBUTE13
,      CATTRIBUTE14
,      CATTRIBUTE15
,      CATTRIBUTE16
,      CATTRIBUTE17
,      CATTRIBUTE18
,      CATTRIBUTE19
,      CATTRIBUTE20
,      DATTRIBUTE1
,      DATTRIBUTE2
,      DATTRIBUTE3
,      DATTRIBUTE4
,      DATTRIBUTE5
,      DATTRIBUTE6
,      DATTRIBUTE7
,      DATTRIBUTE8
,      DATTRIBUTE9
,      DATTRIBUTE10
,      NATTRIBUTE1
,      NATTRIBUTE2
,      NATTRIBUTE3
,      NATTRIBUTE4
,      NATTRIBUTE5
,      NATTRIBUTE6
,      NATTRIBUTE7
,      NATTRIBUTE8
,      NATTRIBUTE9
,      NATTRIBUTE10
,      STATUS_ID
,      TERRITORY_CODE
,      ORIGINATION_DATE
FROM POS.POS_EXASN_SERIALS;

Dependencies

[top of page]

POS.POS_EXASN_SERIALS does not reference any database object

POS.POS_EXASN_SERIALS is referenced by following:

APPS: POS_EXASN_SERIALS