eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSD_ORG_CALENDAR_CS_V

Source

View Text - Preformatted


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, 1, 1, 'I', to_number(null), to_number(null) 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

View Text - HTML Formatted

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
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
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