XLA_LEDGER_RELATIONSHIPS

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
LEDGER_ID TARGET_LEDGER_ID SLA_LEDGER_ID NAME SHORT_NAME PRIMARY_LEDGER_ID LEDGER_CATEGORY_CODE ENABLE_BUDGETARY_CONTROL_FLAG CURRENCY_CODE CHART_OF_ACCOUNTS_ID SL_COA_MAPPING_ID PERIOD_SET_NAME COMPLETION_STATUS_CODE RELATIONSHIP_TYPE_CODE RELATIONSHIP_ENABLED_FLAG LATEST_OPENED_PERIOD_NAME SLA_DESCRIPTION_LANGUAGE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_ENTERED_CUR_BAL_SUS_CCID BAL_SEG_COLUMN_NAME MGT_SEG_COLUMN_NAME SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID LATEST_ENCUMBRANCE_YEAR ALC_INHERIT_CONVERSION_TYPE ALC_DEFAULT_CONV_RATE_TYPE ALC_NO_RATE_ACTION_CODE ALC_MAX_DAYS_ROLL_RATE COMPLETE_FLAG

Name

LEDGER_ID

TARGET_LEDGER_ID

SLA_LEDGER_ID

NAME

SHORT_NAME

PRIMARY_LEDGER_ID

LEDGER_CATEGORY_CODE

ENABLE_BUDGETARY_CONTROL_FLAG

CURRENCY_CODE

CHART_OF_ACCOUNTS_ID

SL_COA_MAPPING_ID

PERIOD_SET_NAME

COMPLETION_STATUS_CODE

RELATIONSHIP_TYPE_CODE

RELATIONSHIP_ENABLED_FLAG

LATEST_OPENED_PERIOD_NAME

SLA_DESCRIPTION_LANGUAGE

SLA_ACCOUNTING_METHOD_CODE

SLA_ACCOUNTING_METHOD_TYPE

SLA_ENTERED_CUR_BAL_SUS_CCID

BAL_SEG_COLUMN_NAME

MGT_SEG_COLUMN_NAME

SLA_BAL_BY_LEDGER_CURR_FLAG

SLA_LEDGER_CUR_BAL_SUS_CCID

LATEST_ENCUMBRANCE_YEAR

ALC_INHERIT_CONVERSION_TYPE

ALC_DEFAULT_CONV_RATE_TYPE

ALC_NO_RATE_ACTION_CODE

ALC_MAX_DAYS_ROLL_RATE

COMPLETE_FLAG

Query

SQL_Statement
SELECT ledger_id, target_ledger_id, sla_ledger_id, name, short_name, primary_ledger_id, ledger_category_code, enable_budgetary_control_flag, currency_code, chart_of_accounts_id, glr.sl_coa_mapping_id, period_set_name, completion_status_code, relationship_type_code, relationship_enabled_flag, latest_opened_period_name, sla_description_language, sla_accounting_method_code, sla_accounting_method_type, sla_entered_cur_bal_sus_ccid, bal_seg_column_name, mgt_seg_column_name,sla_bal_by_ledger_curr_flag , sla_ledger_cur_bal_sus_ccid ,latest_encumbrance_year ,glr.ALC_INHERIT_CONVERSION_TYPE ,glr.ALC_DEFAULT_CONV_RATE_TYPE ,glr.ALC_NO_RATE_ACTION_CODE , glr.ALC_MAX_DAYS_ROLL_RATE ,led.complete_flag from gl_ledgers led, gl_ledger_relationships glr where led.ledger_id = glr.target_ledger_id and object_type_code = 'L' and le_ledger_type_code = 'L' and ledger_category_code IN ('PRIMARY', 'SECONDARY', 'ALC') AND ( (glr.relationship_type_code = 'SUBLEDGER') OR (glr.target_ledger_category_code = 'PRIMARY' AND glr.relationship_type_code = 'NONE')) AND glr.application_id = 101

SQL_Statement

SELECT ledger_id, target_ledger_id, sla_ledger_id, name, short_name, primary_ledger_id, ledger_category_code,

enable_budgetary_control_flag, currency_code, chart_of_accounts_id, glr.sl_coa_mapping_id, period_set_name, completion_status_code,

relationship_type_code, relationship_enabled_flag, latest_opened_period_name, sla_description_language, sla_accounting_method_code,

sla_accounting_method_type, sla_entered_cur_bal_sus_ccid, bal_seg_column_name, mgt_seg_column_name,sla_bal_by_ledger_curr_flag ,

sla_ledger_cur_bal_sus_ccid ,latest_encumbrance_year ,glr.ALC_INHERIT_CONVERSION_TYPE ,glr.ALC_DEFAULT_CONV_RATE_TYPE ,glr.ALC_NO_RATE_ACTION_CODE ,

glr.ALC_MAX_DAYS_ROLL_RATE ,led.complete_flag from gl_ledgers led, gl_ledger_relationships glr where led.ledger_id = glr.target_ledger_id and

object_type_code = 'L' and le_ledger_type_code = 'L' and ledger_category_code IN ('PRIMARY', 'SECONDARY', 'ALC') AND ( (glr.relationship_type_code = 'SUBLEDGER') OR (glr.target_ledger_category_code = 'PRIMARY' AND glr.relationship_type_code = 'NONE')) AND glr.application_id = 101