WSH_LICENSE_PLATE_NUMBERS_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name

LPN_HISTORY_ID LPN_ID PARENT_LPN_ID OUTERMOST_LPN_ID LPN_CONTEXT LICENSE_PLATE_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID SUBINVENTORY_CODE LOCATOR_ID LOT_NUMBER SERIAL_NUMBER REVISION STATUS_ID GROSS_WEIGHT_UOM_CODE GROSS_WEIGHT CONTENT_VOLUME_UOM_CODE CONTENT_VOLUME TARE_WEIGHT_UOM_CODE TARE_WEIGHT CONTAINER_VOLUME CONTAINER_VOLUME_UOM SOLD_TO_PARTY_ID SHIP_TO_PARTY_ID SHIP_FROM_LOCATION_ID SHIP_TO_LOCATION_ID FREIGHT_TERMS_CODE FOB_CODE CARRIER_ID SERVICE_LEVEL MODE_OF_TRANSPORT SHIP_METHOD_CODE SHIPPING_INSTRUCTIONS PACKING_INSTRUCTIONS MASTER_SERIAL_NUMBER EARLIEST_PICKUP_DATE LATEST_PICKUP_DATE EARLIEST_DROPOFF_DATE LATEST_DROPOFF_DATE WV_FROZEN_FLAG FILL_PERCENT FILLED_VOLUME DELIVERY_ID TRACKING_NUMBER BATCH_ID OUTSOURCER_PARTY_ID NET_WEIGHT NET_WEIGHT_UOM_CODE MAXIMUM_LOAD_WEIGHT MAXIMUM_VOLUME MINIMUM_FILL_PERCENT CONTAINER_TYPE_CODE UNIT_WEIGHT UNIT_VOLUME SEAL_CODE SOURCE_LINE_TYPE SHIP_TO_LOCATION_TYPE TP_SHIPMENT_NUMBER SOURCE_TYPE_ID SOURCE_HEADER_ID SOURCE_LINE_ID SOURCE_LINE_DETAIL_ID SOURCE_NAME SEALED_STATUS LPN_REUSABILITY HOMOGENEOUS_CONTAINER LOAD_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT LPN_ID LPN_HISTORY_ID ,LPN_ID ,PARENT_LPN_ID ,OUTERMOST_LPN_ID ,LPN_CONTEXT ,LICENSE_PLATE_NUMBER ,INVENTORY_ITEM_ID ,ORGANIZATION_ID ,SUBINVENTORY_CODE ,LOCATOR_ID ,LOT_NUMBER ,SERIAL_NUMBER ,REVISION ,STATUS_ID ,GROSS_WEIGHT_UOM_CODE ,GROSS_WEIGHT ,CONTENT_VOLUME_UOM_CODE ,CONTENT_VOLUME ,TARE_WEIGHT_UOM_CODE ,TARE_WEIGHT ,CONTAINER_VOLUME ,CONTAINER_VOLUME_UOM ,SOLD_TO_PARTY_ID ,SHIP_TO_PARTY_ID ,SHIP_FROM_LOCATION_ID ,SHIP_TO_LOCATION_ID ,FREIGHT_TERMS_CODE ,FOB_CODE ,CARRIER_ID ,SERVICE_LEVEL ,MODE_OF_TRANSPORT ,SHIP_METHOD_CODE ,SHIPPING_INSTRUCTIONS ,PACKING_INSTRUCTIONS ,MASTER_SERIAL_NUMBER ,EARLIEST_PICKUP_DATE ,LATEST_PICKUP_DATE ,EARLIEST_DROPOFF_DATE ,LATEST_DROPOFF_DATE ,WV_FROZEN_FLAG ,FILL_PERCENT ,FILLED_VOLUME ,DELIVERY_ID ,TRACKING_NUMBER ,BATCH_ID ,OUTSOURCER_PARTY_ID ,NET_WEIGHT ,NET_WEIGHT_UOM_CODE ,MAXIMUM_LOAD_WEIGHT ,MAXIMUM_VOLUME ,MINIMUM_FILL_PERCENT ,CONTAINER_TYPE_CODE ,UNIT_WEIGHT ,UNIT_VOLUME ,SEAL_CODE ,SOURCE_LINE_TYPE ,SHIP_TO_LOCATION_TYPE ,TP_SHIPMENT_NUMBER ,SOURCE_TYPE_ID ,SOURCE_HEADER_ID ,SOURCE_LINE_ID ,SOURCE_LINE_DETAIL_ID ,SOURCE_NAME ,SEALED_STATUS ,LPN_REUSABILITY ,HOMOGENEOUS_CONTAINER ,LOAD_ID ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,OBJECT_VERSION_NUMBER ,REQUEST_ID ,JOB_DEFINITION_NAME ,JOB_DEFINITION_PACKAGE ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,ATTRIBUTE_NUMBER1 ,ATTRIBUTE_NUMBER2 ,ATTRIBUTE_NUMBER3 ,ATTRIBUTE_NUMBER4 ,ATTRIBUTE_NUMBER5 ,ATTRIBUTE_NUMBER6 ,ATTRIBUTE_NUMBER7 ,ATTRIBUTE_NUMBER8 ,ATTRIBUTE_NUMBER9 ,ATTRIBUTE_NUMBER10 ,ATTRIBUTE_DATE1 ,ATTRIBUTE_DATE2 ,ATTRIBUTE_DATE3 ,ATTRIBUTE_DATE4 ,ATTRIBUTE_DATE5 ,ATTRIBUTE_TIMESTAMP1 ,ATTRIBUTE_TIMESTAMP2 ,ATTRIBUTE_TIMESTAMP3 ,ATTRIBUTE_TIMESTAMP4 ,ATTRIBUTE_TIMESTAMP5 FROM inv_license_plate_numbers UNION ALL SELECT LPN_HISTORY_ID ,LPN_ID ,PARENT_LPN_ID ,OUTERMOST_LPN_ID ,LPN_CONTEXT ,LICENSE_PLATE_NUMBER ,INVENTORY_ITEM_ID ,ORGANIZATION_ID ,SUBINVENTORY_CODE ,LOCATOR_ID ,LOT_NUMBER ,SERIAL_NUMBER ,REVISION ,STATUS_ID ,GROSS_WEIGHT_UOM_CODE ,GROSS_WEIGHT ,CONTENT_VOLUME_UOM_CODE ,CONTENT_VOLUME ,TARE_WEIGHT_UOM_CODE ,TARE_WEIGHT ,CONTAINER_VOLUME ,CONTAINER_VOLUME_UOM ,SOLD_TO_PARTY_ID ,SHIP_TO_PARTY_ID ,SHIP_FROM_LOCATION_ID ,SHIP_TO_LOCATION_ID ,FREIGHT_TERMS_CODE ,FOB_CODE ,CARRIER_ID ,SERVICE_LEVEL ,MODE_OF_TRANSPORT ,SHIP_METHOD_CODE ,SHIPPING_INSTRUCTIONS ,PACKING_INSTRUCTIONS ,MASTER_SERIAL_NUMBER ,EARLIEST_PICKUP_DATE ,LATEST_PICKUP_DATE ,EARLIEST_DROPOFF_DATE ,LATEST_DROPOFF_DATE ,WV_FROZEN_FLAG ,FILL_PERCENT ,FILLED_VOLUME ,DELIVERY_ID ,TRACKING_NUMBER ,BATCH_ID ,OUTSOURCER_PARTY_ID ,NET_WEIGHT ,NET_WEIGHT_UOM_CODE ,MAXIMUM_LOAD_WEIGHT ,MAXIMUM_VOLUME ,MINIMUM_FILL_PERCENT ,CONTAINER_TYPE_CODE ,UNIT_WEIGHT ,UNIT_VOLUME ,SEAL_CODE ,SOURCE_LINE_TYPE ,SHIP_TO_LOCATION_TYPE ,TP_SHIPMENT_NUMBER ,SOURCE_TYPE_ID ,SOURCE_HEADER_ID ,SOURCE_LINE_ID ,SOURCE_LINE_DETAIL_ID ,SOURCE_NAME ,SEALED_STATUS ,LPN_REUSABILITY ,HOMOGENEOUS_CONTAINER ,LOAD_ID ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,OBJECT_VERSION_NUMBER ,REQUEST_ID ,JOB_DEFINITION_NAME ,JOB_DEFINITION_PACKAGE ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,ATTRIBUTE_NUMBER1 ,ATTRIBUTE_NUMBER2 ,ATTRIBUTE_NUMBER3 ,ATTRIBUTE_NUMBER4 ,ATTRIBUTE_NUMBER5 ,ATTRIBUTE_NUMBER6 ,ATTRIBUTE_NUMBER7 ,ATTRIBUTE_NUMBER8 ,ATTRIBUTE_NUMBER9 ,ATTRIBUTE_NUMBER10 ,ATTRIBUTE_DATE1 ,ATTRIBUTE_DATE2 ,ATTRIBUTE_DATE3 ,ATTRIBUTE_DATE4 ,ATTRIBUTE_DATE5 ,ATTRIBUTE_TIMESTAMP1 ,ATTRIBUTE_TIMESTAMP2 ,ATTRIBUTE_TIMESTAMP3 ,ATTRIBUTE_TIMESTAMP4 ,ATTRIBUTE_TIMESTAMP5 FROM inv_lpn_history WHERE delivery_id IS NOT NULL