VIEW: APPS.JA_CN_LEDGER_LE_BANK_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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