XLA_ACCT_LINE_TYPES

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
row_id AMB_CONTEXT_CODE APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_CODE TRANSACTION_COA_ID ACCOUNTING_ENTRY_TYPE_CODE NATURAL_SIDE_CODE GL_TRANSFER_MODE_CODE SWITCH_SIDE_FLAG MERGE_DUPLICATE_CODE ENABLED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ACCOUNTING_CLASS_CODE BUSINESS_METHOD_CODE BUSINESS_CLASS_CODE ROUNDING_CLASS_CODE NAME DESCRIPTION MPA_OPTION_CODE ENCUMBRANCE_TYPE_ID GAIN_OR_LOSS_FLAG CROSS_LEDGER_BALANCING_FLAG OBJECT_VERSION_NUMBER MULTIPERIOD_CLASS_CODE MULTIPERIOD_OPTION_FLAG

Name

row_id

AMB_CONTEXT_CODE

APPLICATION_ID

ENTITY_CODE

EVENT_CLASS_CODE

ACCOUNTING_LINE_TYPE_CODE

ACCOUNTING_LINE_CODE

TRANSACTION_COA_ID

ACCOUNTING_ENTRY_TYPE_CODE

NATURAL_SIDE_CODE

GL_TRANSFER_MODE_CODE

SWITCH_SIDE_FLAG

MERGE_DUPLICATE_CODE

ENABLED_FLAG

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

ACCOUNTING_CLASS_CODE

BUSINESS_METHOD_CODE

BUSINESS_CLASS_CODE

ROUNDING_CLASS_CODE

NAME

DESCRIPTION

MPA_OPTION_CODE

ENCUMBRANCE_TYPE_ID

GAIN_OR_LOSS_FLAG

CROSS_LEDGER_BALANCING_FLAG

OBJECT_VERSION_NUMBER

MULTIPERIOD_CLASS_CODE

MULTIPERIOD_OPTION_FLAG

Query

SQL_Statement
SELECT b.rowid row_id ,b.amb_context_code ,b.application_id ,b.entity_code ,b.event_class_code ,b.accounting_line_type_code ,b.accounting_line_code ,b.transaction_coa_id ,b.accounting_entry_type_code ,b.natural_side_code ,b.gl_transfer_mode_code ,b.switch_side_flag ,b.merge_duplicate_code ,b.enabled_flag ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login ,b.accounting_class_code ,b.business_method_code ,b.business_class_code ,b.rounding_class_code ,t.name ,t.description ,b.mpa_option_code ,b.encumbrance_type_id ,b.gain_or_loss_flag, b.cross_ledger_balancing_flag, b.OBJECT_VERSION_NUMBER, b.multiperiod_class_code, b.multiperiod_option_flag FROM xla_acct_line_types_tl t ,xla_acct_line_types_b b WHERE b.application_id = t.application_id AND b.amb_context_code = t.amb_context_code AND b.entity_code = t.entity_code AND b.event_class_code = t.event_class_code AND b.accounting_line_type_code = t.accounting_line_type_code AND b.accounting_line_code = t.accounting_line_code AND t.language = USERENV('LANG')

SQL_Statement

SELECT b.rowid row_id ,b.amb_context_code ,b.application_id ,b.entity_code ,b.event_class_code ,b.accounting_line_type_code ,b.accounting_line_code ,b.transaction_coa_id ,b.accounting_entry_type_code ,b.natural_side_code ,b.gl_transfer_mode_code ,b.switch_side_flag ,b.merge_duplicate_code ,b.enabled_flag ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login ,b.accounting_class_code ,b.business_method_code ,b.business_class_code ,b.rounding_class_code ,t.name ,t.description ,b.mpa_option_code ,b.encumbrance_type_id ,b.gain_or_loss_flag, b.cross_ledger_balancing_flag, b.OBJECT_VERSION_NUMBER, b.multiperiod_class_code, b.multiperiod_option_flag FROM xla_acct_line_types_tl t ,xla_acct_line_types_b b WHERE b.application_id = t.application_id AND b.amb_context_code = t.amb_context_code AND b.entity_code = t.entity_code AND b.event_class_code = t.event_class_code AND b.accounting_line_type_code = t.accounting_line_type_code AND b.accounting_line_code = t.accounting_line_code AND t.language = USERENV('LANG')