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

VIEW: GML.GML_BATCH_SO_RESERVATIONS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_RES_ID NUMBER (15) Yes
BATCH_ID NUMBER (10) Yes
ORDER_ID NUMBER
Yes
BATCH_LINE_ID NUMBER
Yes
SO_LINE_ID NUMBER
Yes
DELIVERY_DETAIL_ID NUMBER (15)
MO_LINE_ID NUMBER (15)
ITEM_ID NUMBER (15)
RESERVED_QTY NUMBER

RESERVED_QTY2 NUMBER

QTY_UOM VARCHAR2 (5)
QTY2_UOM VARCHAR2 (5)
WHSE_CODE VARCHAR2 (5)
BATCH_TYPE NUMBER

DELETE_MARK NUMBER (5)
ALLOCATED_IND NUMBER (5)
ORGANIZATION_ID NUMBER (15)
RULE_ID NUMBER (15)
FULFILLED_QTY NUMBER

FULFILLED_QTY2 NUMBER

FULFILLMENT_DATE DATE

SCHEDULED_SHIP_DATE DATE

SHIPMENT_PRIORITY VARCHAR2 (30)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER (15)
Query Text

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


SELECT BATCH_RES_ID
,      BATCH_ID
,      ORDER_ID
,      BATCH_LINE_ID
,      SO_LINE_ID
,      DELIVERY_DETAIL_ID
,      MO_LINE_ID
,      ITEM_ID
,      RESERVED_QTY
,      RESERVED_QTY2
,      QTY_UOM
,      QTY2_UOM
,      WHSE_CODE
,      BATCH_TYPE
,      DELETE_MARK
,      ALLOCATED_IND
,      ORGANIZATION_ID
,      RULE_ID
,      FULFILLED_QTY
,      FULFILLED_QTY2
,      FULFILLMENT_DATE
,      SCHEDULED_SHIP_DATE
,      SHIPMENT_PRIORITY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
FROM GML.GML_BATCH_SO_RESERVATIONS#;

Dependencies

[top of page]

GML.GML_BATCH_SO_RESERVATIONS# references the following:

SchemaGML
TableGML_BATCH_SO_RESERVATIONS
GML.GML_BATCH_SO_RESERVATIONS# is referenced by following:

SchemaAPPS
SynonymGML_BATCH_SO_RESERVATIONS