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