[Home] [Help]
View: CAC_SR_PERIODS_VL
View Text
SELECT CSPB.ROWID ROW_ID
, CSPB.PERIOD_ID
, CSPB.OBJECT_VERSION_NUMBER
, CSPB.PERIOD_CATEGORY_ID
, CSPB.START_DATE_ACTIVE
, CSPB.END_DATE_ACTIVE
, CSPB.SHOW_IN_LOV
, CSPB.WEEK_DAY_NUM
, CSPB.START_TIME_MS
, CSPB.END_TIME_MS
, CSPB.DURATION
, CSPB.DURATION_UOM
, CSPB.SHORT_CODE
, CSPB.HAS_DETAILS
, CSPTL.PERIOD_NAME
, CSPTL.PERIOD_DESC
, CSPB.CREATED_BY
, CSPB.CREATION_DATE
, CSPB.LAST_UPDATED_BY
, CSPB.LAST_UPDATE_DATE
, CSPB.LAST_UPDATE_LOGIN
FROM CAC_SR_PERIODS_B CSPB
, CAC_SR_PERIODS_TL CSPTL
WHERE CSPTL.PERIOD_ID=CSPB.PERIOD_ID
AND CSPTL.LANGUAGE=USERENV('LANG')