[Home] [Help]
View: WMS_ZONE_LOCATORS_TEMP
Product: | WMS - Warehouse Management |
Description: | View built on temporary table wms_zone_locators_gtmp |
Implementation/DBA Data: |
APPS.WMS_ZONE_LOCATORS_TEMP
|
View Text
SELECT ROWID ROW_ID
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, INVENTORY_LOCATION_ID
, LOCATOR_NAME
, PICKING_ORDER
, DROPPING_ORDER
, SUBINVENTORY_TYPE
, INVENTORY_LOCATION_TYPE
, SUBINVENTORY_TYPE_MEANING
, LOCATOR_TYPE_MEANING
, SUBINVENTORY_STATUS
, LOCATOR_STATUS
, SUBINVENTORY_STATUS_CODE
, LOCATOR_STATUS_CODE
, LOCATOR_DISABLE_DATE
, MESSAGE
, MESSAGE_ID
FROM WMS_ZONE_LOCATORS_GTMP
Columns
Name |
ROW_ID |
ORGANIZATION_ID |
SUBINVENTORY_CODE |
INVENTORY_LOCATION_ID |
LOCATOR_NAME |
PICKING_ORDER |
DROPPING_ORDER |
SUBINVENTORY_TYPE |
INVENTORY_LOCATION_TYPE |
SUBINVENTORY_TYPE_MEANING |
LOCATOR_TYPE_MEANING |
SUBINVENTORY_STATUS |
LOCATOR_STATUS |
SUBINVENTORY_STATUS_CODE |
LOCATOR_STATUS_CODE |
LOCATOR_DISABLE_DATE |
MESSAGE |
MESSAGE_ID |