DBA Data[Home] [Help] [Dependency Information]

VIEW: GML.GML_BATCH_SO_ALLOC_HISTORY#

Object Details
Object Name: GML_BATCH_SO_ALLOC_HISTORY#
Object Type: VIEW
Owner: GML
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ALLOC_REC_ID NUMBER (15) Yes
BATCH_RES_ID NUMBER (15) Yes
BATCH_ID NUMBER (15) Yes
TRANS_ID NUMBER (15)
ORDER_NO NUMBER

BATCH_NO NUMBER

PLANT_CODE VARCHAR2 (4)
BATCH_TYPE NUMBER (5)
LINE_ID NUMBER (15) Yes
LOT_ID NUMBER (15)
LOCATION VARCHAR2 (32)
WHSE_CODE VARCHAR2 (5)
RULE_ID NUMBER (15)
RESERVED_QTY NUMBER

RESERVED_QTY2 NUMBER

ALLOC_QTY NUMBER

ALLOC_QTY2 NUMBER

TRANS_UM VARCHAR2 (5)
TRANS_UM2 VARCHAR2 (5)
FAILURE_REASON VARCHAR2 (3000)
BATCH_TRANS_ID NUMBER

BATCH_LINE_ID NUMBER

DELETE_MARK NUMBER (5)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_DATE DATE

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER (15)
LAST_UPDATED_BY NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ALLOC_REC_ID
,      BATCH_RES_ID
,      BATCH_ID
,      TRANS_ID
,      ORDER_NO
,      BATCH_NO
,      PLANT_CODE
,      BATCH_TYPE
,      LINE_ID
,      LOT_ID
,      LOCATION
,      WHSE_CODE
,      RULE_ID
,      RESERVED_QTY
,      RESERVED_QTY2
,      ALLOC_QTY
,      ALLOC_QTY2
,      TRANS_UM
,      TRANS_UM2
,      FAILURE_REASON
,      BATCH_TRANS_ID
,      BATCH_LINE_ID
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATED_BY
FROM GML.GML_BATCH_SO_ALLOC_HISTORY#;

Dependencies

[top of page]

GML.GML_BATCH_SO_ALLOC_HISTORY# references the following:

SchemaGML
TableGML_BATCH_SO_ALLOC_HISTORY
GML.GML_BATCH_SO_ALLOC_HISTORY# is referenced by following:

SchemaAPPS
SynonymGML_BATCH_SO_ALLOC_HISTORY