Product: | ONT - Order Management |
---|---|
Description: | Base BIS Business View for Order Cancellations. |
Implementation/DBA Data: | APPS.OEBV_ORDER_CANCELLATIONS |
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