VIEW: APPS.CS_RETURNS_RG_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)