View: OEBV_ORDER_CANCELLATIONS

Product:	ONT - Order Management
Description:	Base BIS Business View for Order Cancellations.
Implementation/DBA Data:	APPS.OEBV_ORDER_CANCELLATIONS

View Text

SELECT '_LA:OE_ORDER_LINES_HISTORY.REASON_CODE:OE_LOOKUPS:CANCEL_CODE:MEANING'
, HIST_COMMENTS
, HIST_CREATION_DATE
, CANCELLED_QUANTITY
, CANCELLED_QUANTITY2
, HEADER_ID
, LINE_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, HIST_CREATED_BY
, CHARGE_PERIODICITY_CODE
FROM OE_ORDER_LINES_HISTORY
WHERE HIST_TYPE_CODE='CANCELLATION'
AND NVL(CANCELLED_QUANTITY
, 0) > 0
AND '_SEC:SOLD_TO_ORG_ID' IS NOT NULL WITH READ ONLY

Columns