[Home] [Help]
View: CZ_REPOS_TREE_V
Product: | CZ - Configurator |
Description: | Hierarchical view of the Repository |
Implementation/DBA Data: |
APPS.CZ_REPOS_TREE_V
|
View Text
SELECT CZ_RP_ENTRIES.OBJECT_TYPE
, CZ_RP_ENTRIES.OBJECT_ID
, CZ_RP_ENTRIES.ENCLOSING_FOLDER
, CZ_RP_ENTRIES.NAME
, CZ_RP_ENTRIES.NOTES
, CZ_RP_ENTRIES.DESCRIPTION
, CZ_RP_ENTRIES.DELETED_FLAG
, CZ_RP_ENTRIES.CREATED_BY
, CZ_RP_ENTRIES.CREATION_DATE
, CZ_RP_ENTRIES.LAST_UPDATED_BY
, CZ_RP_ENTRIES.LAST_UPDATE_DATE
, LEVEL AS REPOS_LEVEL
, LPAD('.'
, 2*LEVEL-2
, '.')||NAME AS INDENT_NAME
FROM CZ_RP_ENTRIES START WITH OBJECT_TYPE='FLD'
AND ENCLOSING_FOLDER=0
AND OBJECT_ID=0 CONNECT BY PRIOR OBJECT_ID=ENCLOSING_FOLDER
AND PRIOR OBJECT_TYPE = 'FLD'
AND OBJECT_ID <> 0
AND DELETED_FLAG = '0'
Columns
Name |
OBJECT_TYPE |
OBJECT_ID |
ENCLOSING_FOLDER |
NAME |
NOTES |
DESCRIPTION |
DELETED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
REPOS_LEVEL |
INDENT_NAME |