View: SO_FC_RETURNS_V

Product:	OE - Order Entry
Description:	Cash Management returns outflow
Implementation/DBA Data:	APPS.SO_FC_RETURNS_V

View Text

SELECT -1 * (L.ORDERED_QUANTITY - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0)) * NVL(L.SELLING_PRICE
, 0)
, NVL(H.DATE_ORDERED
, SYSDATE)
, NVL(H.DATE_REQUESTED_CURRENT
, NVL(L.DATE_REQUESTED_CURRENT
, SYSDATE))
, H.CURRENCY_CODE
, H.ORG_ID
, ( -1 * (L.ORDERED_QUANTITY - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0)) * NVL(L.SELLING_PRICE
, 0)) * NVL(H.CONVERSION_RATE
, 1)
FROM SO_HEADERS_ALL H
, SO_LINES_ALL L
WHERE H.OPEN_FLAG = 'Y'
AND NVL(H.S1
, 15) = 1
AND L.HEADER_ID = H.HEADER_ID
AND H.ORDER_CATEGORY = 'RMA'
AND NVL(L.S5
, 18) NOT IN (9
, 8)

Columns