View: XLA_SUBLEDGER_OPTIONS_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_SUBLEDGER_OPTIONS_V

View Text

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

Columns