[Home] [Help]
View: GL_ENTITY_BUDGETS_V
View Text
SELECT /* $HEADER: GLGVWREG.LDT 120.16.12010000.5 2009/02/11 04:46:50 KMOTEPAL SHIP $ */ EB.FROZEN_FLAG FROZEN_FLAG
, BE.NAME NAME
, EB.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, EB.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BE.STATUS_CODE STATUS_CODE
, EB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EB.LAST_UPDATED_BY LAST_UPDATED_BY
, EB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EB.ROWID ROW_ID
FROM GL_ENTITY_BUDGETS EB
, GL_BUDGET_ENTITIES BE
WHERE EB.BUDGET_ENTITY_ID = BE.BUDGET_ENTITY_ID AND BE.STATUS_CODE <> 'D'
Columns
Name |
FROZEN_FLAG |
NAME |
BUDGET_ENTITY_ID |
BUDGET_VERSION_ID |
STATUS_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
ROW_ID |