VIEW: APPS.XLA_EVT_CLASS_ACCT_ATTRS_FVL

Source

View Text - Preformatted

SELECT eca.rowid row_id ,eca.application_id application_id ,eca.event_class_code event_class_code ,eca.source_application_id source_application_id ,eca.source_type_code source_type_code ,eca.source_code source_code ,eca.accounting_attribute_code accounting_attribute_code ,eca.default_flag default_flag ,eca.assignment_owner_code assignment_owner_code ,aal.name accounting_attribute_name ,lkp1.meaning assignment_owner_dsp ,aal.journal_entry_level_code journal_entry_level_code ,lkp2.meaning journal_entry_level_name ,sou.name source_name ,lkp3.meaning source_type_dsp ,aal.assignment_group_code assignment_group_code ,lkp4.meaning assignment_group_name ,aal.datatype_code datatype_code ,aal.assignment_required_code assignment_required_code ,aal.assignment_level_code assignment_level_code ,eca.creation_date creation_date ,eca.created_by created_by ,eca.last_update_date last_update_date ,eca.last_updated_by last_updated_by ,eca.last_update_login last_update_login FROM xla_evt_class_acct_attrs eca ,xla_sources_vl sou ,xla_acct_attributes_vl aal ,xla_lookups lkp1 ,xla_lookups lkp2 ,xla_lookups lkp3 ,xla_lookups lkp4 WHERE eca.source_application_id = sou.application_id AND eca.source_code = sou.source_code AND eca.source_type_code = sou.source_type_code AND eca.accounting_attribute_code = aal.accounting_attribute_code AND eca.assignment_owner_code = lkp1.lookup_code AND lkp1.lookup_type = 'XLA_OWNER_TYPE' AND aal.journal_entry_level_code = lkp2.lookup_code AND lkp2.lookup_type = 'XLA_JOURNAL_ENTRY_LEVEL_TYPE' AND eca.source_type_code = lkp3.lookup_code AND lkp3.lookup_type = 'XLA_SOURCE_TYPE' AND aal.assignment_group_code = lkp4.lookup_code (+) AND lkp4.lookup_type (+) = 'XLA_ACCT_ATTR_ASSGN_GROUP'

View Text - HTML Formatted

SELECT ECA.ROWID ROW_ID
, ECA.APPLICATION_ID APPLICATION_ID
, ECA.EVENT_CLASS_CODE EVENT_CLASS_CODE
, ECA.SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, ECA.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, ECA.SOURCE_CODE SOURCE_CODE
, ECA.ACCOUNTING_ATTRIBUTE_CODE ACCOUNTING_ATTRIBUTE_CODE
, ECA.DEFAULT_FLAG DEFAULT_FLAG
, ECA.ASSIGNMENT_OWNER_CODE ASSIGNMENT_OWNER_CODE
, AAL.NAME ACCOUNTING_ATTRIBUTE_NAME
, LKP1.MEANING ASSIGNMENT_OWNER_DSP
, AAL.JOURNAL_ENTRY_LEVEL_CODE JOURNAL_ENTRY_LEVEL_CODE
, LKP2.MEANING JOURNAL_ENTRY_LEVEL_NAME
, SOU.NAME SOURCE_NAME
, LKP3.MEANING SOURCE_TYPE_DSP
, AAL.ASSIGNMENT_GROUP_CODE ASSIGNMENT_GROUP_CODE
, LKP4.MEANING ASSIGNMENT_GROUP_NAME
, AAL.DATATYPE_CODE DATATYPE_CODE
, AAL.ASSIGNMENT_REQUIRED_CODE ASSIGNMENT_REQUIRED_CODE
, AAL.ASSIGNMENT_LEVEL_CODE ASSIGNMENT_LEVEL_CODE
, ECA.CREATION_DATE CREATION_DATE
, ECA.CREATED_BY CREATED_BY
, ECA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ECA.LAST_UPDATED_BY LAST_UPDATED_BY
, ECA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_EVT_CLASS_ACCT_ATTRS ECA
, XLA_SOURCES_VL SOU
, XLA_ACCT_ATTRIBUTES_VL AAL
, XLA_LOOKUPS LKP1
, XLA_LOOKUPS LKP2
, XLA_LOOKUPS LKP3
, XLA_LOOKUPS LKP4
WHERE ECA.SOURCE_APPLICATION_ID = SOU.APPLICATION_ID
AND ECA.SOURCE_CODE = SOU.SOURCE_CODE
AND ECA.SOURCE_TYPE_CODE = SOU.SOURCE_TYPE_CODE
AND ECA.ACCOUNTING_ATTRIBUTE_CODE = AAL.ACCOUNTING_ATTRIBUTE_CODE
AND ECA.ASSIGNMENT_OWNER_CODE = LKP1.LOOKUP_CODE
AND LKP1.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND AAL.JOURNAL_ENTRY_LEVEL_CODE = LKP2.LOOKUP_CODE
AND LKP2.LOOKUP_TYPE = 'XLA_JOURNAL_ENTRY_LEVEL_TYPE'
AND ECA.SOURCE_TYPE_CODE = LKP3.LOOKUP_CODE
AND LKP3.LOOKUP_TYPE = 'XLA_SOURCE_TYPE'
AND AAL.ASSIGNMENT_GROUP_CODE = LKP4.LOOKUP_CODE (+)
AND LKP4.LOOKUP_TYPE (+) = 'XLA_ACCT_ATTR_ASSGN_GROUP'