VIEW: WMS.WMS_ASN_DETAILS#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, SHIPMENT_NUM SHIPMENT_NUM, ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DISCREPANCY_REPORTING_CONTEXT DISCREPANCY_REPORTING_CONTEXT, ITEM_ID ITEM_ID, QUANTITY_EXPECTED QUANTITY_EXPECTED, QUANTITY_ACTUAL QUANTITY_ACTUAL, UNIT_OF_MEASURE_EXPECTED UNIT_OF_MEASURE_EXPECTED, UNIT_OF_MEASURE_ACTUAL UNIT_OF_MEASURE_ACTUAL, LPN_EXPECTED LPN_EXPECTED, LPN_ACTUAL LPN_ACTUAL, ITEM_REVISION_EXPECTED ITEM_REVISION_EXPECTED, ITEM_REVISION_ACTUAL ITEM_REVISION_ACTUAL, LOT_NUMBER_EXPECTED LOT_NUMBER_EXPECTED, LOT_NUMBER_ACTUAL LOT_NUMBER_ACTUAL, SERIAL_NUMBER_EXPECTED SERIAL_NUMBER_EXPECTED, SERIAL_NUMBER_ACTUAL SERIAL_NUMBER_ACTUAL, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, TRANSACTION_DATE TRANSACTION_DATE, DISCREPANCY_STATUS DISCREPANCY_STATUS from "WMS"."WMS_ASN_DETAILS"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, SHIPMENT_NUM SHIPMENT_NUM
, ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DISCREPANCY_REPORTING_CONTEXT DISCREPANCY_REPORTING_CONTEXT
, ITEM_ID ITEM_ID
, QUANTITY_EXPECTED QUANTITY_EXPECTED
, QUANTITY_ACTUAL QUANTITY_ACTUAL
, UNIT_OF_MEASURE_EXPECTED UNIT_OF_MEASURE_EXPECTED
, UNIT_OF_MEASURE_ACTUAL UNIT_OF_MEASURE_ACTUAL
, LPN_EXPECTED LPN_EXPECTED
, LPN_ACTUAL LPN_ACTUAL
, ITEM_REVISION_EXPECTED ITEM_REVISION_EXPECTED
, ITEM_REVISION_ACTUAL ITEM_REVISION_ACTUAL
, LOT_NUMBER_EXPECTED LOT_NUMBER_EXPECTED
, LOT_NUMBER_ACTUAL LOT_NUMBER_ACTUAL
, SERIAL_NUMBER_EXPECTED SERIAL_NUMBER_EXPECTED
, SERIAL_NUMBER_ACTUAL SERIAL_NUMBER_ACTUAL
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, TRANSACTION_DATE TRANSACTION_DATE
, DISCREPANCY_STATUS DISCREPANCY_STATUS
FROM "WMS"."WMS_ASN_DETAILS"