VIEW: APPS.OE_BIS_CANCELLED_BOOKINGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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