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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: ICX.ICX_SHOPPING_CART_LINES#

Object Details

Object Name:	ICX_SHOPPING_CART_LINES#
Object Type:	VIEW
Owner:	ICX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CART_LINE_ID	NUMBER		Yes
CART_LINE_NUMBER	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
CART_ID	NUMBER		Yes
LINE_ID	VARCHAR2	(80)
ITEM_DESCRIPTION	VARCHAR2	(240)
QUANTITY	NUMBER
UNIT_PRICE	NUMBER
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
LINE_TYPE_ID	NUMBER
EXPENDITURE_TYPE	VARCHAR2	(30)
DESTINATION_ORGANIZATION_ID	NUMBER
DELIVER_TO_LOCATION_ID	NUMBER
SUGGESTED_BUYER_ID	NUMBER
SUGGESTED_VENDOR_NAME	VARCHAR2	(80)
SUGGESTED_VENDOR_SITE	VARCHAR2	(15)
LINE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
LINE_ATTRIBUTE1	VARCHAR2	(150)
LINE_ATTRIBUTE2	VARCHAR2	(150)
LINE_ATTRIBUTE3	VARCHAR2	(150)
LINE_ATTRIBUTE4	VARCHAR2	(150)
LINE_ATTRIBUTE5	VARCHAR2	(150)
LINE_ATTRIBUTE6	VARCHAR2	(150)
LINE_ATTRIBUTE7	VARCHAR2	(150)
LINE_ATTRIBUTE8	VARCHAR2	(150)
LINE_ATTRIBUTE9	VARCHAR2	(150)
LINE_ATTRIBUTE10	VARCHAR2	(150)
LINE_ATTRIBUTE11	VARCHAR2	(150)
LINE_ATTRIBUTE12	VARCHAR2	(150)
LINE_ATTRIBUTE13	VARCHAR2	(150)
LINE_ATTRIBUTE14	VARCHAR2	(150)
LINE_ATTRIBUTE15	VARCHAR2	(150)
NEED_BY_DATE	DATE
AUTOSOURCE_DOC_HEADER_ID	NUMBER
AUTOSOURCE_DOC_LINE_NUM	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
EXPENDITURE_ITEM_DATE	DATE
SUGGESTED_VENDOR_CONTACT	VARCHAR2	(80)
SUGGESTED_VENDOR_PHONE	VARCHAR2	(20)
SUGGESTED_VENDOR_ITEM_NUM	VARCHAR2	(25)
EXPENDITURE_ORGANIZATION_ID	NUMBER
SUPPLIER_ITEM_NUM	VARCHAR2	(25)
ORG_ID	NUMBER
EXPRESS_NAME	VARCHAR2	(25)
ITEM_NUMBER	VARCHAR2	(40)
DELIVER_TO_LOCATION	VARCHAR2	(20)
CUSTOM_DEFAULTED	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CART_LINE_ID
,      CART_LINE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CART_ID
,      LINE_ID
,      ITEM_DESCRIPTION
,      QUANTITY
,      UNIT_PRICE
,      ITEM_ID
,      ITEM_REVISION
,      CATEGORY_ID
,      UNIT_OF_MEASURE
,      LINE_TYPE_ID
,      EXPENDITURE_TYPE
,      DESTINATION_ORGANIZATION_ID
,      DELIVER_TO_LOCATION_ID
,      SUGGESTED_BUYER_ID
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_SITE
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      NEED_BY_DATE
,      AUTOSOURCE_DOC_HEADER_ID
,      AUTOSOURCE_DOC_LINE_NUM
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ITEM_DATE
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_ITEM_NUM
,      EXPENDITURE_ORGANIZATION_ID
,      SUPPLIER_ITEM_NUM
,      ORG_ID
,      EXPRESS_NAME
,      ITEM_NUMBER
,      DELIVER_TO_LOCATION
,      CUSTOM_DEFAULTED
FROM ICX.ICX_SHOPPING_CART_LINES#;

Dependencies

[top of page]

ICX.ICX_SHOPPING_CART_LINES# references the following:

ICX: ICX_SHOPPING_CART_LINES

ICX.ICX_SHOPPING_CART_LINES# is referenced by following:

APPS: ICX_SHOPPING_CART_LINES