eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GML.GML_BATCH_SO_RESERVATIONS

Object Details

Object Name:	GML_BATCH_SO_RESERVATIONS
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.GML_BATCH_SO_RESERVATIONS
Subobject Name:
Status:	VALID

OM batch reservations

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_BATCH_SO_RESERVATIONS_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	BATCH_RES_ID
GML_BATCH_SO_RESERVATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SO_LINE_ID
GML_BATCH_SO_RESERVATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BATCH_LINE_ID
GML_BATCH_SO_RESERVATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_RES_ID	NUMBER	(15)	Yes	Primary Key
BATCH_ID	NUMBER	(10)	Yes	Reference to the batch header, gme_batch_header.batch_id
ORDER_ID	NUMBER		Yes	Reference to the order header, oe_order_headers_all.header_id
BATCH_LINE_ID	NUMBER		Yes	Reference to the batch detail line, gme_material_details.meterial_detail_id
SO_LINE_ID	NUMBER		Yes	Reference to the order detail line, oe_order_lines_all.line_id
DELIVERY_DETAIL_ID	NUMBER	(15)		Reference to the shipping detail line, wsh_delivery_details.delivery_detail_id
MO_LINE_ID	NUMBER	(15)		Reference to the move order detail line, ic_txn_request_lines.line_id
ITEM_ID	NUMBER	(15)		Identifier to the reserved item. Reference to ic_item_mst.item_id
RESERVED_QTY	NUMBER			Quantity reserved against the batch line, in primary UOM
RESERVED_QTY2	NUMBER			Quantity reserved against the batch line, in secondary UOM
QTY_UOM	VARCHAR2	(5)		Same as primary UOM
QTY2_UOM	VARCHAR2	(5)		Same as secondary UOM
WHSE_CODE	VARCHAR2	(5)		The warehouse identifier for the quantity reserved
BATCH_TYPE	NUMBER			Indicate the batch is FPO or a Batch. Same as gme_batch_header.batch_type
DELETE_MARK	NUMBER	(5)		Value of 1 indicating the record is marked as deleted, 0 meaning the record is active
ALLOCATED_IND	NUMBER	(5)		Value of 1 indicating allocation(s) has ben created from the record
ORGANIZATION_ID	NUMBER	(15)		mtl_organization_id for the whse code
RULE_ID	NUMBER	(15)		Rule that is used when the reservation is created
FULFILLED_QTY	NUMBER			Total allocated_qty for the record
FULFILLED_QTY2	NUMBER			Total allocated_qty
FULFILLMENT_DATE	DATE			fulfillment date
SCHEDULED_SHIP_DATE	DATE			scheduled ship date
SHIPMENT_PRIORITY	VARCHAR2	(30)		shipment priority
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Program application Id
PROGRAM_ID	NUMBER	(15)		Program ID

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 does not reference any database object

GML.GML_BATCH_SO_RESERVATIONS is referenced by following:

GML: GML_BATCH_SO_RESERVATIONS#