XLA_SUBLEDGER_OPTIONS

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
LEDGER_ID APPLICATION_ID PRIMARY_LEDGER_ID SL_COA_MAPPING_ID NAME SLA_LEDGER_ID RELATIONSHIP_ENABLED_FLAG ALC_DEFAULT_CONV_RATE_TYPE ALC_INHERIT_CONVERSION_TYPE ALC_NO_RATE_ACTION_CODE ALC_MAX_DAYS_ROLL_RATE LEDGER_CATEGORY_CODE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE COMPLETION_STATUS_CODE CURRENCY_CODE SHORT_NAME ENABLE_BUDGETARY_CONTROL_FLAG CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME SLA_DESCRIPTION_LANGUAGE SLA_ENTERED_CUR_BAL_SUS_CCID LATEST_ENCUMBRANCE_YEAR SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID RES_ENCUMB_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID BAL_SEG_COLUMN_NAME MGT_SEG_COLUMN_NAME BAL_SEG_VALUE_OPTION_CODE MGT_SEG_VALUE_OPTION_CODE ALLOW_INTERCOMPANY_POST_FLAG ENABLE_AVERAGE_BALANCES_FLAG TRANSACTION_CALENDAR_ID ACCOUNTING_MODE_CODE ACCOUNTING_MODE_OVERRIDE_FLAG SUMMARY_REPORT_FLAG SUMMARY_REPORT_OVERRIDE_FLAG SUBMIT_TRANSFER_TO_GL_FLAG SUBMIT_TRANSFER_OVERRIDE_FLAG SUBMIT_GL_POST_FLAG SUBMIT_GL_POST_OVERRIDE_FLAG ERROR_LIMIT PROCESSES PROCESSING_UNIT_SIZE TRANSFER_TO_GL_MODE_CODE ACCT_REVERSAL_OPTION_CODE ENABLED_FLAG CAPTURE_EVENT_FLAG ROUNDING_RULE_CODE JE_SOURCE_NAME CONTROL_ACCOUNT_TYPE_CODE ALC_ENABLED_FLAG VALUATION_METHOD_FLAG MERGE_ACCT_OPTION_CODE SUSPENSE_ALLOWED_FLAG CALC_SR_BALANCE_FLAG

Name

LEDGER_ID

APPLICATION_ID

PRIMARY_LEDGER_ID

SL_COA_MAPPING_ID

NAME

SLA_LEDGER_ID

RELATIONSHIP_ENABLED_FLAG

ALC_DEFAULT_CONV_RATE_TYPE

ALC_INHERIT_CONVERSION_TYPE

ALC_NO_RATE_ACTION_CODE

ALC_MAX_DAYS_ROLL_RATE

LEDGER_CATEGORY_CODE

SLA_ACCOUNTING_METHOD_CODE

SLA_ACCOUNTING_METHOD_TYPE

COMPLETION_STATUS_CODE

CURRENCY_CODE

SHORT_NAME

ENABLE_BUDGETARY_CONTROL_FLAG

CHART_OF_ACCOUNTS_ID

PERIOD_SET_NAME

SLA_DESCRIPTION_LANGUAGE

SLA_ENTERED_CUR_BAL_SUS_CCID

LATEST_ENCUMBRANCE_YEAR

SLA_BAL_BY_LEDGER_CURR_FLAG

SLA_LEDGER_CUR_BAL_SUS_CCID

RES_ENCUMB_CODE_COMBINATION_ID

ROUNDING_CODE_COMBINATION_ID

BAL_SEG_COLUMN_NAME

MGT_SEG_COLUMN_NAME

BAL_SEG_VALUE_OPTION_CODE

MGT_SEG_VALUE_OPTION_CODE

ALLOW_INTERCOMPANY_POST_FLAG

ENABLE_AVERAGE_BALANCES_FLAG

TRANSACTION_CALENDAR_ID

ACCOUNTING_MODE_CODE

ACCOUNTING_MODE_OVERRIDE_FLAG

SUMMARY_REPORT_FLAG

SUMMARY_REPORT_OVERRIDE_FLAG

SUBMIT_TRANSFER_TO_GL_FLAG

SUBMIT_TRANSFER_OVERRIDE_FLAG

SUBMIT_GL_POST_FLAG

SUBMIT_GL_POST_OVERRIDE_FLAG

ERROR_LIMIT

PROCESSES

PROCESSING_UNIT_SIZE

TRANSFER_TO_GL_MODE_CODE

ACCT_REVERSAL_OPTION_CODE

ENABLED_FLAG

CAPTURE_EVENT_FLAG

ROUNDING_RULE_CODE

JE_SOURCE_NAME

CONTROL_ACCOUNT_TYPE_CODE

ALC_ENABLED_FLAG

VALUATION_METHOD_FLAG

MERGE_ACCT_OPTION_CODE

SUSPENSE_ALLOWED_FLAG

CALC_SR_BALANCE_FLAG

Query

SQL_Statement
SELECT ledg.ledger_id , /* primary or secondary ledger id / subl.application_id , glr.primary_ledger_id , / primary ledger for all ledgers / glr.sl_coa_mapping_id , / COA Account Mapping ID / glr.target_ledger_name name , glr.sla_ledger_id , glr.relationship_enabled_flag , glr.ALC_DEFAULT_CONV_RATE_TYPE , glr.ALC_INHERIT_CONVERSION_TYPE , glr.ALC_NO_RATE_ACTION_CODE , glr.ALC_MAX_DAYS_ROLL_RATE , ledg.ledger_category_code , ledg.sla_accounting_method_code , ledg.sla_accounting_method_type , ledg.completion_status_code , ledg.currency_code , / user key / ledg.short_name , / Ledger Short Name / ledg.enable_budgetary_control_flag , / if budgetary control is used / ledg.chart_of_accounts_id , / Chart of Accounts ID / ledg.period_set_name , / Ledger Calendar / ledg.sla_description_language , / Description Language / ledg.sla_entered_cur_bal_sus_ccid , / entered currency balancing cc_id / ledg.latest_encumbrance_year , ledg.sla_bal_by_ledger_curr_flag , ledg.sla_ledger_cur_bal_sus_ccid , ledg.res_encumb_code_combination_id , ledg.rounding_code_combination_id , ledg.bal_seg_column_name , / column that contains BSV / ledg.mgt_seg_column_name , / column that contains MSV / ledg.bal_seg_value_option_code , ledg.mgt_seg_value_option_code , ledg.allow_intercompany_post_flag , ledg.enable_average_balances_flag , ledg.transaction_calendar_id , popt.accounting_mode_code , popt.accounting_mode_override_flag , popt.summary_report_flag , popt.summary_report_override_flag , popt.submit_transfer_to_gl_flag , popt.submit_transfer_override_flag , popt.submit_gl_post_flag , popt.submit_gl_post_override_flag , popt.error_limit , popt.processes , popt.processing_unit_size , lopt.transfer_to_gl_mode_code , lopt.acct_reversal_option_code , lopt.enabled_flag , lopt.capture_event_flag , lopt.rounding_rule_code , subl.je_source_name , subl.control_account_type_code , subl.alc_enabled_flag , subl.valuation_method_flag , lopt.merge_acct_option_code , ledg.suspense_allowed_flag , lopt.calc_sr_balance_flag FROM gl_ledgers ledg , gl_ledger_relationships glr , xla_launch_options popt , xla_ledger_options lopt , xla_subledgers subl WHERE ledg.ledger_id = glr.target_ledger_id AND ledg.ledger_id = lopt.ledger_id AND lopt.ledger_id = popt.ledger_id (+) AND lopt.application_id = popt.application_id (+) AND subl.application_id = lopt.application_id AND ledg.object_type_code = 'L' / only ledgers ( not ledger sets ) / AND ledg.le_ledger_type_code = 'L' / only legal ledgers */ AND ledg.ledger_category_code in ( 'PRIMARY' , 'SECONDARY' ) AND glr.application_id = 101 AND ( ( glr.relationship_type_code = 'SUBLEDGER' ) OR ( glr.target_ledger_category_code = 'PRIMARY' AND glr.relationship_type_code = 'NONE' ) )

SQL_Statement

SELECT

ledg.ledger_id , /* primary or secondary ledger id */

subl.application_id ,

glr.primary_ledger_id , /* primary ledger for all ledgers */

glr.sl_coa_mapping_id , /* COA Account Mapping ID */

glr.target_ledger_name name ,

glr.sla_ledger_id ,

glr.relationship_enabled_flag ,

glr.ALC_DEFAULT_CONV_RATE_TYPE ,

glr.ALC_INHERIT_CONVERSION_TYPE ,

glr.ALC_NO_RATE_ACTION_CODE ,

glr.ALC_MAX_DAYS_ROLL_RATE ,

ledg.ledger_category_code ,

ledg.sla_accounting_method_code ,

ledg.sla_accounting_method_type ,

ledg.completion_status_code ,

ledg.currency_code , /* user key */

ledg.short_name , /* Ledger Short Name */

ledg.enable_budgetary_control_flag , /* if budgetary control is used */

ledg.chart_of_accounts_id , /* Chart of Accounts ID */

ledg.period_set_name , /* Ledger Calendar */

ledg.sla_description_language , /* Description Language */

ledg.sla_entered_cur_bal_sus_ccid , /* entered currency balancing cc_id */

ledg.latest_encumbrance_year ,

ledg.sla_bal_by_ledger_curr_flag ,

ledg.sla_ledger_cur_bal_sus_ccid ,

ledg.res_encumb_code_combination_id ,

ledg.rounding_code_combination_id ,

ledg.bal_seg_column_name , /* column that contains BSV */

ledg.mgt_seg_column_name , /* column that contains MSV */

ledg.bal_seg_value_option_code ,

ledg.mgt_seg_value_option_code ,

ledg.allow_intercompany_post_flag ,

ledg.enable_average_balances_flag ,

ledg.transaction_calendar_id ,

popt.accounting_mode_code ,

popt.accounting_mode_override_flag ,

popt.summary_report_flag ,

popt.summary_report_override_flag ,

popt.submit_transfer_to_gl_flag ,

popt.submit_transfer_override_flag ,

popt.submit_gl_post_flag ,

popt.submit_gl_post_override_flag ,

popt.error_limit ,

popt.processes ,

popt.processing_unit_size ,

lopt.transfer_to_gl_mode_code ,

lopt.acct_reversal_option_code ,

lopt.enabled_flag ,

lopt.capture_event_flag ,

lopt.rounding_rule_code ,

subl.je_source_name ,

subl.control_account_type_code ,

subl.alc_enabled_flag ,

subl.valuation_method_flag ,

lopt.merge_acct_option_code ,

ledg.suspense_allowed_flag ,

lopt.calc_sr_balance_flag

FROM gl_ledgers ledg ,

gl_ledger_relationships glr ,

xla_launch_options popt ,

xla_ledger_options lopt ,

xla_subledgers subl

WHERE ledg.ledger_id = glr.target_ledger_id

AND ledg.ledger_id = lopt.ledger_id

AND lopt.ledger_id = popt.ledger_id (+)

AND lopt.application_id = popt.application_id (+)

AND subl.application_id = lopt.application_id

AND ledg.object_type_code = 'L' /* only ledgers ( not ledger sets ) */

AND ledg.le_ledger_type_code = 'L' /* only legal ledgers */

AND ledg.ledger_category_code in ( 'PRIMARY' , 'SECONDARY' )

AND glr.application_id = 101

AND ( ( glr.relationship_type_code = 'SUBLEDGER' )

OR ( glr.target_ledger_category_code = 'PRIMARY'

AND glr.relationship_type_code = 'NONE' ) )