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


VIEW: APPS.ICX_SHOPPING_CART_LINES_V

Object Details
Object Name: ICX_SHOPPING_CART_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_SHOPPING_CART_LINES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CART_ID NUMBER
Yes
SHOPPER_ID NUMBER
Yes
CART_LINE_ID NUMBER
Yes
CART_LINE_NUMBER NUMBER
Yes
LINE_ID VARCHAR2 (80)

ITEM_DESCRIPTION VARCHAR2 (240)

ITEM_ID NUMBER


ITEM_REV VARCHAR2 (3)

UNIT_OF_MEASURE VARCHAR2 (25)

QUANTITY NUMBER


UNIT_PRICE NUMBER


EXT_PRICE NUMBER

Extended price (quantity * unit price)
CATEGORY_ID NUMBER


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)

SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)

SUGGESTED_VENDOR_PHONE VARCHAR2 (20)

SUGGESTED_VENDOR_ITEM_NUM VARCHAR2 (25)

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


EXPENDITURE_ORGANIZATION_ID NUMBER


PROJECT_ID NUMBER


TASK_ID NUMBER


EXPENDITURE_ITEM_DATE DATE


DISTRIBUTION_ID NUMBER


CHARGE_ACCOUNT_SEGMENT1 VARCHAR2 (240)

CHARGE_ACCOUNT_SEGMENT2 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT3 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT4 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT5 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT6 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT7 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT8 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT9 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT10 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT11 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT12 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT13 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT14 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT15 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT16 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT17 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT18 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT19 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT20 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT21 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT22 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT23 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT24 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT25 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT26 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT27 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT28 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT29 VARCHAR2 (25)

CHARGE_ACCOUNT_SEGMENT30 VARCHAR2 (25)

CATEGORY_NAME VARCHAR2 (4000)
Category name
ORG_ID NUMBER

EXPRESS_NAME VARCHAR2 (25)
ITEM_NUMBER VARCHAR2 (40)
CUSTOM_DEFAULTED VARCHAR2 (1)
DELIVER_TO_LOCATION VARCHAR2 (20)
Query Text

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


SELECT CART_ID
,      SHOPPER_ID
,      CART_LINE_ID
,      CART_LINE_NUMBER
,      LINE_ID
,      ITEM_DESCRIPTION
,      ITEM_ID
,      ITEM_REV
,      UNIT_OF_MEASURE
,      QUANTITY
,      UNIT_PRICE
,      EXT_PRICE
,      CATEGORY_ID
,      LINE_TYPE_ID
,      EXPENDITURE_TYPE
,      DESTINATION_ORGANIZATION_ID
,      DELIVER_TO_LOCATION_ID
,      SUGGESTED_BUYER_ID
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_SITE
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_ITEM_NUM
,      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
,      EXPENDITURE_ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ITEM_DATE
,      DISTRIBUTION_ID
,      CHARGE_ACCOUNT_SEGMENT1
,      CHARGE_ACCOUNT_SEGMENT2
,      CHARGE_ACCOUNT_SEGMENT3
,      CHARGE_ACCOUNT_SEGMENT4
,      CHARGE_ACCOUNT_SEGMENT5
,      CHARGE_ACCOUNT_SEGMENT6
,      CHARGE_ACCOUNT_SEGMENT7
,      CHARGE_ACCOUNT_SEGMENT8
,      CHARGE_ACCOUNT_SEGMENT9
,      CHARGE_ACCOUNT_SEGMENT10
,      CHARGE_ACCOUNT_SEGMENT11
,      CHARGE_ACCOUNT_SEGMENT12
,      CHARGE_ACCOUNT_SEGMENT13
,      CHARGE_ACCOUNT_SEGMENT14
,      CHARGE_ACCOUNT_SEGMENT15
,      CHARGE_ACCOUNT_SEGMENT16
,      CHARGE_ACCOUNT_SEGMENT17
,      CHARGE_ACCOUNT_SEGMENT18
,      CHARGE_ACCOUNT_SEGMENT19
,      CHARGE_ACCOUNT_SEGMENT20
,      CHARGE_ACCOUNT_SEGMENT21
,      CHARGE_ACCOUNT_SEGMENT22
,      CHARGE_ACCOUNT_SEGMENT23
,      CHARGE_ACCOUNT_SEGMENT24
,      CHARGE_ACCOUNT_SEGMENT25
,      CHARGE_ACCOUNT_SEGMENT26
,      CHARGE_ACCOUNT_SEGMENT27
,      CHARGE_ACCOUNT_SEGMENT28
,      CHARGE_ACCOUNT_SEGMENT29
,      CHARGE_ACCOUNT_SEGMENT30
,      CATEGORY_NAME
,      ORG_ID
,      EXPRESS_NAME
,      ITEM_NUMBER
,      CUSTOM_DEFAULTED
,      DELIVER_TO_LOCATION
FROM APPS.ICX_SHOPPING_CART_LINES_V;

Dependencies

[top of page]

APPS.ICX_SHOPPING_CART_LINES_V references the following:

SchemaAPPS
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymICX_CART_LINE_DISTRIBUTIONS
SynonymICX_SHOPPING_CARTS
SynonymICX_SHOPPING_CART_LINES
PL/SQL PackageICX_UTIL - show dependent code
ViewORG_ORGANIZATION_DEFINITIONS

APPS.ICX_SHOPPING_CART_LINES_V is not referenced by any database object