XLA_LINE_DEFN_JLT_ASSGNS

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

AMB_CONTEXT_CODE APPLICATION_ID EVENT_CLASS_CODE EVENT_TYPE_CODE LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_CODE ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_CODE DESCRIPTION_TYPE_CODE DESCRIPTION_CODE ACTIVE_FLAG OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN INHERIT_DESC_FLAG MPA_HEADER_DESC_CODE MPA_HEADER_DESC_TYPE_CODE MPA_NUM_JE_CODE MPA_GL_DATES_CODE MPA_PRORATION_CODE

Query

SQL_Statement

select AMB_CONTEXT_CODE ,APPLICATION_ID ,EVENT_CLASS_CODE ,EVENT_TYPE_CODE ,JERS_TYPE_CODE as LINE_DEFINITION_OWNER_CODE ,JERS_CODE as LINE_DEFINITION_CODE ,ACCOUNTING_LINE_TYPE_CODE ,ACCOUNTING_LINE_CODE ,DESCRIPTION_TYPE_CODE ,DESCRIPTION_CODE ,'Y' active_flag ,1 as OBJECT_VERSION_NUMBER ,sysdate as CREATION_DATE ,CREATED_BY ,sysdate as LAST_UPDATE_DATE ,LAST_UPDATED_BY ,1 as LAST_UPDATE_LOGIN ,INHERIT_DESC_FLAG ,MPA_HEADER_DESC_CODE ,MPA_HEADER_DESC_TYPE_CODE ,MPA_NUM_JE_CODE ,MPA_GL_DATES_CODE ,MPA_PRORATION_CODE from xla_jers_jlt_lines where side_code != 'LOSS'