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

Source

View Text - Preformatted


SELECT CHS.SCHEDULE_ID , CHS.SCHEDULE_ITEM_ID , CHS.ROW_SELECT_ORDER , CHS.ROW_TYPE , DECODE( CHS.ROW_TYPE , 'BUCKET_DESCRIPTOR', NULL, POLC.DESCRIPTION ) , POLC.DISPLAYED_FIELD , CHS.LAST_UPDATE_DATE , CHS.LAST_UPDATED_BY , CHS.CREATION_DATE , CHS.CREATED_BY , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN1) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN1, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN1,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN2) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN2, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN2,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN3) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN3, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN3,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN4) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN4, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN4,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN5) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN5, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN5,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN6) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN6, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN6,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN7) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN7, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN7,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN8) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN8, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN8,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN9) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN9, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN9,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN10) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN10, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN10,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN11) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN11, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN11,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN12) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN12, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN12,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN13) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN13, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN13,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN14) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN14, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN14,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN15) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN15, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN15,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN16) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN16, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN16,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN17) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN17, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN17,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN18) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN18, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN18,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN19) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN19, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN19,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN20) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN20, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN20,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN21) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN21, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN21,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN22) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN22, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN22,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN23) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN23, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN23,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN24) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN24, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN24,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN25) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN25, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN25,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN26) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN26, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN26,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN27) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN27, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN27,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN28) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN28, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN28,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN29) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN29, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN29,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN30) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN30, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN30,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN31) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN31, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN31,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN32) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN32, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN32,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN33) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN33, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN33,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN34) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN34, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN34,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN35) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN35, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN35,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN36) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN36, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN36,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN37) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN37, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN37,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN38) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN38, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN38,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN39) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN39, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN39,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN40) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN40, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN40,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN41) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN41, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN41,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN42) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN42, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN42,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN43) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN43, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN43,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN44) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN44, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN44,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN45) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN45, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN45,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN46) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN46, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN46,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN47) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN47, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN47,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN48) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN48, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN48,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN49) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN49, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN49,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN50) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN50, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN50,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN51) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN51, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN51,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN52) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN52, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN52,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN53) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN53, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN53,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN54) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN54, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN54,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN55) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN55, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN55,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN56) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN56, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN56,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN57) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN57, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN57,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN58) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN58, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN58,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN59) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN59, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN59,NULL)) , DECODE(CHS.ROW_SELECT_ORDER, 1, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN60) , 2, NVL(TO_CHAR(TO_DATE(CHS.COLUMN60, 'YYYY/MM/DD')),NULL) , NVL(CHS.COLUMN60,NULL)) , CHS.LAST_UPDATE_LOGIN , CHS.REQUEST_ID , CHS.PROGRAM_APPLICATION_ID , CHS.PROGRAM_ID , CHS.PROGRAM_UPDATE_DATE FROM CHV_HORIZONTAL_SCHEDULES CHS ,PO_LOOKUP_CODES POLC WHERE POLC.LOOKUP_CODE = CHS.ROW_TYPE AND POLC.LOOKUP_TYPE = 'SCHEDULE_ROW_TYPE' AND CHS.ROW_SELECT_ORDER != 7 ORDER BY CHS.ROW_SELECT_ORDER ASC

View Text - HTML Formatted

SELECT CHS.SCHEDULE_ID
, CHS.SCHEDULE_ITEM_ID
, CHS.ROW_SELECT_ORDER
, CHS.ROW_TYPE
, DECODE( CHS.ROW_TYPE
, 'BUCKET_DESCRIPTOR'
, NULL
, POLC.DESCRIPTION )
, POLC.DISPLAYED_FIELD
, CHS.LAST_UPDATE_DATE
, CHS.LAST_UPDATED_BY
, CHS.CREATION_DATE
, CHS.CREATED_BY
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN1)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN1
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN1
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN2)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN2
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN2
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN3)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN3
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN3
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN4)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN4
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN4
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN5)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN5
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN5
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN6)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN6
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN6
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN7)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN7
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN7
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN8)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN8
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN8
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN9)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN9
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN9
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN10)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN10
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN10
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN11)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN11
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN11
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN12)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN12
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN12
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN13)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN13
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN13
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN14)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN14
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN14
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN15)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN15
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN15
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN16)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN16
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN16
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN17)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN17
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN17
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN18)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN18
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN18
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN19)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN19
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN19
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN20)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN20
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN20
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN21)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN21
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN21
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN22)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN22
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN22
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN23)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN23
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN23
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN24)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN24
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN24
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN25)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN25
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN25
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN26)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN26
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN26
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN27)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN27
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN27
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN28)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN28
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN28
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN29)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN29
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN29
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN30)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN30
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN30
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN31)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN31
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN31
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN32)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN32
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN32
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN33)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN33
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN33
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN34)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN34
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN34
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN35)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN35
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN35
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN36)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN36
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN36
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN37)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN37
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN37
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN38)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN38
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN38
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN39)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN39
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN39
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN40)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN40
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN40
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN41)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN41
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN41
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN42)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN42
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN42
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN43)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN43
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN43
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN44)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN44
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN44
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN45)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN45
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN45
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN46)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN46
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN46
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN47)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN47
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN47
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN48)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN48
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN48
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN49)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN49
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN49
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN50)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN50
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN50
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN51)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN51
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN51
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN52)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN52
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN52
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN53)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN53
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN53
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN54)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN54
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN54
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN55)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN55
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN55
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN56)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN56
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN56
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN57)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN57
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN57
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN58)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN58
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN58
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN59)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN59
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN59
, NULL))
, DECODE(CHS.ROW_SELECT_ORDER
, 1
, CHV_INQ_SV.GET_BUCKET_TYPE(CHS.COLUMN60)
, 2
, NVL(TO_CHAR(TO_DATE(CHS.COLUMN60
, 'YYYY/MM/DD'))
, NULL)
, NVL(CHS.COLUMN60
, NULL))
, CHS.LAST_UPDATE_LOGIN
, CHS.REQUEST_ID
, CHS.PROGRAM_APPLICATION_ID
, CHS.PROGRAM_ID
, CHS.PROGRAM_UPDATE_DATE
FROM CHV_HORIZONTAL_SCHEDULES CHS
, PO_LOOKUP_CODES POLC
WHERE POLC.LOOKUP_CODE = CHS.ROW_TYPE
AND POLC.LOOKUP_TYPE = 'SCHEDULE_ROW_TYPE'
AND CHS.ROW_SELECT_ORDER != 7 ORDER BY CHS.ROW_SELECT_ORDER ASC