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.CHV_HORIZ_DATE_SCHEDULES_V

Source

View Text - Preformatted


SELECT SCHEDULE_ID , SCHEDULE_ITEM_ID , ROW_SELECT_ORDER , ROW_TYPE , NVL(TO_DATE(COLUMN1,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN2,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN3,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN4,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN5,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN6,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN7,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN8,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN9,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN10,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN11,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN12,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN13,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN14,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN15,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN16,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN17,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN18,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN19,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN20,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN21,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN22,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN23,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN24,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN25,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN26,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN27,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN28,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN29,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN30,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN31,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN32,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN33,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN34,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN35,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN36,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN37,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN38,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN39,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN40,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN41,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN42,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN43,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN44,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN45,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN46,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN47,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN48,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN49,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN50,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN51,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN52,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN53,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN54,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN55,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN56,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN57,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN58,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN59,'YYYY/MM/DD'),NULL) , NVL(TO_DATE(COLUMN60,'YYYY/MM/DD'),NULL) , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN FROM CHV_HORIZONTAL_SCHEDULES WHERE ROW_SELECT_ORDER IN (2,7)

View Text - HTML Formatted

SELECT SCHEDULE_ID
, SCHEDULE_ITEM_ID
, ROW_SELECT_ORDER
, ROW_TYPE
, NVL(TO_DATE(COLUMN1
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN2
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN3
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN4
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN5
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN6
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN7
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN8
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN9
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN10
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN11
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN12
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN13
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN14
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN15
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN16
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN17
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN18
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN19
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN20
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN21
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN22
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN23
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN24
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN25
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN26
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN27
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN28
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN29
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN30
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN31
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN32
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN33
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN34
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN35
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN36
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN37
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN38
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN39
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN40
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN41
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN42
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN43
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN44
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN45
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN46
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN47
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN48
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN49
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN50
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN51
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN52
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN53
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN54
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN55
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN56
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN57
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN58
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN59
, 'YYYY/MM/DD')
, NULL)
, NVL(TO_DATE(COLUMN60
, 'YYYY/MM/DD')
, NULL)
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM CHV_HORIZONTAL_SCHEDULES
WHERE ROW_SELECT_ORDER IN (2
, 7)