View: GMS_BILL_AWARD_PROJECTS_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_BILL_AWARD_PROJECTS_V

View Text

SELECT PA.PROJECT_ID
, PA.NAME
, PA.SEGMENT1
, GMS.AWARD_NUMBER
, GMS.AWARD_SHORT_NAME
, GMS.ORG_ID
FROM PA_PROJECTS_ALL PA
, GMS_AWARDS GMS
WHERE PA.PROJECT_ID=GMS.AWARD_PROJECT_ID
AND PA_SECURITY.ALLOW_QUERY(PA.PROJECT_ID) = 'Y' ORDER BY LOWER(PA.SEGMENT1)

Columns