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