[Home] [Help]
View: GMS_RESG_BC_V
Product: | GMS - Grants Accounting |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.GMS_RESG_BC_V
|
View Text
SELECT GBC.PROJECT_ID
, GBC.AWARD_ID
, GBC.TASK_ID
, GBC.RESOURCE_LIST_MEMBER_ID
, GBC.BUDGET_VERSION_ID
, NVL(PRM.PARENT_MEMBER_ID
, GBC.RESOURCE_LIST_MEMBER_ID) PARENT_MEMBER_ID
, GBC.EXPENDITURE_ITEM_DATE
, GBC.TOP_TASK_ID
, GBC.STATUS_CODE
, GBC.RESULT_CODE
, GBC.ACTUAL_FLAG
, GBC.ENTERED_DR
, GBC.ENTERED_CR
FROM GMS_BC_PACKETS GBC
, PA_RESOURCE_LIST_MEMBERS PRM
WHERE GBC.RESOURCE_LIST_MEMBER_ID = PRM.RESOURCE_LIST_MEMBER_ID
AND SUBSTR(GBC.RESULT_CODE
, 1
, 1) = 'F'
AND GBC.TRANSFERED_FLAG = 'Y'
Columns
Name |
PROJECT_ID |
AWARD_ID |
TASK_ID |
RESOURCE_LIST_MEMBER_ID |
BUDGET_VERSION_ID |
PARENT_MEMBER_ID |
EXPENDITURE_ITEM_DATE |
TOP_TASK_ID |
STATUS_CODE |
RESULT_CODE |
ACTUAL_FLAG |
ENTERED_DR |
ENTERED_CR |