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