[Home] [Help]
View: OEFV_ORDER_CANCELLATIONS
View Text
SELECT CANCEL.CANCEL_CODE
, CANCEL.CANCEL_COMMENT
, CANCEL.CANCEL_DATE
, CANCEL.CANCELLED_QUANTITY
, '_DF:OE:SO_ORDER_CANCELLATIONS:CANCEL'
, HEADER.ORDER_NUMBER
, LINE.LINE_NUMBER
, CANCEL.HEADER_ID
, CANCEL.LINE_ID
, CANCEL.LAST_UPDATE_DATE
, CANCEL.LAST_UPDATED_BY
, CANCEL.CREATION_DATE
, CANCEL.CREATED_BY
FROM SO_ORDER_CANCELLATIONS CANCEL
, SO_HEADERS_ALL HEADER
, SO_LINES_ALL LINE
WHERE CANCEL.HEADER_ID = HEADER.HEADER_ID
AND CANCEL.LINE_ID = LINE.LINE_ID(+) WITH READ ONLY
Columns
Name |
CANCEL_REASON |
CANCEL_COMMENT |
DATE_CANCELLED |
QUANTITY_CANCELLED |
"_DF" |
ORDER_NUMBER |
LINE_NUMBER |
HEADER_ID |
LINE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |