VIEW: OE.WSH_DELIVERIES_INTERFACE#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, REQUEST_ID REQUEST_ID, DELIVERY_ID DELIVERY_ID, DELIVERY_NAME DELIVERY_NAME, DEPARTURE_ID DEPARTURE_ID, DEPARTURE_NAME DEPARTURE_NAME, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOADING_ORDER_FLAG LOADING_ORDER_FLAG, LOADING_ORDER_DESC LOADING_ORDER_DESC, REPORT_SET_ID REPORT_SET_ID, REPORT_SET REPORT_SET, DATE_CLOSED DATE_CLOSED, SEQUENCE_NUMBER SEQUENCE_NUMBER, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NUMBER CUSTOMER_NUMBER, ULTIMATE_SHIP_TO_ID ULTIMATE_SHIP_TO_ID, INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID, POOLED_SHIP_TO_ID POOLED_SHIP_TO_ID, WAYBILL_NUM WAYBILL_NUM, GROSS_WEIGHT GROSS_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, WEIGHT_UNIT_OF_MEASURE WEIGHT_UNIT_OF_MEASURE, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, VOLUME_UNIT_OF_MEASURE VOLUME_UNIT_OF_MEASURE, PICKED_BY_ID PICKED_BY_ID, PICKED_BY_NAME PICKED_BY_NAME, PACKED_BY_ID PACKED_BY_ID, PACKED_BY_NAME PACKED_BY_NAME, EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, CURRENCY_CODE CURRENCY_CODE, CURRENCY_NAME CURRENCY_NAME, FOB_CODE FOB_CODE, PROCESS_FLAG PROCESS_FLAG, ERROR_EXPLANATION ERROR_EXPLANATION, ERROR_CODE ERROR_CODE, ACTION_CODE ACTION_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, BILL_OF_LADING BILL_OF_LADING, SEAL_CODE SEAL_CODE, VEHICLE_ITEM_ID VEHICLE_ITEM_ID, VEHICLE_NUMBER VEHICLE_NUMBER, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS, ACTUAL_DEPARTURE_DATE ACTUAL_DEPARTURE_DATE, VEHICLE_SEGMENT1 VEHICLE_SEGMENT1, VEHICLE_SEGMENT2 VEHICLE_SEGMENT2, VEHICLE_SEGMENT3 VEHICLE_SEGMENT3, VEHICLE_SEGMENT4 VEHICLE_SEGMENT4, VEHICLE_SEGMENT5 VEHICLE_SEGMENT5, VEHICLE_SEGMENT6 VEHICLE_SEGMENT6, VEHICLE_SEGMENT7 VEHICLE_SEGMENT7, VEHICLE_SEGMENT8 VEHICLE_SEGMENT8, VEHICLE_SEGMENT9 VEHICLE_SEGMENT9, VEHICLE_SEGMENT10 VEHICLE_SEGMENT10, VEHICLE_SEGMENT11 VEHICLE_SEGMENT11, VEHICLE_SEGMENT12 VEHICLE_SEGMENT12, VEHICLE_SEGMENT13 VEHICLE_SEGMENT13, VEHICLE_SEGMENT14 VEHICLE_SEGMENT14, VEHICLE_SEGMENT15 VEHICLE_SEGMENT15, VEHICLE_SEGMENT16 VEHICLE_SEGMENT16, VEHICLE_SEGMENT17 VEHICLE_SEGMENT17, VEHICLE_SEGMENT18 VEHICLE_SEGMENT18, VEHICLE_SEGMENT19 VEHICLE_SEGMENT19, VEHICLE_SEGMENT20 VEHICLE_SEGMENT20, VEHICLE_ITEM VEHICLE_ITEM from "OE"."WSH_DELIVERIES_INTERFACE"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, REQUEST_ID REQUEST_ID
, DELIVERY_ID DELIVERY_ID
, DELIVERY_NAME DELIVERY_NAME
, DEPARTURE_ID DEPARTURE_ID
, DEPARTURE_NAME DEPARTURE_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOADING_ORDER_FLAG LOADING_ORDER_FLAG
, LOADING_ORDER_DESC LOADING_ORDER_DESC
, REPORT_SET_ID REPORT_SET_ID
, REPORT_SET REPORT_SET
, DATE_CLOSED DATE_CLOSED
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, ULTIMATE_SHIP_TO_ID ULTIMATE_SHIP_TO_ID
, INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID
, POOLED_SHIP_TO_ID POOLED_SHIP_TO_ID
, WAYBILL_NUM WAYBILL_NUM
, GROSS_WEIGHT GROSS_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, WEIGHT_UNIT_OF_MEASURE WEIGHT_UNIT_OF_MEASURE
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, VOLUME_UNIT_OF_MEASURE VOLUME_UNIT_OF_MEASURE
, PICKED_BY_ID PICKED_BY_ID
, PICKED_BY_NAME PICKED_BY_NAME
, PACKED_BY_ID PACKED_BY_ID
, PACKED_BY_NAME PACKED_BY_NAME
, EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_NAME CURRENCY_NAME
, FOB_CODE FOB_CODE
, PROCESS_FLAG PROCESS_FLAG
, ERROR_EXPLANATION ERROR_EXPLANATION
, ERROR_CODE ERROR_CODE
, ACTION_CODE ACTION_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, BILL_OF_LADING BILL_OF_LADING
, SEAL_CODE SEAL_CODE
, VEHICLE_ITEM_ID VEHICLE_ITEM_ID
, VEHICLE_NUMBER VEHICLE_NUMBER
, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS
, ACTUAL_DEPARTURE_DATE ACTUAL_DEPARTURE_DATE
, VEHICLE_SEGMENT1 VEHICLE_SEGMENT1
, VEHICLE_SEGMENT2 VEHICLE_SEGMENT2
, VEHICLE_SEGMENT3 VEHICLE_SEGMENT3
, VEHICLE_SEGMENT4 VEHICLE_SEGMENT4
, VEHICLE_SEGMENT5 VEHICLE_SEGMENT5
, VEHICLE_SEGMENT6 VEHICLE_SEGMENT6
, VEHICLE_SEGMENT7 VEHICLE_SEGMENT7
, VEHICLE_SEGMENT8 VEHICLE_SEGMENT8
, VEHICLE_SEGMENT9 VEHICLE_SEGMENT9
, VEHICLE_SEGMENT10 VEHICLE_SEGMENT10
, VEHICLE_SEGMENT11 VEHICLE_SEGMENT11
, VEHICLE_SEGMENT12 VEHICLE_SEGMENT12
, VEHICLE_SEGMENT13 VEHICLE_SEGMENT13
, VEHICLE_SEGMENT14 VEHICLE_SEGMENT14
, VEHICLE_SEGMENT15 VEHICLE_SEGMENT15
, VEHICLE_SEGMENT16 VEHICLE_SEGMENT16
, VEHICLE_SEGMENT17 VEHICLE_SEGMENT17
, VEHICLE_SEGMENT18 VEHICLE_SEGMENT18
, VEHICLE_SEGMENT19 VEHICLE_SEGMENT19
, VEHICLE_SEGMENT20 VEHICLE_SEGMENT20
, VEHICLE_ITEM VEHICLE_ITEM
FROM "OE"."WSH_DELIVERIES_INTERFACE"