DBA Data[Home] [Help]

VIEW: APPS.GL_BUDGET_ENTITIES_UNFROZEN_V

Source

View Text - Preformatted

SELECT bec.name, bec.budget_entity_id, bec.budget_password_required_flag, bec.encrypted_budget_password, eb.budget_version_id, bec.ledger_id, bec.use_privilege FROM gl_budget_entities_current_v bec, gl_entity_budgets eb WHERE bec.budget_entity_id = eb.budget_entity_id AND eb.frozen_flag = 'N'
View Text - HTML Formatted

SELECT BEC.NAME
, BEC.BUDGET_ENTITY_ID
, BEC.BUDGET_PASSWORD_REQUIRED_FLAG
, BEC.ENCRYPTED_BUDGET_PASSWORD
, EB.BUDGET_VERSION_ID
, BEC.LEDGER_ID
, BEC.USE_PRIVILEGE
FROM GL_BUDGET_ENTITIES_CURRENT_V BEC
, GL_ENTITY_BUDGETS EB
WHERE BEC.BUDGET_ENTITY_ID = EB.BUDGET_ENTITY_ID
AND EB.FROZEN_FLAG = 'N'