DBA Data[Home] [Help]

VIEW: APPS.IEC_G_CAL_DAYS_VL

Source

View Text - Preformatted

SELECT B.DAY_ID, B.CALENDAR_ID, B.DAY_CODE, TL.DAY_NAME, B.PATTERN_CODE, B.EXCEPTION_MONTH, B.EXCEPTION_DAY, B.EXCEPTION_YEAR, B.EXCEPTION_WEEKDAY_CODE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM IEC_G_CAL_DAYS_B B, IEC_G_CAL_DAYS_TL TL WHERE B.DAY_ID = TL.DAY_ID AND TL.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT B.DAY_ID
, B.CALENDAR_ID
, B.DAY_CODE
, TL.DAY_NAME
, B.PATTERN_CODE
, B.EXCEPTION_MONTH
, B.EXCEPTION_DAY
, B.EXCEPTION_YEAR
, B.EXCEPTION_WEEKDAY_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
FROM IEC_G_CAL_DAYS_B B
, IEC_G_CAL_DAYS_TL TL
WHERE B.DAY_ID = TL.DAY_ID
AND TL.LANGUAGE = USERENV('LANG')