View: ASO_RETURNS_V

Product:	ASO - Order Capture
Description:	view lists all the return orders in Order Management
Implementation/DBA Data:	APPS.ASO_RETURNS_V

View Text

SELECT HEAD.ORDER_NUMBER
, LINE.LINE_ID
, LINE.LINE_NUMBER
, LINE.INVENTORY_ITEM_ID
, HEAD.INVOICE_TO_ORG_ID
, HEAD.CUST_ACCT_ID
FROM ASO_I_ORDER_LINES_V LINE
, ASO_I_ORDER_HEADERS_V HEAD
WHERE HEAD.HEADER_ID = LINE.HEADER_ID
AND LINE.LINE_CATEGORY_CODE = 'RETURN'

Columns