View: FUN_SEQ_ASSIGNMENTS_DFV

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FUN_SEQ_ASSIGNMENTS_DFV

View Text

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