View: CZ_RP_EFF_DIRECTORY_V

Product:	CZ - Configurator
Description:	Information view of Effectivities in Repository
Implementation/DBA Data:	APPS.CZ_RP_EFF_DIRECTORY_V

View Text

SELECT CZ_RP_ENTRIES.OBJECT_TYPE
, CZ_RP_ENTRIES.OBJECT_ID
, CZ_RP_ENTRIES.ENCLOSING_FOLDER
, CZ_EFFECTIVITY_SETS.NAME
, CZ_EFFECTIVITY_SETS.NAME||'
, EFFECTIVE
FROM '||DECODE(CZ_EFFECTIVITY_SETS.EFFECTIVE_FROM
, CZ_UTILS.EPOCH_BEGIN
, ''
, TO_CHAR(CZ_EFFECTIVITY_SETS.EFFECTIVE_FROM))||' UNTIL '||DECODE(CZ_EFFECTIVITY_SETS.EFFECTIVE_UNTIL
, CZ_UTILS.EPOCH_END
, ''
, TO_CHAR(CZ_EFFECTIVITY_SETS.EFFECTIVE_UNTIL))||'. '||SUBSTR(CZ_EFFECTIVITY_SETS.DESCRIPTION
, 1
, 150) AS SYNOPSIS
, CZ_EFFECTIVITY_SETS.DESCRIPTION AS DESCRIPTION
, CZ_EFFECTIVITY_SETS.DELETED_FLAG
, CZ_EFFECTIVITY_SETS.CREATED_BY
, CZ_EFFECTIVITY_SETS.CREATION_DATE
, CZ_EFFECTIVITY_SETS.LAST_UPDATED_BY
, CZ_EFFECTIVITY_SETS.LAST_UPDATE_DATE
FROM CZ_EFFECTIVITY_SETS
, CZ_RP_ENTRIES
WHERE CZ_EFFECTIVITY_SETS.EFFECTIVITY_SET_ID = CZ_RP_ENTRIES.OBJECT_ID
AND CZ_RP_ENTRIES.OBJECT_TYPE='EFF'

Columns