VIEW: APPS.OE_ORDER_LINES_ALL3_DFV

Source

View Text - Preformatted

SELECT ROWID, RETURN_CONTEXT, (DECODE (RETURN_CONTEXT, 'INVOICE', RETURN_ATTRIBUTE1, NULL)), (DECODE (RETURN_CONTEXT, 'PO', RETURN_ATTRIBUTE2, 'ORDER', RETURN_ATTRIBUTE2, 'INVOICE', RETURN_ATTRIBUTE2, NULL)), (DECODE (RETURN_CONTEXT, 'ORDER', RETURN_ATTRIBUTE1, NULL)), (DECODE (RETURN_CONTEXT, 'PO', RETURN_ATTRIBUTE1, NULL)), (DECODE (RETURN_CONTEXT, 'SERIAL', RETURN_ATTRIBUTE1, NULL)), (DECODE (RETURN_CONTEXT, 'SERIAL', RETURN_ATTRIBUTE2, NULL)),  
 (DECODE (RETURN_CONTEXT,  
      'INVOICE', RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2,  
      'ORDER', RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2,  
      'PO', RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2,  
      'SERIAL', RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2, NULL)) 
 FROM OE_ORDER_LINES_ALL

View Text - HTML Formatted

SELECT ROWID
, RETURN_CONTEXT
, (DECODE (RETURN_CONTEXT
, 'INVOICE'
, RETURN_ATTRIBUTE1
, NULL))
, (DECODE (RETURN_CONTEXT
, 'PO'
, RETURN_ATTRIBUTE2
, 'ORDER'
, RETURN_ATTRIBUTE2
, 'INVOICE'
, RETURN_ATTRIBUTE2
, NULL))
, (DECODE (RETURN_CONTEXT
, 'ORDER'
, RETURN_ATTRIBUTE1
, NULL))
, (DECODE (RETURN_CONTEXT
, 'PO'
, RETURN_ATTRIBUTE1
, NULL))
, (DECODE (RETURN_CONTEXT
, 'SERIAL'
, RETURN_ATTRIBUTE1
, NULL))
, (DECODE (RETURN_CONTEXT
, 'SERIAL'
, RETURN_ATTRIBUTE2
, NULL))
, (DECODE (RETURN_CONTEXT
, 'INVOICE'
, RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2
, 'ORDER'
, RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2
, 'PO'
, RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2
, 'SERIAL'
, RETURN_CONTEXT || '-' || RETURN_ATTRIBUTE1 || '-' || RETURN_ATTRIBUTE2
, NULL))
FROM OE_ORDER_LINES_ALL