[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
GMI.GMI_AUTO_ALLOCATION_BATCH does not reference any database object
GMI.GMI_AUTO_ALLOCATION_BATCH is referenced by following:
|
|
|