[Home] [Help]
View: AMS_OE_RETURNS_V
Product: | AMS - Marketing |
Description: | Order Returns |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HEAD.ORDER_NUMBER
, LINE.LINE_ID
, LINE.LINE_NUMBER
, LINE.INVENTORY_ITEM_ID
, HEAD.INVOICE_TO_ORG_ID
, HEAD.SOLD_TO_ORG_ID
FROM OE_ORDER_LINES LINE
, OE_ORDER_HEADERS HEAD
WHERE HEAD.HEADER_ID = LINE.HEADER_ID
AND LINE.LINE_CATEGORY_CODE = 'RETURN'
Columns
Name |
ORDER_NUMBER |
LINE_ID |
LINE_NUMBER |
INVENTORY_ITEM_ID |
INVOICE_TO_ORG_ID |
SOLD_TO_ORG_ID |