[Home] [Help]
View: GL_ALC_LEDGER_RSHIPS_V
View Text
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'
Columns
Name |
SOURCE_LEDGER_ID |
LEDGER_ID |
LEDGER_NAME |
LEDGER_SHORT_NAME |
CURRENCY_CODE |
RELATIONSHIP_TYPE_CODE |
RELATIONSHIP_ENABLED_FLAG |
PRIMARY_LEDGER_ID |
APPLICATION_ID |
ORG_ID |
ALC_DEFAULT_CONV_RATE_TYPE |