DBA Data[Home] [Help]

VIEW: APPS.RA_CUSTOMER_TRX_LINES_ALL3_DFV

Source

View Text - Preformatted

SELECT ROWID, TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE,  
 TAX_EXEMPT_NUMBER || '.' || TAX_EXEMPT_REASON_CODE || '.' || (DECODE (TAX_EXEMPT_FLAG,  
      'E', TAX_EXEMPT_FLAG,  
      'R', TAX_EXEMPT_FLAG,  
      'S', TAX_EXEMPT_FLAG, NULL)) 
 FROM RA_CUSTOMER_TRX_LINES_ALL
View Text - HTML Formatted

SELECT ROWID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_NUMBER || '.' || TAX_EXEMPT_REASON_CODE || '.' || (DECODE (TAX_EXEMPT_FLAG
, 'E'
, TAX_EXEMPT_FLAG
, 'R'
, TAX_EXEMPT_FLAG
, 'S'
, TAX_EXEMPT_FLAG
, NULL))
FROM RA_CUSTOMER_TRX_LINES_ALL