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.

[Home] [Help]

View: CHV_HORIZ_QTY_SCHEDULES_V

Product:	CHV - Supplier Scheduling
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CHV_HORIZ_QTY_SCHEDULES_V

View Text

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

Columns

Name
SCHEDULE_ID
SCHEDULE_ITEM_ID
ROW_SELECT_ORDER
ROW_TYPE
COLUMN1
COLUMN2
COLUMN3
COLUMN4
COLUMN5
COLUMN6
COLUMN7
COLUMN8
COLUMN9
COLUMN10
COLUMN11
COLUMN12
COLUMN13
COLUMN14
COLUMN15
COLUMN16
COLUMN17
COLUMN18
COLUMN19
COLUMN20
COLUMN21
COLUMN22
COLUMN23
COLUMN24
COLUMN25
COLUMN26
COLUMN27
COLUMN28
COLUMN29
COLUMN30
COLUMN31
COLUMN32
COLUMN33
COLUMN34
COLUMN35
COLUMN36
COLUMN37
COLUMN38
COLUMN39
COLUMN40
COLUMN41
COLUMN42
COLUMN43
COLUMN44
COLUMN45
COLUMN46
COLUMN47
COLUMN48
COLUMN49
COLUMN50
COLUMN51
COLUMN52
COLUMN53
COLUMN54
COLUMN55
COLUMN56
COLUMN57
COLUMN58
COLUMN59
COLUMN60
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN