VIEW: APPS.GL_ALL_BUD_ORGS_VIEW

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'