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

VIEW: APPS.ICX_WEBSTORE_ITEMS_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
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

Query Text

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


SELECT 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_ITEMS_V;

Dependencies

[top of page]

APPS.ICX_WEBSTORE_ITEMS_V references the following:

SchemaAPPS
SynonymFND_PROFILE_OPTIONS
SynonymFND_PROFILE_OPTION_VALUES
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_CUSTOMER_ITEM_XREFS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackageQP_PRICE_LIST_PVT - show dependent code
PL/SQL PackageQP_UTIL - show dependent code
SynonymSO_PRICE_LISTS
SynonymSO_PRICE_LIST_LINES

APPS.ICX_WEBSTORE_ITEMS_V is not referenced by any database object