Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_LEDGER_RELATIONSHIPS_V |
SELECT LEDGER_ID
, /* LEDGER ID */ TARGET_LEDGER_ID
, SLA_LEDGER_ID
, NAME
, /* LEDGER NAME */ SHORT_NAME
, /* LEDGER SHORT NAME */ PRIMARY_LEDGER_ID
, /* PRIMARY LEDGER FOR ALL LEDGERS */ LEDGER_CATEGORY_CODE
, ENABLE_BUDGETARY_CONTROL_FLAG
, /* IF BUDGETARY CONTROL IS USED */ CURRENCY_CODE
, /* LEDGER CURRENCY CODE */ CHART_OF_ACCOUNTS_ID
, /* CHART OF ACCOUNTS ID */ GLR.SL_COA_MAPPING_ID
, /* COA ACCOUNT MAPPING ID */ PERIOD_SET_NAME
, /* LEDGER CALENDAR */ COMPLETION_STATUS_CODE
, /* STATUS: COMPLETE
, IN_PROGRESS
, */ /* NOT_STARTED */ RELATIONSHIP_TYPE_CODE
, RELATIONSHIP_ENABLED_FLAG
, /* FOR ALTERNATE CURRENCY LEDGERS */ LATEST_OPENED_PERIOD_NAME
, SLA_DESCRIPTION_LANGUAGE
, /* DESCRIPTION LANGUAGE */ SLA_ACCOUNTING_METHOD_CODE
, /* ACCOUNTING METHOD CODE */ SLA_ACCOUNTING_METHOD_TYPE
, /* OWNER: [U]SER
, [S]YSTEM */ SLA_ENTERED_CUR_BAL_SUS_CCID
, /* ENTERED CURRENCY BALANCING CC_ID */ BAL_SEG_COLUMN_NAME
, /* COLUMN THAT CONTAINS BSV */ MGT_SEG_COLUMN_NAME /* COLUMN THAT CONTAINS MSV */
, 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' /* ONLY LEDGERS (NOT LEDGER SETS) */
AND LE_LEDGER_TYPE_CODE = 'L' /* ONLY LEGAL LEDGERS */
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