View: OE_LINES_VIEW_RETURNS_V

Product:	ONT - Order Management
Description:	No longer used
Implementation/DBA Data:	APPS.OE_LINES_VIEW_RETURNS_V

View Text

SELECT L.LINE_ID LINE_ID
, L.HEADER_ID HEADER_ID
, L.LINE_NUMBER LINE_NUMBER
, L.SHIPMENT_NUMBER SHIPMENT_NUMBER
, L.OPTION_NUMBER OPTION_NUMBER
, UOM.UOM_CODE UOM_CODE
, NVL(L.ORDERED_QUANTITY
, 0) OPEN_QUANTITY
, L.CANCELLED_QUANTITY CANCELLED_QUANTITY
, L.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, AL.MEANING RETURN_REASON
, RCT.TRX_NUMBER CREDIT_TO_INVOICE
, L.ORDERED_ITEM
, L.FULFILLED_QUANTITY ACCEPTED_QUANTITY
, H.ORDER_NUMBER
, L.REFERENCE_LINE_ID
, L.PROMISE_DATE EXPECTED_RETURN_DATE
, OOT.NAME ORDER_TYPE
, OLT.NAME LINE_TYPE
, L.SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, L.ROWID ROW_ID
, L.ORDERED_QUANTITY_UOM2 SECONDARY_UOM_CODE
, NVL(L.ORDERED_QUANTITY2
, 0) OPEN_QUANTITY2
, L.FULFILLED_QUANTITY2 ACCEPTED_QUANTITY2
, L.CANCELLED_QUANTITY2 CANCELLED_QUANTITY2
, L.ORG_ID
FROM OE_ORDER_LINES L
, MTL_UNITS_OF_MEASURE UOM
, AR_LOOKUPS AL
, RA_CUSTOMER_TRX_ALL RCT
, RA_CUSTOMER_TRX_LINES_ALL RCTL
, OE_ORDER_HEADERS H
, OE_TRANSACTION_TYPES_TL OLT
, OE_TRANSACTION_TYPES_TL OOT
WHERE UOM.UOM_CODE = NVL( L.ORDER_QUANTITY_UOM
, 'EA' )
AND AL.LOOKUP_TYPE(+)='CREDIT_MEMO_REASON'
AND AL.LOOKUP_CODE(+)=L.RETURN_REASON_CODE
AND RCT.CUSTOMER_TRX_ID(+) = RCTL.CUSTOMER_TRX_ID
AND RCTL.CUSTOMER_TRX_LINE_ID(+) = L.CREDIT_INVOICE_LINE_ID
AND H.HEADER_ID = L.HEADER_ID
AND H.ORDER_TYPE_ID = OOT.TRANSACTION_TYPE_ID
AND L.LINE_TYPE_ID = OLT.TRANSACTION_TYPE_ID
AND OOT.LANGUAGE = USERENV('LANG')
AND OLT.LANGUAGE = USERENV('LANG')

Columns