[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IC_SUMM_INV_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GMI.IC_SUMM_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.
GMI summary inventory view
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ITEM_ID | NUMBER | (10) | Surrogate key for the item | |
| WHSE_CODE | VARCHAR2 | (4) | Warehouse in which the inventory is located | |
| QC_GRADE | VARCHAR2 | (4) | Grade of the inventory. NULL value denotes that QC Grade does not apply to item | |
| ONHAND_QTY | NUMBER | Total nettable qty of this item/grade in this warehouse, expressed in the primary unit of measure of an item | ||
| ONHAND_QTY2 | NUMBER | Total nettable qty of this item/grade in this warehouse, expressed in the secondary unit of measure of an item, if dual UOM controlled | ||
| ONHAND_PROD_QTY | NUMBER | Total qty available for use as a production ingredient, expressed in the primary UOM of an item | ||
| ONHAND_PROD_QTY2 | NUMBER | Total qty available for use as a production ingredient, expressed in the secondary UOM of an item if dual UOM controlled | ||
| ONHAND_ORDER_QTY | NUMBER | Total qty available for ordering, expressed in the primary UOM of an item | ||
| ONHAND_ORDER_QTY2 | NUMBER | Total qty available for ordering, expressed in the secondary UOM of an item, if dual UOM controlled | ||
| ONHAND_SHIP_QTY | NUMBER | Total qty available for shipping, expressed in the primary UOM of an item | ||
| ONHAND_SHIP_QTY2 | NUMBER | Total qty available for shipping, expressed in the secondary UOM of an item, if dual UOM controlled | ||
| ONPURCH_QTY | NUMBER | Total qty pending from purchase orders, expressed in the primary UOM of an item | ||
| ONPURCH_QTY2 | NUMBER | Total qty pending from purchase orders, expressed in the secondary UOM of an item if dual UOM controlled | ||
| ONPROD_QTY | NUMBER | Total qty of product pending from production, expressed in the primary UOM of an item | ||
| ONPROD_QTY2 | NUMBER | Total qty of product pending from production, expressed in the secondary UOM of an item | ||
| COMMITTEDSALES_QTY | NUMBER | Total qty committed to sales orders and shipments, expressed in the primary UOM of an item | ||
| COMMITTEDSALES_QTY2 | NUMBER | Total qty committed to sales orders and shipments, expressed in the secondary UOM of an item if dual UOM controlled | ||
| COMMITTEDPROD_QTY | NUMBER | Total qty of ingredient committed to batches, expressed in the primary UOM of an item | ||
| COMMITTEDPROD_QTY2 | NUMBER | Total qty of ingredient committed to batches, expressed in the secondary UOM of an item if dual UOM controlled | ||
| INTRANSIT_QTY | NUMBER | Qty in transit | ||
| INTRANSIT_QTY2 | NUMBER | Qty in transit, expressed in the secondary UOM of an item if dual UOM controlled | ||
| SUMM_INV_ID | NUMBER | Primary Key for IC_SUMM_INV: column used only for backward compatibilty | ||
| LAST_UPDATED_BY | NUMBER | Standard who column | ||
| CREATED_BY | NUMBER | Standard who column | ||
| LAST_UPDATE_DATE | DATE | Standard who column | ||
| CREATION_DATE | DATE | Standard who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent who column | ||
| PROGRAM_ID | NUMBER | Concurrent who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
| REQUEST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, WHSE_CODE
, QC_GRADE
, ONHAND_QTY
, ONHAND_QTY2
, ONHAND_PROD_QTY
, ONHAND_PROD_QTY2
, ONHAND_ORDER_QTY
, ONHAND_ORDER_QTY2
, ONHAND_SHIP_QTY
, ONHAND_SHIP_QTY2
, ONPURCH_QTY
, ONPURCH_QTY2
, ONPROD_QTY
, ONPROD_QTY2
, COMMITTEDSALES_QTY
, COMMITTEDSALES_QTY2
, COMMITTEDPROD_QTY
, COMMITTEDPROD_QTY2
, INTRANSIT_QTY
, INTRANSIT_QTY2
, SUMM_INV_ID
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM APPS.IC_SUMM_INV_V;
APPS
IC_SUMM_INV_INT_V
APPS
IC_SUMM_INV
|
|
|
|