VIEW: APPS.FII_ALL_LEDGER_V

Source

View Text - Preformatted

SELECT distinct fsa.ledger_id , gsb.name , gsb.description FROM FII_SOURCE_LEDGER_GROUPS slg, FII_SLG_ASSIGNMENTS fsa, GL_LEDGERS_PUBLIC_V gsb WHERE slg.source_ledger_group_id = fsa. source_ledger_group_id AND slg.usage_code = 'DBI' AND gsb.ledger_id = fsa.ledger_id ORDER BY name

View Text - HTML Formatted

SELECT DISTINCT FSA.LEDGER_ID
, GSB.NAME
, GSB.DESCRIPTION
FROM FII_SOURCE_LEDGER_GROUPS SLG
, FII_SLG_ASSIGNMENTS FSA
, GL_LEDGERS_PUBLIC_V GSB
WHERE SLG.SOURCE_LEDGER_GROUP_ID = FSA. SOURCE_LEDGER_GROUP_ID
AND SLG.USAGE_CODE = 'DBI'
AND GSB.LEDGER_ID = FSA.LEDGER_ID ORDER BY NAME