[Home] [Help]
View: 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')