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: GMI.GMI_AUTO_ALLOCATION_BATCH

Object Details

Object Name:	GMI_AUTO_ALLOCATION_BATCH
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.GMI_AUTO_ALLOCATION_BATCH
Subobject Name:
Status:	VALID

Auto allocation batch parameter table

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	System generated identifier of pick batch
NAME	VARCHAR2	(30)		Unique batch name
FROM_ORDER_HEADER_NO	NUMBER			From Order Header Number
TO_ORDER_HEADER_NO	NUMBER			To Order header number
FROM_SCHED_SHIP_DATE	DATE			Scheduled ship date to search from
TO_SCHED_SHIP_DATE	DATE			To Order header identifier
FROM_LOT_NO	VARCHAR2	(30)		Lot number from
TO_LOT_NO	VARCHAR2	(30)		Lot number to
FROM_SUBLOT_NO	VARCHAR2	(30)		Sublot number from
TO_SUBLOT_NO	VARCHAR2	(30)		Sublot number to
ORDER_TYPE_ID	NUMBER			Order type id
FROM_EXPIRATION_DATE	DATE			Lot with starting expiration date to allocate
TO_EXPIRATION_DATE	DATE			Lot with ending expiration date to allocate
FROM_CREATION_DATE	DATE			Lot with starting creation date to allocate
TO_CREATION_DATE	DATE			Lot with ending creation date to allocate
LOCATION	VARCHAR2	(30)		Location to allocate
ITEM_ID	NUMBER			Item_id from ic_item_mst
WHSE_CODE	VARCHAR2	(4)		Warehouse to allocate from
LOT_STATUS	VARCHAR2	(8)		Lot with lot_status to allocate
FROM_DELIVERY_DETAIL_ID	NUMBER			From delivery detail identifier, refer to wsh_delivery_detail.delivery_detail_id
TO_DELIVERY_DETAIL_ID	NUMBER			To Delivery detail identifier, refer to wsh_delivery_detail.delivery_detail_id
PICK_CONFIRM_FLAG	VARCHAR2	(1)		Y or N
ALLOC_ALL_LOT_FLAG	VARCHAR2	(1)		Y or N
LOTS_INDIVISIBLE_FLAG	VARCHAR2	(1)		Y or N
OVERRIDE_RULES	VARCHAR2	(1)		Y or N, N meaning work with rules
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		attribute cagegory
ATTRIBUTE1	VARCHAR2	(150)		attribute1
ATTRIBUTE2	VARCHAR2	(150)		attribute2
ATTRIBUTE3	VARCHAR2	(150)		attribute3
ATTRIBUTE4	VARCHAR2	(150)		attribute4
ATTRIBUTE5	VARCHAR2	(150)		attribute5
ATTRIBUTE6	VARCHAR2	(150)		attribute6
ATTRIBUTE7	VARCHAR2	(150)		attribute7
ATTRIBUTE8	VARCHAR2	(150)		attribute8
ATTRIBUTE9	VARCHAR2	(150)		attribute9
ATTRIBUTE10	VARCHAR2	(150)		attribute10
ATTRIBUTE11	VARCHAR2	(150)		attribute11
ATTRIBUTE12	VARCHAR2	(150)		attribute12
ATTRIBUTE13	VARCHAR2	(150)		attribute13
ATTRIBUTE14	VARCHAR2	(150)		attribute14
ATTRIBUTE15	VARCHAR2	(150)		attribute15
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			application id
PROGRAM_ID	NUMBER			Standard program id
PROGRAM_UPDATE_DATE	DATE			program update date
DELETE_EXISTING_ALOC_FLAG	VARCHAR2	(1)		Value of Y means that the user wants to delete existing allocations for the line before allocate

Query Text

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


SELECT BATCH_ID
,      NAME
,      FROM_ORDER_HEADER_NO
,      TO_ORDER_HEADER_NO
,      FROM_SCHED_SHIP_DATE
,      TO_SCHED_SHIP_DATE
,      FROM_LOT_NO
,      TO_LOT_NO
,      FROM_SUBLOT_NO
,      TO_SUBLOT_NO
,      ORDER_TYPE_ID
,      FROM_EXPIRATION_DATE
,      TO_EXPIRATION_DATE
,      FROM_CREATION_DATE
,      TO_CREATION_DATE
,      LOCATION
,      ITEM_ID
,      WHSE_CODE
,      LOT_STATUS
,      FROM_DELIVERY_DETAIL_ID
,      TO_DELIVERY_DETAIL_ID
,      PICK_CONFIRM_FLAG
,      ALLOC_ALL_LOT_FLAG
,      LOTS_INDIVISIBLE_FLAG
,      OVERRIDE_RULES
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELETE_EXISTING_ALOC_FLAG
FROM GMI.GMI_AUTO_ALLOCATION_BATCH;

Dependencies

[top of page]

GMI.GMI_AUTO_ALLOCATION_BATCH does not reference any database object

GMI.GMI_AUTO_ALLOCATION_BATCH is referenced by following:

GMI: GMI_AUTO_ALLOCATION_BATCH#