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]

TABLE: ICX.ICX_SHOPPING_CARTS

Object Details

Object Name:	ICX_SHOPPING_CARTS
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_SHOPPING_CARTS
Subobject Name:
Status:	VALID

ICX_SHOPPING_CARTS stores information about requisition headers before
it is written to the PO_REQUISITION_INTERFACE table. One row is
created each time a requisition header is created. Each row
contains the requisition number, preparer, description, destination,
and delivery information.
.
CART_ID is a unique system generated number. It is invisible to the
user. REQ_NUMBER_SEGMENT1 is the number used to identify the
requisition. REQ_NUMBER_SEGMENT1 is generated using the
PO_UNIQUE_IDENTIFIER_CONTROL table. REQ_NUMBER_SEGMENT1 provides
unique values for each row in the table in addition to CART_ID.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_SHOPPING_CARTS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CART_ID
ICX_SHOPPING_CARTS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SAVED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
CART_ID	NUMBER		Yes	Requisition header unique identifier
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
SHOPPER_ID	NUMBER		Yes	User ID of the person logged in
SAVED_FLAG	NUMBER		Yes	Indicates whether requisition submitted or saved for later completion
EMERGENCY_FLAG	VARCHAR2	(1)		Indicates whether emergency requisition or not
APPROVER_ID	NUMBER			Approver unique identifier
APPROVER_NAME	VARCHAR2	(240)		Approver name
NOTE_TO_APPROVER	VARCHAR2	(240)		Note to approver
REQ_NUMBER_SEGMENT1	VARCHAR2	(30)		Requisition number
HEADER_DESCRIPTION	VARCHAR2	(240)		Header description
HEADER_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
HEADER_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
HEADER_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
NOTE_TO_BUYER	VARCHAR2	(240)		Note to buyer
RESERVED_PO_NUM	VARCHAR2	(220)		PO number for emergency requisitions
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Requisition destination type
DESTINATION_ORGANIZATION_ID	NUMBER			Destination organization unique identifier
DELIVER_TO_LOCATION_ID	NUMBER			Deliver-to-location unique identifier
DELIVER_TO_REQUESTOR_ID	NUMBER			Requester unique identifier
NEED_BY_DATE	DATE			Date the order is needed (default for all items)
ORG_ID	NUMBER			Organization unique identifier
DELIVER_TO_LOCATION	VARCHAR2	(20)		Deliver-to-location code
DELIVER_TO_REQUESTOR	VARCHAR2	(240)		Requester name

Query Text

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


SELECT CART_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SHOPPER_ID
,      SAVED_FLAG
,      EMERGENCY_FLAG
,      APPROVER_ID
,      APPROVER_NAME
,      NOTE_TO_APPROVER
,      REQ_NUMBER_SEGMENT1
,      HEADER_DESCRIPTION
,      HEADER_ATTRIBUTE_CATEGORY
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_ATTRIBUTE11
,      HEADER_ATTRIBUTE12
,      HEADER_ATTRIBUTE13
,      HEADER_ATTRIBUTE14
,      HEADER_ATTRIBUTE15
,      NOTE_TO_BUYER
,      RESERVED_PO_NUM
,      DESTINATION_TYPE_CODE
,      DESTINATION_ORGANIZATION_ID
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_REQUESTOR_ID
,      NEED_BY_DATE
,      ORG_ID
,      DELIVER_TO_LOCATION
,      DELIVER_TO_REQUESTOR
FROM ICX.ICX_SHOPPING_CARTS;

Dependencies

[top of page]

ICX.ICX_SHOPPING_CARTS does not reference any database object

ICX.ICX_SHOPPING_CARTS is referenced by following:

APPS: ICX_SHOPPING_CARTS