VIEW: APPS.ASO_RETURNS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'