XLA_AAD_HDR_ACCT_ATTRS

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
AMB_CONTEXT_CODE APPLICATION_ID EVENT_CLASS_CODE EVENT_TYPE_CODE PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_CODE ACCOUNTING_ATTRIBUTE_CODE SOURCE_ORIGIN_CODE SOURCE_APPLICATION_ID SOURCE_TYPE_CODE SOURCE_CODE EVENT_CLASS_DEFAULT_FLAG OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT xjaah.AMB_CONTEXT_CODE ,xjaah.APPLICATION_ID ,xjaah.EVENT_CLASS_CODE ,xjaah.EVENT_TYPE_CODE ,xjaa.PRODUCT_RULE_TYPE_CODE ,xjaa.PRODUCT_RULE_CODE ,xjaah.ACCOUNTING_ATTRIBUTE_CODE ,xjaah.SOURCE_ORIGIN_CODE ,xjaah.SOURCE_APPLICATION_ID ,xjaah.SOURCE_TYPE_CODE ,xjaah.SOURCE_CODE ,xjaah.EVENT_CLASS_DEFAULT_FLAG ,xjaah.OBJECT_VERSION_NUMBER ,xjaah.CREATION_DATE ,xjaah.CREATED_BY ,xjaah.LAST_UPDATE_DATE ,xjaah.LAST_UPDATED_BY ,xjaah.LAST_UPDATE_LOGIN from xla_jers_aad_assgns xjaa , xla_jers_attrs_assgns xjaah where xjaa.application_id = xjaah.application_id and xjaa.amb_context_code = xjaah.amb_context_code and xjaa.event_class_code = xjaah.event_class_code and xjaa.event_type_code = xjaah.event_type_code and xjaa.jers_type_code = xjaah.jers_type_code and xjaa.jers_code = xjaah.jers_code