VIEW: APPS.MTL_ONHAND_DUMMY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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