VIEW: APPS.FUN_SEQ_ASSIGNMENTS_DFV

Source

View Text - Preformatted

SELECT ROWID, CONTROL_ATTRIBUTE_STRUCTURE, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE, 'XLA_AE_PERIOD_CLOSE', BALANCE_TYPE, 'XLA_AE_COMPLETION', BALANCE_TYPE, 'GL_JE_POSTING', BALANCE_TYPE, 'GL_JE_PERIOD_CLOSE', BALANCE_TYPE, NULL)), (DECODE (CONTROL_ATTRIBUTE_STRUCTURE, 'XLA_AE_PERIOD_CLOSE', JOURNAL_SOURCE, 'XLA_AE_COMPLETION', JOURNAL_SOURCE, 'GL_JE_POSTING', JOURNAL_SOURCE, 'GL_JE_PERIOD_CLOSE', JOURNAL_SOURCE, NULL)), (DECODE (CONTROL_ATTRIBUTE_STRUCTURE, 'XLA_AE_PERIOD_CLOSE', JOURNAL_CATEGORY, 'XLA_AE_COMPLETION', JOURNAL_CATEGORY, 'GL_JE_POSTING', JOURNAL_CATEGORY, 'GL_JE_PERIOD_CLOSE', JOURNAL_CATEGORY, NULL)), (DECODE (CONTROL_ATTRIBUTE_STRUCTURE, 'XLA_AE_COMPLETION', DOCUMENT_CATEGORY, NULL)), (DECODE (CONTROL_ATTRIBUTE_STRUCTURE, 'XLA_AE_COMPLETION', ACCOUNTING_EVENT_TYPE, NULL)), (DECODE (CONTROL_ATTRIBUTE_STRUCTURE, 'XLA_AE_COMPLETION', ACCOUNTING_ENTRY_TYPE, NULL)),  
 (DECODE (CONTROL_ATTRIBUTE_STRUCTURE,  
      'GL_JE_PERIOD_CLOSE', CONTROL_ATTRIBUTE_STRUCTURE || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY,  
      'GL_JE_POSTING', CONTROL_ATTRIBUTE_STRUCTURE || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY,  
      'XLA_AE_COMPLETION', CONTROL_ATTRIBUTE_STRUCTURE || '.' || DOCUMENT_CATEGORY || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY || '.' || ACCOUNTING_EVENT_TYPE || '.' || ACCOUNTING_ENTRY_TYPE,  
      'XLA_AE_PERIOD_CLOSE', CONTROL_ATTRIBUTE_STRUCTURE || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY, NULL)) 
 FROM FUN_SEQ_ASSIGNMENTS

View Text - HTML Formatted

SELECT ROWID
, CONTROL_ATTRIBUTE_STRUCTURE
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'XLA_AE_PERIOD_CLOSE'
, BALANCE_TYPE
, 'XLA_AE_COMPLETION'
, BALANCE_TYPE
, 'GL_JE_POSTING'
, BALANCE_TYPE
, 'GL_JE_PERIOD_CLOSE'
, BALANCE_TYPE
, NULL))
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'XLA_AE_PERIOD_CLOSE'
, JOURNAL_SOURCE
, 'XLA_AE_COMPLETION'
, JOURNAL_SOURCE
, 'GL_JE_POSTING'
, JOURNAL_SOURCE
, 'GL_JE_PERIOD_CLOSE'
, JOURNAL_SOURCE
, NULL))
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'XLA_AE_PERIOD_CLOSE'
, JOURNAL_CATEGORY
, 'XLA_AE_COMPLETION'
, JOURNAL_CATEGORY
, 'GL_JE_POSTING'
, JOURNAL_CATEGORY
, 'GL_JE_PERIOD_CLOSE'
, JOURNAL_CATEGORY
, NULL))
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'XLA_AE_COMPLETION'
, DOCUMENT_CATEGORY
, NULL))
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'XLA_AE_COMPLETION'
, ACCOUNTING_EVENT_TYPE
, NULL))
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'XLA_AE_COMPLETION'
, ACCOUNTING_ENTRY_TYPE
, NULL))
, (DECODE (CONTROL_ATTRIBUTE_STRUCTURE
, 'GL_JE_PERIOD_CLOSE'
, CONTROL_ATTRIBUTE_STRUCTURE || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY
, 'GL_JE_POSTING'
, CONTROL_ATTRIBUTE_STRUCTURE || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY
, 'XLA_AE_COMPLETION'
, CONTROL_ATTRIBUTE_STRUCTURE || '.' || DOCUMENT_CATEGORY || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY || '.' || ACCOUNTING_EVENT_TYPE || '.' || ACCOUNTING_ENTRY_TYPE
, 'XLA_AE_PERIOD_CLOSE'
, CONTROL_ATTRIBUTE_STRUCTURE || '.' || BALANCE_TYPE || '.' || JOURNAL_SOURCE || '.' || JOURNAL_CATEGORY
, NULL))
FROM FUN_SEQ_ASSIGNMENTS