VIEW: APPS.XLA_LEDGER_RELATIONSHIPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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