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_TMP

Object Details

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

Temporary Table for Batch Reservations

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SESSION_ID	NUMBER	(15)	Database Session ID
LINE_ID	NUMBER	(15)	Sales Order Line ID
DOC_ID	NUMBER	(15)	Doc ID
ITEM_ID	NUMBER	(15)	Item ID From OPM Item Master
WHSE_CODE	VARCHAR2	(4)	OPM To Warehouse Code
BATCH_RES_ID	NUMBER	(15)	Reservation ID for reservation against Batch
BATCH_NO	VARCHAR2	(40)	Batch Number
BATCH_ID	NUMBER	(15)	Batch ID
BATCH_LINE_ID	NUMBER	(15)	Batch Line ID against which reservation is made
BATCH_TYPE	NUMBER	(15)	Batch Type to indicate whether a batch or Firm planned Order
BATCH_STATUS	NUMBER	(15)	Batch Status to indicate whether Pending , WIP, Completed
START_DATE	DATE		Planned Start date for batch line
PLAN_CMPLT_DATE	DATE		Planned Completion date for Batch line
PLANNED_QTY	NUMBER		Planned Quantity for batch line
PLANNED_QTY2	NUMBER		Secondary Planned Quantity for Batch line
RESERVED_QTY	NUMBER		Reserved Quantity for Order line
RESERVED_QTY2	NUMBER		Secondary Reserved Quantity for Order line
LINE_RESERVED_QTY	NUMBER		Reserved Quantity for Batch line
LINE_RESERVED_QTY2	NUMBER		Secondary Reserved Quantity for Batch line
DELIVERY_DETAIL_ID	NUMBER	(15)	Delivery Detail ID for the Order Line

Query Text

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;

Dependencies

[top of page]

GML.GML_BATCH_TMP does not reference any database object

GML.GML_BATCH_TMP is referenced by following:

GML: GML_BATCH_TMP#