[Home] [Help]
[Dependency Information]
VIEW: APPS.ENI_ITEM_PROD_CAT_LOOKUP_V
Object Details
Object Name: | ENI_ITEM_PROD_CAT_LOOKUP_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
NUMBER |
|
|
|
VALUE |
VARCHAR2 |
(406) |
|
|
TOP_NODE_FLAG |
VARCHAR2 |
(1) |
|
|
PARENT_ID |
NUMBER |
|
|
|
CHILD_ID |
NUMBER |
|
|
|
LEAF_NODE_FLAG |
VARCHAR2 |
(1) |
|
|
ITEM_ASSGN_FLAG |
VARCHAR2 |
(1) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, TOP_NODE_FLAG
, PARENT_ID
, CHILD_ID
, LEAF_NODE_FLAG
, ITEM_ASSGN_FLAG
FROM APPS.ENI_ITEM_PROD_CAT_LOOKUP_V;
Dependencies
[top of page]
APPS.ENI_ITEM_PROD_CAT_LOOKUP_V references the following:
-
APPS
-
ENI_DENORM_HIERARCHIES
-
FND_LOOKUP_VALUES
-
MTL_CATEGORIES_B_KFV
-
MTL_CATEGORIES_TL
-
MTL_DEFAULT_CATEGORY_SETS
APPS.ENI_ITEM_PROD_CAT_LOOKUP_V is referenced by following:
-
APPS
-
IBE_BI_PROD_CATG_PVT
- show dependent code