VIEW: APPS.MTL_INTERORG_PARAMETERS_DFV

Source

View Text - Preformatted

SELECT ROWID, ATTRIBUTE_CATEGORY, (DECODE (ATTRIBUTE_CATEGORY, 'AX Accounts', ATTRIBUTE7, NULL)), (DECODE (ATTRIBUTE_CATEGORY, 'Global Accounting Engine', ATTRIBUTE8, 'AX Accounts', ATTRIBUTE8, NULL)), (DECODE (ATTRIBUTE_CATEGORY, 'Global Accounting Engine', ATTRIBUTE9, 'AX Accounts', ATTRIBUTE9, NULL)), (DECODE (ATTRIBUTE_CATEGORY, 'Global Accounting Engine', ATTRIBUTE10, 'AX Accounts', ATTRIBUTE10, NULL)), (DECODE (ATTRIBUTE_CATEGORY, 'Global Accounting Engine', ATTRIBUTE7, NULL)),  
 (DECODE (ATTRIBUTE_CATEGORY,  
      'AX Accounts', ATTRIBUTE_CATEGORY || '.' || ATTRIBUTE7 || '.' || ATTRIBUTE8 || '.' || ATTRIBUTE9 || '.' || ATTRIBUTE10,  
      'Global Accounting Engine', ATTRIBUTE_CATEGORY || '.' || ATTRIBUTE8 || '.' || ATTRIBUTE9 || '.' || ATTRIBUTE10 || '.' || ATTRIBUTE7, NULL)) 
 FROM MTL_INTERORG_PARAMETERS

View Text - HTML Formatted

SELECT ROWID
, ATTRIBUTE_CATEGORY
, (DECODE (ATTRIBUTE_CATEGORY
, 'AX ACCOUNTS'
, ATTRIBUTE7
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, 'GLOBAL ACCOUNTING ENGINE'
, ATTRIBUTE8
, 'AX ACCOUNTS'
, ATTRIBUTE8
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, 'GLOBAL ACCOUNTING ENGINE'
, ATTRIBUTE9
, 'AX ACCOUNTS'
, ATTRIBUTE9
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, 'GLOBAL ACCOUNTING ENGINE'
, ATTRIBUTE10
, 'AX ACCOUNTS'
, ATTRIBUTE10
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, 'GLOBAL ACCOUNTING ENGINE'
, ATTRIBUTE7
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, 'AX ACCOUNTS'
, ATTRIBUTE_CATEGORY || '.' || ATTRIBUTE7 || '.' || ATTRIBUTE8 || '.' || ATTRIBUTE9 || '.' || ATTRIBUTE10
, 'GLOBAL ACCOUNTING ENGINE'
, ATTRIBUTE_CATEGORY || '.' || ATTRIBUTE8 || '.' || ATTRIBUTE9 || '.' || ATTRIBUTE10 || '.' || ATTRIBUTE7
, NULL))
FROM MTL_INTERORG_PARAMETERS