XLA_AAD_HEADER_AC_ASSGNS

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 ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_CODE OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT xjsha.AMB_CONTEXT_CODE ,xjsha.APPLICATION_ID ,xjsha.EVENT_CLASS_CODE ,xjsha.EVENT_TYPE_CODE ,xjaa.PRODUCT_RULE_TYPE_CODE ,xjaa.PRODUCT_RULE_CODE ,xjsha.ANALYTICAL_CRITERION_TYPE_CODE ,xjsha.ANALYTICAL_CRITERION_CODE ,xjsha.OBJECT_VERSION_NUMBER ,xjsha.CREATION_DATE ,xjsha.CREATED_BY ,xjsha.LAST_UPDATE_DATE ,xjsha.LAST_UPDATED_BY ,xjsha.LAST_UPDATE_LOGIN from xla_jers_aad_assgns xjaa , xla_jers_sr_hdr_assgns xjsha where xjaa.application_id = xjsha.application_id and xjaa.amb_context_code = xjsha.amb_context_code and xjaa.event_class_code = xjsha.event_class_code and xjaa.event_type_code = xjsha.event_type_code and xjaa.jers_type_code = xjsha.jers_type_code and xjaa.jers_code = xjsha.jers_code and (xjaa.application_id, xjaa.amb_context_code, xjaa.event_class_code, xjaa.event_type_code, xjaa.jers_type_code, xjaa.jers_code) not in (select application_id, amb_context_code, event_class_code, event_type_code ,inherited_jers_type_code, inherited_jers_code from xla_jers_inherited)