[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMI_PICK_LOTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GMI.GMI_PICK_LOTS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View to populate pick lots screen from shipment form
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SESSION_ID | NUMBER | Users session id | ||
| TRANS_ID | NUMBER | (10) | Transaction id for the reservation | |
| ITEM_ID | NUMBER | (10) | Item id on the order line | |
| WHSE_CODE | VARCHAR2 | (4) | Warehouse code where inventory exists | |
| LINE_ID | NUMBER | (10) | Maximum of Order line id | |
| LINE_DETAIL_ID | NUMBER | (10) | Line Detail ID for the reservation | |
| LOT_NO | VARCHAR2 | (32) | Lot number with available inventory | |
| SUBLOT_NO | VARCHAR2 | (32) | Sublot Number with available inventory | |
| LOT_ID | NUMBER | (10) | Lot id for the Lot/Sublot combination | |
| LOT_CREATED | DATE | Lot creation date | ||
| EXPIRE_DATE | DATE | Lot expiration date | ||
| QC_GRADE | VARCHAR2 | (4) | QC grade of lot/sublot | |
| LOCATION | VARCHAR2 | (16) | Location within the warehouse where inventory exists | |
| LOT_STATUS | VARCHAR2 | (4) | Code for the lot status. | |
| NETTABLE_IND | NUMBER | (5) | Indicates whether lots with this status are considered by MRP. 0=Lots are not considered by MRP, 1=Lots are considered by MRP. | |
| SHIPPING_IND | NUMBER | (5) | 0=Not available for shipping; 1=Available for shipping if nettable and not rejected. | |
| REJECTED_IND | NUMBER | (5) | 0=lot accepted; 1=lot rejected. | |
| ONHAND_QTY | NUMBER | Total Quantity of inventory onhand, in item_um1 | ||
| ONHAND_QTY2 | NUMBER | Total Quantity of inventory onhand, in item_um2 | ||
| CONFIRM_QTY | NUMBER | Total Committed quantity of inventory, in item_um1 for this lot/sublot | ||
| CONFIRM_QTY2 | NUMBER | Total Committed quantity of inventory, in item_um2 for this lot/sublot | ||
| AVAIL_QTY | NUMBER | Onhand Qty + Commit Qty in item_um1 | ||
| AVAIL_QTY2 | NUMBER | Onhand Qty2 + Commit Qty2 in item_um2 | ||
| QTY1 | NUMBER | Total Quantity of inventory allocated for this lot/sublot, in item_um1 | ||
| QTY2 | VARCHAR2 | (40) | Total Quantity of inventory allocated for this lot/sublot, in item_um2 | |
| NUMB_TRANS_LINE | NUMBER | Total Number of transactions for this lot/sublot | ||
| REASON_CODE | VARCHAR2 | (4) | Reason code saved in ic_tran_pnd | |
| VENDOR_LOT_NO | VARCHAR2 | (32) | Vendor Lot Number |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, TRANS_ID
, ITEM_ID
, WHSE_CODE
, LINE_ID
, LINE_DETAIL_ID
, LOT_NO
, SUBLOT_NO
, LOT_ID
, LOT_CREATED
, EXPIRE_DATE
, QC_GRADE
, LOCATION
, LOT_STATUS
, NETTABLE_IND
, SHIPPING_IND
, REJECTED_IND
, ONHAND_QTY
, ONHAND_QTY2
, CONFIRM_QTY
, CONFIRM_QTY2
, AVAIL_QTY
, AVAIL_QTY2
, QTY1
, QTY2
, NUMB_TRANS_LINE
, REASON_CODE
, VENDOR_LOT_NO
FROM APPS.GMI_PICK_LOTS_V;
APPS
GMI_TRAN_TMP
IC_LOCT_INV
IC_LOTS_STS
APPS.GMI_PICK_LOTS_V is not referenced by any database object
|
|
|
|