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

TABLE: ICX.ICX_SHOPPING_CART_LINES

Object Details
Object Name: ICX_SHOPPING_CART_LINES
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_SHOPPING_CART_LINES
Subobject Name:
Status: VALID


ICX_SHOPPING_CART_LINES stores information about requisition lines.
One row is created for each requisition line you create. Each row
contains the item number, item category, item description, quantity,
unit price, need-by date, deliver-to location, and suggested supplier
information for the requisition line.
.
CART_LINE_ID is unique identifier for the requisition line. CART_ID
establishes the link with the requisition header in the
ICX_SHOPPING_CARTS table.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_SHOPPING_CART_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCART_ID
ColumnCART_LINE_ID
Columns
Name Datatype Length Mandatory Comments
CART_LINE_ID NUMBER
Yes Requisition line unique identifier
CART_LINE_NUMBER NUMBER
Yes Line number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CART_ID NUMBER
Yes Requisition header unique identifier
LINE_ID VARCHAR2 (80)
Document line unique identifier (from PO_LINES)
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
QUANTITY NUMBER

Quantity
UNIT_PRICE NUMBER

Unit price
ITEM_ID NUMBER

Item unique identifier
ITEM_REVISION VARCHAR2 (3)
Item revision
CATEGORY_ID NUMBER

Category unique identifier
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure
LINE_TYPE_ID NUMBER

Requisition line type unique identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Project Accounting expenditure type
DESTINATION_ORGANIZATION_ID NUMBER

Destination organization unique identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver-to-location unique identifier
SUGGESTED_BUYER_ID NUMBER

Suggested buyer unique identifier
SUGGESTED_VENDOR_NAME VARCHAR2 (80)
Suggested supplier name
SUGGESTED_VENDOR_SITE VARCHAR2 (15)
Suggested supplier site
LINE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
LINE_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
LINE_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
NEED_BY_DATE DATE

Date the item is needed internally
AUTOSOURCE_DOC_HEADER_ID NUMBER

Autosource document header unique identifier
AUTOSOURCE_DOC_LINE_NUM NUMBER

Autosource document line number
PROJECT_ID NUMBER

Project Accounting project unique identifier
TASK_ID NUMBER

Project Accounting task unique identifier
EXPENDITURE_ITEM_DATE DATE

Project Accounting expenditure item date
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Suggested supplier contact
SUGGESTED_VENDOR_PHONE VARCHAR2 (20)
Suggested supplier phone number
SUGGESTED_VENDOR_ITEM_NUM VARCHAR2 (25)
Suggested supplier item number
EXPENDITURE_ORGANIZATION_ID NUMBER

Project Accounting expenditure organization unique identifier
SUPPLIER_ITEM_NUM VARCHAR2 (25)
Supplier's item number
ORG_ID NUMBER

Organization unique identifier
EXPRESS_NAME VARCHAR2 (25)
Template name
ITEM_NUMBER VARCHAR2 (40)
Item number
DELIVER_TO_LOCATION VARCHAR2 (20)
Deliver-to-location code
CUSTOM_DEFAULTED VARCHAR2 (1)
Indicates defaulting accounts have been customized
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 does not reference any database object

ICX.ICX_SHOPPING_CART_LINES is referenced by following:

SchemaAPPS
SynonymICX_SHOPPING_CART_LINES