VIEW: APPS.CZ_REPOS_TREE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'