VIEW: ASO.ASO_SHIPMENTS#

Source

View Text - Preformatted

select SHIPMENT_ID SHIPMENT_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, QUOTE_HEADER_ID QUOTE_HEADER_ID, QUOTE_LINE_ID QUOTE_LINE_ID, PROMISE_DATE PROMISE_DATE, REQUEST_DATE REQUEST_DATE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, SHIP_PARTIAL_FLAG SHIP_PARTIAL_FLAG, SHIP_SET_ID SHIP_SET_ID, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FOB_CODE FOB_CODE, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, QUANTITY QUANTITY, RESERVED_QUANTITY RESERVED_QUANTITY, RESERVATION_ID RESERVATION_ID, ORDER_LINE_ID ORDER_LINE_ID, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_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, SHIP_QUOTE_PRICE SHIP_QUOTE_PRICE, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SHIP_TO_CUST_ACCOUNT_ID SHIP_TO_CUST_ACCOUNT_ID, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_TO_CUST_PARTY_ID SHIP_TO_CUST_PARTY_ID, SHIP_METHOD_CODE_FROM SHIP_METHOD_CODE_FROM, FREIGHT_TERMS_CODE_FROM FREIGHT_TERMS_CODE_FROM, REQUEST_DATE_TYPE REQUEST_DATE_TYPE, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20 from "ASO"."ASO_SHIPMENTS"

View Text - HTML Formatted

SELECT SHIPMENT_ID SHIPMENT_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUOTE_HEADER_ID QUOTE_HEADER_ID
, QUOTE_LINE_ID QUOTE_LINE_ID
, PROMISE_DATE PROMISE_DATE
, REQUEST_DATE REQUEST_DATE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SHIP_PARTIAL_FLAG SHIP_PARTIAL_FLAG
, SHIP_SET_ID SHIP_SET_ID
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FOB_CODE FOB_CODE
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, QUANTITY QUANTITY
, RESERVED_QUANTITY RESERVED_QUANTITY
, RESERVATION_ID RESERVATION_ID
, ORDER_LINE_ID ORDER_LINE_ID
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_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
, SHIP_QUOTE_PRICE SHIP_QUOTE_PRICE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SHIP_TO_CUST_ACCOUNT_ID SHIP_TO_CUST_ACCOUNT_ID
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_TO_CUST_PARTY_ID SHIP_TO_CUST_PARTY_ID
, SHIP_METHOD_CODE_FROM SHIP_METHOD_CODE_FROM
, FREIGHT_TERMS_CODE_FROM FREIGHT_TERMS_CODE_FROM
, REQUEST_DATE_TYPE REQUEST_DATE_TYPE
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
FROM "ASO"."ASO_SHIPMENTS"