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_LOTS

Object Details

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

Temporary Table Details

POS.POS_EXASN_LOTS 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

Primary Key: SYS_C00161480

LOT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00161480	NORMAL	UNIQUE		LOT_ID

Columns

Name	Datatype	Length	Mandatory
UOM	VARCHAR2	(60)
TRANSACTION_INTERFACE_ID	NUMBER
SERIAL_TRANSACTION_TEMP_ID	NUMBER
PRODUCT_TRANSACTION_ID	NUMBER
PO_LINE_LOC_ID	NUMBER
HEADER_ID	NUMBER
LINE_ID	NUMBER
LOT_ID	NUMBER		Yes
LOT_NUMBER	VARCHAR2	(60)
LICENSE_PLATE_NUMBER	VARCHAR2	(60)
QUANTITY	NUMBER
LINE_NUMBER	NUMBER
LOT_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
VENDOR_ID	NUMBER
GRADE_CODE	VARCHAR2	(2000)
ORIGINATION_DATE	DATE
DATE_CODE	VARCHAR2	(2000)
STATUS_ID	NUMBER
CHANGE_DATE	DATE
AGE	NUMBER
RETEST_DATE	DATE
MATURITY_DATE	DATE
ITEM_SIZE	NUMBER
COLOR	VARCHAR2	(2000)
VOLUME	NUMBER
VOLUME_UOM	VARCHAR2	(60)
PLACE_OF_ORIGIN	VARCHAR2	(2000)
BEST_BY_DATE	DATE
LENGTH	NUMBER
LENGTH_UOM	VARCHAR2	(60)
RECYCLED_CONTENT	NUMBER
THICKNESS	NUMBER
THICKNESS_UOM	VARCHAR2	(60)
WIDTH	NUMBER
WIDTH_UOM	VARCHAR2	(60)
CURL_WRINKLE_FOLD	VARCHAR2	(2000)
SUPPLIER_LOT_NUMBER	VARCHAR2	(2000)
TERRITORY_CODE	VARCHAR2	(60)
VENDOR_NAME	VARCHAR2	(2000)

Query Text

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


SELECT UOM
,      TRANSACTION_INTERFACE_ID
,      SERIAL_TRANSACTION_TEMP_ID
,      PRODUCT_TRANSACTION_ID
,      PO_LINE_LOC_ID
,      HEADER_ID
,      LINE_ID
,      LOT_ID
,      LOT_NUMBER
,      LICENSE_PLATE_NUMBER
,      QUANTITY
,      LINE_NUMBER
,      LOT_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
,      VENDOR_ID
,      GRADE_CODE
,      ORIGINATION_DATE
,      DATE_CODE
,      STATUS_ID
,      CHANGE_DATE
,      AGE
,      RETEST_DATE
,      MATURITY_DATE
,      ITEM_SIZE
,      COLOR
,      VOLUME
,      VOLUME_UOM
,      PLACE_OF_ORIGIN
,      BEST_BY_DATE
,      LENGTH
,      LENGTH_UOM
,      RECYCLED_CONTENT
,      THICKNESS
,      THICKNESS_UOM
,      WIDTH
,      WIDTH_UOM
,      CURL_WRINKLE_FOLD
,      SUPPLIER_LOT_NUMBER
,      TERRITORY_CODE
,      VENDOR_NAME
FROM POS.POS_EXASN_LOTS;

Dependencies

[top of page]

POS.POS_EXASN_LOTS does not reference any database object

POS.POS_EXASN_LOTS is referenced by following:

APPS: POS_EXASN_LOTS