[Home] [Help] [Dependency Information]
Object Name: | GML_BATCH_TMP# |
---|---|
Object Type: | VIEW |
Owner: | GML |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | (15) | ||
LINE_ID | NUMBER | (15) | ||
DOC_ID | NUMBER | (15) | ||
ITEM_ID | NUMBER | (15) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
BATCH_RES_ID | NUMBER | (15) | ||
BATCH_NO | VARCHAR2 | (40) | ||
BATCH_ID | NUMBER | (15) | ||
BATCH_LINE_ID | NUMBER | (15) | ||
BATCH_TYPE | NUMBER | (15) | ||
BATCH_STATUS | NUMBER | (15) | ||
START_DATE | DATE | |||
PLAN_CMPLT_DATE | DATE | |||
PLANNED_QTY | NUMBER | |||
PLANNED_QTY2 | NUMBER | |||
RESERVED_QTY | NUMBER | |||
RESERVED_QTY2 | NUMBER | |||
LINE_RESERVED_QTY | NUMBER | |||
LINE_RESERVED_QTY2 | NUMBER | |||
DELIVERY_DETAIL_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, LINE_ID
, DOC_ID
, ITEM_ID
, WHSE_CODE
, BATCH_RES_ID
, BATCH_NO
, BATCH_ID
, BATCH_LINE_ID
, BATCH_TYPE
, BATCH_STATUS
, START_DATE
, PLAN_CMPLT_DATE
, PLANNED_QTY
, PLANNED_QTY2
, RESERVED_QTY
, RESERVED_QTY2
, LINE_RESERVED_QTY
, LINE_RESERVED_QTY2
, DELIVERY_DETAIL_ID
FROM GML.GML_BATCH_TMP#;
|
|
|