WIS_KBN_DELIVERY_SCHEDULES_VL

Details

• Schema: FUSION

• Object owner: WIS

• Object type: VIEW

Columns

Name
B_ROW_ID DELIVERY_SCHEDULE_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID DELIVERY_SCHEDULE_NAME RECURRENCE_INTERVAL DEFAULT_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT KBNDSB.ROWID B_ROW_ID, KBNDSB.DELIVERY_SCHEDULE_ID DELIVERY_SCHEDULE_ID, KBNDSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, KBNDSB.ORGANIZATION_ID ORGANIZATION_ID, KBNDSTL.DELIVERY_SCHEDULE_NAME DELIVERY_SCHEDULE_NAME, KBNDSB.RECURRENCE_INTERVAL RECURRENCE_INTERVAL, KBNDSB.DEFAULT_FLAG DEFAULT_FLAG, KBNDSB.CREATED_BY CREATED_BY, KBNDSB.CREATION_DATE CREATION_DATE, KBNDSB.LAST_UPDATED_BY LAST_UPDATED_BY, KBNDSB.LAST_UPDATE_DATE LAST_UPDATE_DATE, KBNDSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM WIS_KBN_DELIVERY_SCHEDULES_B KBNDSB, WIS_KBN_DELIVERY_SCHEDULES_TL KBNDSTL WHERE KBNDSTL.DELIVERY_SCHEDULE_ID = KBNDSB.DELIVERY_SCHEDULE_ID AND KBNDSTL.LANGUAGE = USERENV('LANG')