View: GL_LEDGER_LE_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_LEDGER_LE_V

View Text

SELECT LG.LEDGER_ID
, LG.NAME LEDGER_NAME
, LG.SHORT_NAME LEDGER_SHORT_NAME
, CFGDET.OBJECT_ID LEGAL_ENTITY_ID
, LE.NAME LEGAL_ENTITY_NAME
, REG.LOCATION_ID LOCATION_ID
, HRLOCTL.LOCATION_CODE LOCATION_CODE
, HRLOCTL.DESCRIPTION LOCATION_DESCRIPTION
, LG.LEDGER_CATEGORY_CODE
, LG.CURRENCY_CODE
, LG.CHART_OF_ACCOUNTS_ID
, LG.PERIOD_SET_NAME
, LG.ACCOUNTED_PERIOD_TYPE
, LG.SLA_ACCOUNTING_METHOD_CODE
, LG.SLA_ACCOUNTING_METHOD_TYPE
, LG.BAL_SEG_VALUE_OPTION_CODE
, LG.BAL_SEG_COLUMN_NAME
, LG.BAL_SEG_VALUE_SET_ID
, CFG.ACCTG_ENVIRONMENT_CODE
, CFG.CONFIGURATION_ID
, RS.PRIMARY_LEDGER_ID
, RS.RELATIONSHIP_ENABLED_FLAG
FROM GL_LEDGER_CONFIG_DETAILS PRIMDET
, GL_LEDGERS LG
, GL_LEDGER_RELATIONSHIPS RS
, GL_LEDGER_CONFIGURATIONS CFG
, GL_LEDGER_CONFIG_DETAILS CFGDET
, XLE_ENTITY_PROFILES LE
, XLE_REGISTRATIONS REG
, HR_LOCATIONS_ALL_TL HRLOCTL
WHERE RS.APPLICATION_ID = 101
AND ( (RS.TARGET_LEDGER_CATEGORY_CODE = 'SECONDARY'
AND RS.RELATIONSHIP_TYPE_CODE <> 'NONE' ) OR (RS.TARGET_LEDGER_CATEGORY_CODE = 'PRIMARY'
AND RS.RELATIONSHIP_TYPE_CODE = 'NONE' ) OR (RS.TARGET_LEDGER_CATEGORY_CODE = 'ALC'
AND RS.RELATIONSHIP_TYPE_CODE IN ('JOURNAL'
, 'SUBLEDGER') ) )
AND LG.LEDGER_ID = RS.TARGET_LEDGER_ID
AND LG.LEDGER_CATEGORY_CODE = RS.TARGET_LEDGER_CATEGORY_CODE
AND NVL(LG.COMPLETE_FLAG
, 'Y') = 'Y'
AND PRIMDET.OBJECT_ID = RS.PRIMARY_LEDGER_ID
AND PRIMDET.OBJECT_TYPE_CODE = 'PRIMARY'
AND PRIMDET.SETUP_STEP_CODE = 'NONE'
AND CFG.CONFIGURATION_ID = PRIMDET.CONFIGURATION_ID
AND CFGDET.CONFIGURATION_ID (+) = CFG.CONFIGURATION_ID
AND CFGDET.OBJECT_TYPE_CODE (+) = 'LEGAL_ENTITY'
AND LE.LEGAL_ENTITY_ID (+) = CFGDET.OBJECT_ID
AND REG.SOURCE_ID (+) = CFGDET.OBJECT_ID
AND REG.SOURCE_TABLE (+) = 'XLE_ENTITY_PROFILES'
AND REG.IDENTIFYING_FLAG (+) = 'Y'
AND HRLOCTL.LOCATION_ID (+) = REG.LOCATION_ID
AND HRLOCTL.LANGUAGE (+) = USERENV('LANG')

Columns