FND Design Data [Home] [Help]

View: GL_ALL_BUD_ORGS_VIEW

Product: GL - General Ledger
Description: Review accounts for all budget organizations
Implementation/DBA Data: ViewAPPS.GL_ALL_BUD_ORGS_VIEW
View Text

SELECT BUDGET_ENTITY_ID
, NAME
, LEDGER_ID
, DESCRIPTION
FROM GL_BUDGET_ENTITIES
WHERE STATUS_CODE <> 'D' UNION SELECT -1
, MEANING
, -1
, DESCRIPTION
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL'

Columns

Name
BUDGET_ENTITY_ID
NAME
LEDGER_ID
DESCRIPTION