View: MTL_ONHAND_DUMMY_V

Product:	INV - Inventory
Description:	The view is used to show the data on material workbench form.
Implementation/DBA Data:	APPS.MTL_ONHAND_DUMMY_V

View Text

SELECT TO_NUMBER (NULL) ORGANIZATION_ID
, TO_CHAR (NULL) ORGANIZATION_CODE
, TO_CHAR (NULL) SUBINVENTORY_CODE
, TO_NUMBER (NULL) LOCATOR_ID
, TO_CHAR (NULL) LOCATOR
, TO_NUMBER (NULL) INVENTORY_ITEM_ID
, TO_CHAR (NULL)ITEM_DESCRIPTION
, TO_CHAR (NULL) ITEM
, TO_CHAR (NULL) REVISION
, TO_CHAR (NULL) UOM
, TO_NUMBER (NULL) ON_HAND
, TO_NUMBER (NULL) UNPACKED
, TO_NUMBER (NULL) PACKED
, TO_NUMBER (NULL) COST_GROUP_ID
, TO_NUMBER (NULL) LPN_ID
, TO_CHAR (NULL) LPN
, TO_NUMBER (NULL) PARENT_LPN_ID
, TO_NUMBER (NULL) LPN_CONTEXT
, TO_CHAR (NULL) LOT_NUMBER
, TO_CHAR (NULL)SERIAL_NUMBER
, TO_CHAR (NULL) UNIT_NUMBER
, TO_NUMBER (NULL) PROJECT_ID
, TO_NUMBER (NULL) TASK_ID
, TO_NUMBER (NULL) PLANNING_ORGANIZATION_ID
, TO_NUMBER (NULL) PLANNING_TP_TYPE
, TO_NUMBER (NULL) OWNING_ORGANIZATION_ID
, TO_NUMBER (NULL) OWNING_TP_TYPE
, TO_NUMBER (NULL) SUBINVENTORY_STATUS_ID
, TO_NUMBER (NULL) LOCATOR_STATUS_ID
, TO_NUMBER (NULL) LOT_STATUS_ID
, TO_NUMBER (NULL) SERIAL_STATUS_ID
, TO_NUMBER (NULL) ITEM_LOT_CONTROL
, TO_NUMBER (NULL) ITEM_SERIAL_CONTROL /* INVCONV START RNRAO */
, TO_NUMBER (NULL) SECONDARY_ONHAND
, TO_CHAR (NULL) SECONDARY_UOM_CODE
, TO_CHAR (NULL) GRADE_CODE
, TO_NUMBER (NULL) SECONDARY_PACKED
, TO_NUMBER (NULL) SECONDARY_UNPACKED /* INVCONV END RNRAO */
FROM DUAL

Columns