VIEW: APPS.CZ_RP_DIRECTORY_V

Source

View Text - Preformatted

SELECT OBJECT_TYPE, OBJECT_ID, ENCLOSING_FOLDER, NAME, NOTES AS SYNOPSIS, DESCRIPTION, DELETED_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM CZ_RP_ENTRIES UNION SELECT OBJECT_TYPE, OBJECT_ID, ENCLOSING_FOLDER, NAME, SYNOPSIS, DESCRIPTION, DELETED_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM CZ_RP_EFF_DIRECTORY_V UNION SELECT OBJECT_TYPE, OBJECT_ID, ENCLOSING_FOLDER, NAME, SYNOPSIS, DESCRIPTION, DELETED_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM CZ_RP_PRJ_DIRECTORY_V UNION SELECT OBJECT_TYPE, OBJECT_ID, ENCLOSING_FOLDER, NAME, SYNOPSIS, DESCRIPTION, DELETED_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM CZ_RP_USG_DIRECTORY_V

View Text - HTML Formatted

SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, NOTES AS SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_ENTRIES UNION SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_EFF_DIRECTORY_V UNION SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_PRJ_DIRECTORY_V UNION SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_USG_DIRECTORY_V