[Home] [Help]
View: GMS_AWARD_PROJECTS_V
Product: | GMS - Grants Accounting |
Description: | View of award projects attached to the awards |
Implementation/DBA Data: |
APPS.GMS_AWARD_PROJECTS_V
|
View Text
SELECT A.AWARD_ID
, A.AWARD_NUMBER
, A.AWARD_SHORT_NAME
, A.AWARD_PROJECT_ID
, A.AGREEMENT_ID
, B.SEGMENT1
, B.NAME
, A.ORG_ID
FROM GMS_AWARDS A
, PA_PROJECTS_ALL B
WHERE B.PROJECT_ID = A.AWARD_PROJECT_ID
Columns
Name |
AWARD_ID |
AWARD_NUMBER |
AWARD_SHORT_NAME |
AWARD_PROJECT_ID |
AGREEMENT_ID |
SEGMENT1 |
NAME |
ORG_ID |