[Home] [Help]
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
Name |
ORDER_NUMBER |
RETURN_LINE_ID |
RETURN_LINE_NUMBER |
INVENTORY_ITEM_ID |
PARTY_ID |
CUST_ACCOUNT_ID |