[Home] [Help] [Dependency Information]
Object Name: | QA_MQA_LOT_SERIAL_TEMP |
---|---|
Object Type: | TABLE |
Owner: | QA |
FND Design Data: | QA.QA_MQA_LOT_SERIAL_TEMP |
Subobject Name: | |
Status: | VALID |
Temporary table used in mobile application. Specifically, the lot/serial numbers
from the parent transaction are stored in this table for LOV selection query.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QA_MQA_LOT_SERIAL_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALUE | VARCHAR2 | (40) | Yes | The lot or serial number |
DESCRIPTION | VARCHAR2 | (50) | The lot or serial description | |
FLAG | NUMBER | Yes | A flag to indicate this is a lot or serial |
Cut, paste (and edit) the following text to query this object:
SELECT VALUE
, DESCRIPTION
, FLAG
FROM QA.QA_MQA_LOT_SERIAL_TEMP;
QA.QA_MQA_LOT_SERIAL_TEMP does not reference any database object
QA.QA_MQA_LOT_SERIAL_TEMP is referenced by following:
|
|
|