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)), DOCUMENT_CATEGORY, ACCOUNTING_EVENT_TYPE, ACCOUNTING_ENTRY_TYPE, (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))
, DOCUMENT_CATEGORY
, ACCOUNTING_EVENT_TYPE
, ACCOUNTING_ENTRY_TYPE
, (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