View: JA_CN_LEDGER_LE_BANK_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JA_CN_LEDGER_LE_BANK_V

View Text

SELECT XEP.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, XEP.NAME LEGAL_ENTITY_NAME
, LG.LEDGER_ID
, RS.PRIMARY_LEDGER_ID
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 XEP
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 XEP.LEGAL_ENTITY_ID=CFGDET.OBJECT_ID