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')
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')
|
|
|