Product: | BOM - Bills of Material |
---|---|
Description: | View of BOM_CALENDARS table |
Implementation/DBA Data: | APPS.BOM_CALENDARS_VIEW |
SELECT BCAL.CALENDAR_CODE
, BCAL.LAST_UPDATE_DATE
, BCAL.LAST_UPDATED_BY
, BCAL.CREATION_DATE
, BCAL.CREATED_BY
, BCAL.LAST_UPDATE_LOGIN
, BCAL.QUARTERLY_CALENDAR_TYPE
, BCAL.DAYS_ON
, BCAL.DAYS_OFF
, BCAL.CALENDAR_START_DATE
, BCAL.CALENDAR_END_DATE
, BCAL.DESCRIPTION
, BCAL.ATTRIBUTE_CATEGORY
, BCAL.ATTRIBUTE1
, BCAL.ATTRIBUTE2
, BCAL.ATTRIBUTE3
, BCAL.ATTRIBUTE4
, BCAL.ATTRIBUTE5
, BCAL.ATTRIBUTE6
, BCAL.ATTRIBUTE7
, BCAL.ATTRIBUTE8
, BCAL.ATTRIBUTE9
, BCAL.ATTRIBUTE10
, BCAL.ATTRIBUTE11
, BCAL.ATTRIBUTE12
, BCAL.ATTRIBUTE13
, BCAL.ATTRIBUTE14
, BCAL.ATTRIBUTE15
, BCAL.REQUEST_ID
, BCAL.PROGRAM_APPLICATION_ID
, BCAL.PROGRAM_ID
, BCAL.PROGRAM_UPDATE_DATE
FROM BOM_CALENDARS BCAL
WHERE NVL(BCAL.CALENDAR_START_DATE
, SYSDATE-1) <= SYSDATE
AND NVL(BCAL.CALENDAR_END_DATE
, SYSDATE+1) > SYSDATE