View: CAC_SR_PERIOD_DTL_TYPES_VL

Product:	JTF - CRM Foundation
Description:	This view contains describing attributes for a period detail type.
Implementation/DBA Data:	APPS.CAC_SR_PERIOD_DTL_TYPES_VL

View Text

SELECT CSPDTB.ROWID ROW_ID
, CSPDTB.PERIOD_DTL_TYPE_ID
, CSPDTB.DISPLAY_COLOR
, CSPDTTL.PERIOD_DTL_TYPE_NAME
, CSPDTTL.PERIOD_DTL_TYPE_DESC
, CSPDTB.CREATED_BY
, CSPDTB.CREATION_DATE
, CSPDTB.LAST_UPDATED_BY
, CSPDTB.LAST_UPDATE_DATE
, CSPDTB.LAST_UPDATE_LOGIN
FROM CAC_SR_PERIOD_DTL_TYPES_B CSPDTB
, CAC_SR_PERIOD_DTL_TYPES_TL CSPDTTL
WHERE CSPDTTL.PERIOD_DTL_TYPE_ID = CSPDTB.PERIOD_DTL_TYPE_ID
AND CSPDTTL.LANGUAGE = USERENV('LANG')

Columns