VIEW: APPS.GL_LEDGER_LE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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