VIEW: ICX.ICX_SHOPPING_CART_LINES#

Source

View Text - Preformatted

select CART_LINE_ID CART_LINE_ID, CART_LINE_NUMBER CART_LINE_NUMBER, 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, CART_ID CART_ID, LINE_ID LINE_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, QUANTITY QUANTITY, UNIT_PRICE UNIT_PRICE, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, CATEGORY_ID CATEGORY_ID, UNIT_OF_MEASURE UNIT_OF_MEASURE, LINE_TYPE_ID LINE_TYPE_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE SUGGESTED_VENDOR_SITE, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, NEED_BY_DATE NEED_BY_DATE, AUTOSOURCE_DOC_HEADER_ID AUTOSOURCE_DOC_HEADER_ID, AUTOSOURCE_DOC_LINE_NUM AUTOSOURCE_DOC_LINE_NUM, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_ITEM_NUM SUGGESTED_VENDOR_ITEM_NUM, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, SUPPLIER_ITEM_NUM SUPPLIER_ITEM_NUM, ORG_ID ORG_ID, EXPRESS_NAME EXPRESS_NAME, ITEM_NUMBER ITEM_NUMBER, DELIVER_TO_LOCATION DELIVER_TO_LOCATION, CUSTOM_DEFAULTED CUSTOM_DEFAULTED from "ICX"."ICX_SHOPPING_CART_LINES"

View Text - HTML Formatted

SELECT CART_LINE_ID CART_LINE_ID
, CART_LINE_NUMBER CART_LINE_NUMBER
, 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
, CART_ID CART_ID
, LINE_ID LINE_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, QUANTITY QUANTITY
, UNIT_PRICE UNIT_PRICE
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, CATEGORY_ID CATEGORY_ID
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, LINE_TYPE_ID LINE_TYPE_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID
, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_SITE SUGGESTED_VENDOR_SITE
, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, NEED_BY_DATE NEED_BY_DATE
, AUTOSOURCE_DOC_HEADER_ID AUTOSOURCE_DOC_HEADER_ID
, AUTOSOURCE_DOC_LINE_NUM AUTOSOURCE_DOC_LINE_NUM
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_ITEM_NUM SUGGESTED_VENDOR_ITEM_NUM
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, SUPPLIER_ITEM_NUM SUPPLIER_ITEM_NUM
, ORG_ID ORG_ID
, EXPRESS_NAME EXPRESS_NAME
, ITEM_NUMBER ITEM_NUMBER
, DELIVER_TO_LOCATION DELIVER_TO_LOCATION
, CUSTOM_DEFAULTED CUSTOM_DEFAULTED
FROM "ICX"."ICX_SHOPPING_CART_LINES"