View: OE_BIS_CANCELLED_BOOKINGS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.OE_BIS_CANCELLED_BOOKINGS_V

View Text

SELECT L.LINE_ID
, DECODE(L.LINE_ID
, NULL
, L.ORDERED_QUANTITY
, NVL(C.CANCELLED_QUANTITY
, L.ORDERED_QUANTITY - GREATEST(L.SHIPPED_QUANTITY
, L.INVOICED_QUANTITY))) CANCELLED_QUANTITY
, L.SELLING_PRICE
, H.CURRENCY_CODE
, C.CANCEL_DATE
, C.LINE_ID C_LINE_ID
, L.HEADER_ID
, C.HEADER_ID C_HEADER_ID
, H.ORG_ID OU_ID
FROM SO_LINES_ALL L
, SO_HEADERS_ALL H
, SO_ORDER_CANCELLATIONS C
WHERE (L.LINE_ID = C.LINE_ID OR (L.HEADER_ID = C.HEADER_ID
AND C.LINE_ID IS NULL))
AND L.S1 = 1
AND L.S1_DATE <= C.CANCEL_DATE
AND L.HEADER_ID = H.HEADER_ID

Columns