[Home] [Help]
View: MSD_ORG_CALENDAR_CS_V
Product: | MSD - Demand Planning |
Description: | Working Day Allocation Stream Planning Server View |
Implementation/DBA Data: |
APPS.MSD_ORG_CALENDAR_CS_V
|
View Text
SELECT MLV.LEVEL_PK
, 7
, 9
, DECODE(MT.SEQ_NUM
, -1
, 0
, 1)
, MT.DAY
, MT.CREATION_DATE
, MT.CREATED_BY
, MT.LAST_UPDATE_DATE
, MT.LAST_UPDATED_BY
, MT.LAST_UPDATE_LOGIN
FROM MSD_LEVEL_VALUES MLV
, MSD_ORG_CALENDARS MOG
, MSD_TIME MT
WHERE MLV.LEVEL_ID = 7
AND MLV.INSTANCE = MOG.INSTANCE
AND MLV.SR_LEVEL_PK = MOG.SR_ORG_PK
AND MT.CALENDAR_TYPE = 2
AND MT.CALENDAR_TYPE=MOG.CALENDAR_TYPE
AND MT.CALENDAR_CODE=MOG.CALENDAR_CODE
Columns
Name |
ORG_LEVEL_VALUE_PK |
ORG_LEVEL_ID |
TIME_LEVEL_ID |
QUANTITY |
END_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |