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