[Home] [Help]
[Dependency Information]
[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 |
LOT_ID| 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:
APPS
POS_EXASN_LOTS
|
|
|
|