VIEW: APPS.CZ_RP_EFF_DIRECTORY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'