VIEW: APPS.OKX_QTE_SHIPMENTS_V

Source

View Text - Preformatted

SELECT SHIPMENT_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, QUOTE_HEADER_ID, QUOTE_LINE_ID, PROMISE_DATE, REQUEST_DATE, SCHEDULE_SHIP_DATE, SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_ID, SHIP_PARTIAL_FLAG, SHIP_SET_ID, SHIP_METHOD_CODE, FREIGHT_TERMS_CODE, FREIGHT_CARRIER_CODE, FOB_CODE ,SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, QUANTITY, RESERVED_QUANTITY, RESERVATION_ID, ORDER_LINE_ID, SHIPMENT_PRIORITY_CODE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_QUOTE_PRICE, OBJECT_VERSION_NUMBER, SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS

View Text - HTML Formatted

SELECT SHIPMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUOTE_HEADER_ID
, QUOTE_LINE_ID
, PROMISE_DATE
, REQUEST_DATE
, SCHEDULE_SHIP_DATE
, SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_ID
, SHIP_PARTIAL_FLAG
, SHIP_SET_ID
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, FREIGHT_CARRIER_CODE
, FOB_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, QUANTITY
, RESERVED_QUANTITY
, RESERVATION_ID
, ORDER_LINE_ID
, SHIPMENT_PRIORITY_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SHIP_QUOTE_PRICE
, OBJECT_VERSION_NUMBER
, SHIP_TO_CUST_ACCOUNT_ID
FROM ASO_SHIPMENTS