[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: | ICX.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:
-
APPS
-
MTL_CATEGORIES_KFV
-
MTL_ITEM_CATEGORIES
-
MTL_SYSTEM_ITEMS_KFV
-
QP_PRICE_LIST_PVT
- show dependent code
-
QP_UTIL
- show dependent code
-
SO_PRICE_LIST_LINES
APPS.ICX_WEBSTORE_CATEGORIES_V is referenced by following:
-
APPS
-
ICX_CATG_DETLS_INFO_V