[Home] [Help] [Dependency Information]
Object Name: | ICX_WEBSTORE_SEARCH_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_WEBSTORE_SEARCH_ITEMS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONID | NUMBER | |||
SCORE | NUMBER | |||
PRICE_LIST_LINE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
LIST_PRICE | NUMBER | |||
ITEM_NAME | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ITEM_URL | VARCHAR2 | (240) | ||
PRICE_LIST_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (30) | ||
CATEGORY_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
CATEGORY_SET_ID | NUMBER | |||
BOM_ITEM_TYPE | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_ADDRESS_ID | NUMBER | |||
CUSTOMER_ITEM_ID | NUMBER | |||
CUSTOMER_ITEM_NAME | VARCHAR2 | (50) | ||
CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | ||
ITEM_DEFINITION_LEVEL | VARCHAR2 | (1) | ||
MASTER_ORGANIZATION_ID | NUMBER | |||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT CONID
, SCORE
, PRICE_LIST_LINE_ID
, INVENTORY_ITEM_ID
, UNIT_OF_MEASURE
, LIST_PRICE
, ITEM_NAME
, ITEM_DESCRIPTION
, ITEM_URL
, PRICE_LIST_ID
, CURRENCY_CODE
, CATEGORY_ID
, ORGANIZATION_ID
, CATEGORY_SET_ID
, BOM_ITEM_TYPE
, CUSTOMER_ID
, CUSTOMER_ADDRESS_ID
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_NAME
, CUSTOMER_CATEGORY_CODE
, ITEM_DEFINITION_LEVEL
, MASTER_ORGANIZATION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM APPS.ICX_WEBSTORE_SEARCH_ITEMS_V;
APPS.ICX_WEBSTORE_SEARCH_ITEMS_V is not referenced by any database object
|
|
|