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


VIEW: APPS.ICX_WEBSTORE_CATEGORIES_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER
Yes
DESCRIPTION VARCHAR2 (240)
PRICE_LIST_ID NUMBER
Yes
CATEGORY_SET_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
Query Text

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


SELECT CATEGORY_ID
,      DESCRIPTION
,      PRICE_LIST_ID
,      CATEGORY_SET_ID
,      ORGANIZATION_ID
FROM APPS.ICX_WEBSTORE_CATEGORIES_V;

Dependencies

[top of page]

APPS.ICX_WEBSTORE_CATEGORIES_V references the following:

SchemaAPPS
SynonymMTL_CATEGORIES_KFV
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_SYSTEM_ITEMS_KFV
PL/SQL PackageQP_PRICE_LIST_PVT - show dependent code
PL/SQL PackageQP_UTIL - show dependent code
SynonymSO_PRICE_LIST_LINES
APPS.ICX_WEBSTORE_CATEGORIES_V is referenced by following:

SchemaAPPS
ViewICX_CATG_DETLS_INFO_V