[Home] [Help] [Dependency Information]
Object Name: | POS_EXASN_LOTS |
---|---|
Object Type: | TABLE |
Owner: | POS |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00161480 | NORMAL | UNIQUE | LOT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
POS.POS_EXASN_LOTS does not reference any database object
POS.POS_EXASN_LOTS is referenced by following:
|
|
|