Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_BUDGETARY_CONTROL_TASK_V |
SELECT GBC.ROWID
, PT.TASK_NUMBER
, PT.TASK_NAME
, GBC.PROJECT_ID
, GBC.TASK_ID
, GBC.BUDGETARY_CONTROLS_ID
, GBC.AWARD_ID
, GBC.FUNDS_CONTROL_LEVEL_CODE
, GBC.LAST_UPDATED_BY
, GBC.LAST_UPDATE_DATE
, GBC.CREATED_BY
, GBC.CREATION_DATE
, GBC.LAST_UPDATE_LOGIN
, GBC.RESOURCE_LIST_MEMBER_ID
FROM PA_TASKS PT
, GMS_BUDGETARY_CONTROLS GBC
WHERE PT.TASK_ID = GBC.TASK_ID
AND PT.PROJECT_ID = GBC.PROJECT_ID