[Home] [Help]
View: 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
Name |
LINE_ID |
CANCELLED_QUANTITY |
SELLING_PRICE |
CURRENCY_CODE |
CANCEL_DATE |
C_LINE_ID |
HEADER_ID |
C_HEADER_ID |
OU_ID |