[Home] [Help] [Dependency Information]
Object Name: | OP_TRAN_TMP# |
---|---|
Object Type: | VIEW |
Owner: | GML |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | ||
LINE_ID | NUMBER | (10) | Yes | |
DOC_ID | NUMBER | (10) | Yes | |
ITEM_ID | NUMBER | (10) | Yes | |
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
LOT_ID | NUMBER | (10) | ||
LOT_CREATED | DATE | |||
EXPIRE_DATE | DATE | |||
QC_GRADE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | Yes | |
LOCATION | VARCHAR2 | (16) | ||
LOCT_ONHAND | NUMBER | |||
LOCT_ONHAND2 | NUMBER | |||
COMMIT_QTY | NUMBER | |||
COMMIT_QTY2 | NUMBER | |||
TRANS_ID | NUMBER | (10) | ||
ID_COUNT | NUMBER | (5) | ||
ALLOC_QTY | NUMBER | |||
ALLOC_QTY2 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, LINE_ID
, DOC_ID
, ITEM_ID
, LOT_NO
, SUBLOT_NO
, LOT_ID
, LOT_CREATED
, EXPIRE_DATE
, QC_GRADE
, WHSE_CODE
, LOCATION
, LOCT_ONHAND
, LOCT_ONHAND2
, COMMIT_QTY
, COMMIT_QTY2
, TRANS_ID
, ID_COUNT
, ALLOC_QTY
, ALLOC_QTY2
FROM GML.OP_TRAN_TMP#;
|
|
|