VIEW: APPS.XLA_SUBLEDGER_OPTIONS_V

Source

View Text - Preformatted

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 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'))

View Text - HTML Formatted

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
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'))