VIEW: APPS.XLA_JLT_ACCT_ATTRS_FVL

Source

View Text - Preformatted

SELECT jaa.rowid row_id ,jaa.application_id application_id ,jaa.amb_context_code amb_context_code ,jaa.event_class_code event_class_code ,jaa.accounting_line_type_code accounting_line_type_code ,jaa.accounting_line_code accounting_line_code ,jaa.accounting_attribute_code accounting_attribute_code ,aal.name accounting_attribute_name ,jaa.source_application_id source_application_id ,jaa.source_type_code source_type_code ,jaa.source_code source_code ,sou.name source_name ,lkp1.meaning source_type_dsp ,aal.assignment_group_code assignment_group_code ,lkp2.meaning assignment_group_name ,aal.datatype_code datatype_code ,aal.journal_entry_level_code journal_entry_level_code ,aal.assignment_required_code assignment_required_code ,aal.assignment_level_code assignment_level_code ,decode(jlt.business_method_code,'PRIOR_ENTRY', decode(aal.inherited_flag,'Y','N',jaa.event_class_default_flag),jaa.event_class_default_flag) event_class_default_flag ,decode(jlt.business_method_code,'SAME_ENTRY','N','NONE','N',aal.inherited_flag) inherited_flag ,jaa.creation_date creation_date ,jaa.created_by created_by ,jaa.last_update_date last_update_date ,jaa.last_updated_by last_updated_by ,jaa.last_update_login last_update_login FROM xla_jlt_acct_attrs jaa ,xla_sources_tl sou ,xla_acct_attributes_vl aal ,xla_lookups lkp1 ,xla_lookups lkp2 ,xla_acct_line_types_b jlt WHERE jaa.source_application_id = sou.application_id (+) AND jaa.source_code = sou.source_code (+) AND jaa.source_type_code = sou.source_type_code (+) AND sou.language (+) = USERENV('LANG') AND jaa.accounting_attribute_code = aal.accounting_attribute_code AND jaa.source_type_code = lkp1.lookup_code (+) AND lkp1.lookup_type (+) = 'XLA_SOURCE_TYPE' AND aal.assignment_group_code = lkp2.lookup_code (+) AND lkp2.lookup_type (+) = 'XLA_ACCT_ATTR_ASSGN_GROUP' AND jaa.application_id = jlt.application_id AND jaa.event_class_code = jlt.event_class_code AND jaa.amb_context_code = jlt.amb_context_code AND jaa.accounting_line_type_code = jlt.accounting_line_type_code AND jaa.accounting_line_code = jlt.accounting_line_code

View Text - HTML Formatted

SELECT JAA.ROWID ROW_ID
, JAA.APPLICATION_ID APPLICATION_ID
, JAA.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, JAA.EVENT_CLASS_CODE EVENT_CLASS_CODE
, JAA.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, JAA.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, JAA.ACCOUNTING_ATTRIBUTE_CODE ACCOUNTING_ATTRIBUTE_CODE
, AAL.NAME ACCOUNTING_ATTRIBUTE_NAME
, JAA.SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, JAA.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, JAA.SOURCE_CODE SOURCE_CODE
, SOU.NAME SOURCE_NAME
, LKP1.MEANING SOURCE_TYPE_DSP
, AAL.ASSIGNMENT_GROUP_CODE ASSIGNMENT_GROUP_CODE
, LKP2.MEANING ASSIGNMENT_GROUP_NAME
, AAL.DATATYPE_CODE DATATYPE_CODE
, AAL.JOURNAL_ENTRY_LEVEL_CODE JOURNAL_ENTRY_LEVEL_CODE
, AAL.ASSIGNMENT_REQUIRED_CODE ASSIGNMENT_REQUIRED_CODE
, AAL.ASSIGNMENT_LEVEL_CODE ASSIGNMENT_LEVEL_CODE
, DECODE(JLT.BUSINESS_METHOD_CODE
, 'PRIOR_ENTRY'
, DECODE(AAL.INHERITED_FLAG
, 'Y'
, 'N'
, JAA.EVENT_CLASS_DEFAULT_FLAG)
, JAA.EVENT_CLASS_DEFAULT_FLAG) EVENT_CLASS_DEFAULT_FLAG
, DECODE(JLT.BUSINESS_METHOD_CODE
, 'SAME_ENTRY'
, 'N'
, 'NONE'
, 'N'
, AAL.INHERITED_FLAG) INHERITED_FLAG
, JAA.CREATION_DATE CREATION_DATE
, JAA.CREATED_BY CREATED_BY
, JAA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JAA.LAST_UPDATED_BY LAST_UPDATED_BY
, JAA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_JLT_ACCT_ATTRS JAA
, XLA_SOURCES_TL SOU
, XLA_ACCT_ATTRIBUTES_VL AAL
, XLA_LOOKUPS LKP1
, XLA_LOOKUPS LKP2
, XLA_ACCT_LINE_TYPES_B JLT
WHERE JAA.SOURCE_APPLICATION_ID = SOU.APPLICATION_ID (+)
AND JAA.SOURCE_CODE = SOU.SOURCE_CODE (+)
AND JAA.SOURCE_TYPE_CODE = SOU.SOURCE_TYPE_CODE (+)
AND SOU.LANGUAGE (+) = USERENV('LANG')
AND JAA.ACCOUNTING_ATTRIBUTE_CODE = AAL.ACCOUNTING_ATTRIBUTE_CODE
AND JAA.SOURCE_TYPE_CODE = LKP1.LOOKUP_CODE (+)
AND LKP1.LOOKUP_TYPE (+) = 'XLA_SOURCE_TYPE'
AND AAL.ASSIGNMENT_GROUP_CODE = LKP2.LOOKUP_CODE (+)
AND LKP2.LOOKUP_TYPE (+) = 'XLA_ACCT_ATTR_ASSGN_GROUP'
AND JAA.APPLICATION_ID = JLT.APPLICATION_ID
AND JAA.EVENT_CLASS_CODE = JLT.EVENT_CLASS_CODE
AND JAA.AMB_CONTEXT_CODE = JLT.AMB_CONTEXT_CODE
AND JAA.ACCOUNTING_LINE_TYPE_CODE = JLT.ACCOUNTING_LINE_TYPE_CODE
AND JAA.ACCOUNTING_LINE_CODE = JLT.ACCOUNTING_LINE_CODE