View: ICX_HORIZONTAL_SCHEDULE_V

Product:	ICX - Oracle iProcurement
Description:	Horizontal Schedule View
Implementation/DBA Data:	APPS.ICX_HORIZONTAL_SCHEDULE_V

View Text

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

Columns