[Home] [Help]
[Dependency Information]
VIEW: BEN.BEN_TCS_CAT_SUBCAT_HRCHY#
Object Details
Object Name: | BEN_TCS_CAT_SUBCAT_HRCHY# |
Object Type: | VIEW |
Owner: | BEN |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CAT_ID |
NUMBER |
(15) |
Yes |
|
SUB_CAT_ID |
NUMBER |
(15) |
Yes |
|
STMT_ID |
NUMBER |
(15) |
Yes |
|
LVL_NUM |
NUMBER |
(15) |
Yes |
|
ROW_IN_CAT_ID |
NUMBER |
(15) |
|
|
STMT_PERD_ID |
NUMBER |
(15) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CAT_ID
, SUB_CAT_ID
, STMT_ID
, LVL_NUM
, ROW_IN_CAT_ID
, STMT_PERD_ID
FROM BEN.BEN_TCS_CAT_SUBCAT_HRCHY#;
Dependencies
[top of page]
BEN.BEN_TCS_CAT_SUBCAT_HRCHY# references the following:
-
BEN
-
BEN_TCS_CAT_SUBCAT_HRCHY
BEN.BEN_TCS_CAT_SUBCAT_HRCHY# is referenced by following:
-
APPS
-
BEN_TCS_CAT_SUBCAT_HRCHY