[Home] [Help]
View: IGW_EXPENDITURE_CATEGORIES_V
Product: | IGW - Grants Proposal (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ROWID ROW_ID
, EXPENDITURE_CATEGORY
, DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, DESCRIPTION
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_DESCRIPTION_FROM_PA (EXPENDITURE_CATEGORY)) DESCRIPTION
, BUDGET_CATEGORY_CODE
, PERSONNEL_ATTACHED_FLAG
, DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, START_DATE_ACTIVE
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_START_DATE_ACTIVE_FROM_PA(EXPENDITURE_CATEGORY)) START_DATE_ACTIVE
, DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, END_DATE_ACTIVE
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_END_DATE_ACTIVE_FROM_PA (EXPENDITURE_CATEGORY)) END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM IGW_EXPENDITURE_CATEGORIES
WHERE DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, START_DATE_ACTIVE
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_START_DATE_ACTIVE_FROM_PA(EXPENDITURE_CATEGORY)) IS NOT NULL
Columns
Name |
ROW_ID |
EXPENDITURE_CATEGORY |
DESCRIPTION |
BUDGET_CATEGORY_CODE |
PERSONNEL_ATTACHED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |