[Home] [Help] [Dependency Information]
Object Name: | GMI_TRAN_TMP# |
---|---|
Object Type: | VIEW |
Owner: | GMI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | |||
LINE_ID | NUMBER | (10) | ||
DOC_ID | NUMBER | (10) | ||
ITEM_ID | NUMBER | (10) | ||
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) | ||
LOCATION | VARCHAR2 | (16) | ||
LOCT_ONHAND | NUMBER | |||
LOCT_ONHAND2 | NUMBER | |||
COMMIT_QTY | NUMBER | |||
COMMIT_QTY2 | NUMBER | |||
TRANS_ID | NUMBER | (10) | ||
ID_COUNT | NUMBER | (10) | ||
ALLOC_QTY | NUMBER | |||
ALLOC_QTY2 | NUMBER | |||
LINE_DETAIL_ID | NUMBER | (10) | ||
REASON_CODE | VARCHAR2 | (4) | ||
VENDOR_LOT_NO | VARCHAR2 | (32) |
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
, LINE_DETAIL_ID
, REASON_CODE
, VENDOR_LOT_NO
FROM GMI.GMI_TRAN_TMP#;
|
|
|