View: CS_RETURNS_RG_V

Product:	CS - Service
Description:	This View is a replica of the ASO object aso_returns_v
Implementation/DBA Data:	APPS.CS_RETURNS_RG_V

View Text

SELECT /* FIRST_ROWS */ OEH.ORDER_NUMBER
, OEL.LINE_ID
, OEL.LINE_NUMBER
, OEL.INVENTORY_ITEM_ID
, OEH.INVOICE_TO_ORG_ID
, OEH.SOLD_TO_ORG_ID
FROM OE_ORDER_HEADERS_ALL OEH
, OE_ORDER_LINES_ALL OEL
WHERE OEL.HEADER_ID = OEH.HEADER_ID
AND OEL.LINE_CATEGORY_CODE = 'RETURN'
AND NVL(OEH.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns