[Home] [Help]
[Dependency Information]
VIEW: APPS.BIS_PRODUCT_CATEGORIES_V
Object Details
Object Name: | BIS_PRODUCT_CATEGORIES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIS.BIS_PRODUCT_CATEGORIES_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
This view contains all the valid Product categories, i.e., all Product categories that exist in MTL_CATEGORY_SET_VALID_CATS.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
VARCHAR2 |
(40) |
|
Internal ID of categories |
VALUE |
VARCHAR2 |
(163) |
|
Category concatenated segments |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
FROM APPS.BIS_PRODUCT_CATEGORIES_V;
Dependencies
[top of page]
APPS.BIS_PRODUCT_CATEGORIES_V references the following:
-
APPS
-
MTL_CATEGORY_SET_VALID_CATS_V
-
MTL_DEFAULT_CATEGORY_SETS_FK_V
APPS.BIS_PRODUCT_CATEGORIES_V is referenced by following:
-
APPS
-
HRI_PARAMETERS
- show dependent code
-
HR_PARAMETER_HRMNPSUM
- show dependent code