[Home] [Help]
View: CAC_SR_SCHEDULES_VL
View Text
SELECT JSSB.ROWID ROW_ID
, JSSB.SCHEDULE_ID
, JSSB.OBJECT_VERSION_NUMBER
, JSSB.TEMPLATE_ID
, JSSB.TEMPLATE_OVN
, JSSB.SCHEDULE_CATEGORY
, JSSB.START_DATE_ACTIVE
, JSSB.END_DATE_ACTIVE
, JSSB.DELETED_DATE
, JSSTL.SCHEDULE_NAME
, JSSTL.SCHEDULE_DESC
, JSSB.CREATED_BY
, JSSB.CREATION_DATE
, JSSB.LAST_UPDATED_BY
, JSSB.LAST_UPDATE_DATE
, JSSB.LAST_UPDATE_LOGIN
FROM CAC_SR_SCHEDULES_B JSSB
, CAC_SR_SCHEDULES_TL JSSTL
WHERE JSSTL.SCHEDULE_ID = JSSB.SCHEDULE_ID
AND JSSTL.LANGUAGE = USERENV('LANG')