VIEW: APPS.GL_ALC_LEDGER_RSHIPS_V

Source

View Text - Preformatted

SELECT SOURCE_LEDGER_ID , TARGET_LEDGER_ID LEDGER_ID , TARGET_LEDGER_NAME NAME , TARGET_LEDGER_SHORT_NAME SHORT_NAME , TARGET_CURRENCY_CODE CURRENCY_CODE , RELATIONSHIP_TYPE_CODE , RELATIONSHIP_ENABLED_FLAG , PRIMARY_LEDGER_ID , APPLICATION_ID , ORG_ID , ALC_DEFAULT_CONV_RATE_TYPE FROM GL_LEDGER_RELATIONSHIPS REL, GL_LEDGERS LGR WHERE target_ledger_category_code = 'ALC' AND relationship_type_code IN ('JOURNAL', 'SUBLEDGER') AND LGR.ledger_id = REL.target_ledger_id AND nvl(LGR.complete_flag, 'Y') = 'Y'

View Text - HTML Formatted

SELECT SOURCE_LEDGER_ID
, TARGET_LEDGER_ID LEDGER_ID
, TARGET_LEDGER_NAME NAME
, TARGET_LEDGER_SHORT_NAME SHORT_NAME
, TARGET_CURRENCY_CODE CURRENCY_CODE
, RELATIONSHIP_TYPE_CODE
, RELATIONSHIP_ENABLED_FLAG
, PRIMARY_LEDGER_ID
, APPLICATION_ID
, ORG_ID
, ALC_DEFAULT_CONV_RATE_TYPE
FROM GL_LEDGER_RELATIONSHIPS REL
, GL_LEDGERS LGR
WHERE TARGET_LEDGER_CATEGORY_CODE = 'ALC'
AND RELATIONSHIP_TYPE_CODE IN ('JOURNAL'
, 'SUBLEDGER')
AND LGR.LEDGER_ID = REL.TARGET_LEDGER_ID
AND NVL(LGR.COMPLETE_FLAG
, 'Y') = 'Y'