eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: ICX.ICX_SHOPPING_CARTS#

Source

View Text - Preformatted


select CART_ID CART_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, SHOPPER_ID SHOPPER_ID, SAVED_FLAG SAVED_FLAG, EMERGENCY_FLAG EMERGENCY_FLAG, APPROVER_ID APPROVER_ID, APPROVER_NAME APPROVER_NAME, NOTE_TO_APPROVER NOTE_TO_APPROVER, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1, HEADER_DESCRIPTION HEADER_DESCRIPTION, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15, NOTE_TO_BUYER NOTE_TO_BUYER, RESERVED_PO_NUM RESERVED_PO_NUM, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID, NEED_BY_DATE NEED_BY_DATE, ORG_ID ORG_ID, DELIVER_TO_LOCATION DELIVER_TO_LOCATION, DELIVER_TO_REQUESTOR DELIVER_TO_REQUESTOR from "ICX"."ICX_SHOPPING_CARTS"

View Text - HTML Formatted

SELECT CART_ID CART_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
, SHOPPER_ID SHOPPER_ID
, SAVED_FLAG SAVED_FLAG
, EMERGENCY_FLAG EMERGENCY_FLAG
, APPROVER_ID APPROVER_ID
, APPROVER_NAME APPROVER_NAME
, NOTE_TO_APPROVER NOTE_TO_APPROVER
, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1
, HEADER_DESCRIPTION HEADER_DESCRIPTION
, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15
, NOTE_TO_BUYER NOTE_TO_BUYER
, RESERVED_PO_NUM RESERVED_PO_NUM
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID
, NEED_BY_DATE NEED_BY_DATE
, ORG_ID ORG_ID
, DELIVER_TO_LOCATION DELIVER_TO_LOCATION
, DELIVER_TO_REQUESTOR DELIVER_TO_REQUESTOR
FROM "ICX"."ICX_SHOPPING_CARTS"