[Home] [Help] [Dependency Information]
Object Name: | IC_ITEM_INV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_ITEM_INV_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
This is used in the OPM Allocation Engine in order to get the OnHand and Commit quantities for an item.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | ||
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
LOT_ID | NUMBER | (10) | ||
LOT_STATUS | VARCHAR2 | (4) | ||
LOT_CREATED | DATE | |||
EXPIRE_DATE | DATE | |||
QC_GRADE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
LOCT_ONHAND | NUMBER | |||
LOCT_ONHAND2 | NUMBER | |||
COMMIT_QTY | NUMBER | |||
COMMIT_QTY2 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, LOT_NO
, SUBLOT_NO
, LOT_ID
, LOT_STATUS
, LOT_CREATED
, EXPIRE_DATE
, QC_GRADE
, WHSE_CODE
, LOCATION
, LOCT_ONHAND
, LOCT_ONHAND2
, COMMIT_QTY
, COMMIT_QTY2
FROM APPS.IC_ITEM_INV_V;
|
|
|